Yes, кем is the instrumental of кто.

As for the words choice in the phrase, well, this is what we say when asking what someone's job is.

Кем ты работаешь? - What's your job? or What do you do?...