Irritating. Uncomfortable person. Inept co worker. Someone or some problem that creates distress. Also used as Pain in the butt.
“A raccoon comes into our yard at night and digs up all my garden, it’s a real pain in the butt.”