Here's why:
* Common nouns refer to general people, places, or things (e.g., dog, city, chair).
* Proper nouns refer to specific people, places, or things (e.g., Fido, Paris, Eiffel Tower).
Since "mayor" refers to the general position of a city leader, it's a common noun.