Definition & Meaning of "a pain in the arse"

They're a pain in the backside, but they can be helpful.

You know, Jack, you may be my friend, but you can be a real pain in the arse sometimes!