It can be at times, but the whole entire act shouldn't be awkward. I think that a lot of awkwardness comes from being self conscious and being stuck in your own head. Just let go and have fun!

Honestly it all depends on who the partner is with. if its just a hook up (i don't recommend) then it could be but if it's your lover then maybe first couple times it could be but over time you get comfortable and it's not awkward at all!!