It could have a negative connotation. One could be a genuine wise man or essentially a snake oil salesman, so the word could be applied in both ways. It's like how we use "genius" as an insult; we're using the word in an ironic and sarcastic way.

Here is a collection of various uses throughout history:

https://www.oed.com/dictionary/wizard_n?tab=meaning_and_use