A lovable loser, an unsophisticated person. Made famous by Bob and Doug McKenzie, it's the Canadian insult that's somehow affectionate. A hoser is dumb but harmless, like a golden retriever in human form.
"Don't be such a hoser, take off your boots before coming inside, eh."