An alternative way of saying asshole. Typically this term is used to describe an individual who may very well be an asshole, but at the same time they are not worthy of your top shelf profanity.
Brian is just a useless turd squeezer. Not an asshole, because asshole would insinuate that , while having a shitty attitude, he actually tries to be a productive member of society.