In addition to the ones mentioned, the made for TV movie and then series Skag starring Karl Malden actually had episodes that used the foundry as plot drivers, instead of incidental “he’s an iron-worker” stuff.
Urban planners are extremely rare. The short-lived Mark Brendanawicz character on Parks and Recreation is about it.
Proctologist?
Jeweler?
Jack Nicholson in The Crossing Guard.
Bug in Crossing Jordan.
Hodgins in Bones.
Tree surgeon?
Albert Einstein ?
The excellent 1996 film *The Van *had Colm Meany and Donal O’Kelly start a mobile food vending business.
I challenge anyone to come up with lead roles for the following:
[ul]
[li]knacker[/li][li]computational linguist[/li][li]chicken sexer[/li][li]royal butt-wiper[/li][/ul]
Obviously if we get into more obscure/specialty professions, we’ll start to find a lot of them not represented.
For instance, my job (biomedical technician,) not only has no movies or TV shows with someone in a lead role doing it, I’d bet a lot of money that there is no movie or TV show anywhere that even has a biomedical technician, or even mentions one offhand.
There are a few ones that have biomedical engineers, IIRC (if we’re counting reality shows, then I think it’s Deadliest Warrior that has a biomedical engineer,) but AFAIK no biomed techs. (And we’re really important, too…just try to run a hospital without us and see how long you last, :p)
Tim Allen in Arbor Daze.
OK, so it’s a spoof trailer… But it at least shows that someone in Hollywood had the idea! 
Has anyone said “real estate photographer” yet?
Snow remover: In The Simpsons, Homer drove a snow plow in one episode. “That name again is Mr. Plow!”
Urban planner: In Numb3rs, Alan Eppes was a retired urban planner, and sometimes used knowledge and/or maps to help his sons solve cases.
Given that 99.99% of RE agents either do their own photos or have their assistants do them this really isn’t (in a conventional sense) a primary job or profession except for the merest handful of people who might be doing this (as an actual full time job) for trophy property magazines.
This has already been mentioned and I am not sure that it should count. His profession is Nuke Plant Worker. He did this other thing for one episode out of hundreds.
What about in the 1993 film The Fugitive when Richard Kimble went to the prosthetic department to look up records of patients with a prosthetic arm? There was a woman working in the department when he entered the private office. Presumably she was some sort of biomedical technician.
http://www.imdb.com/title/tt0302244/
I can’t guarantee the Einstein biography movie covers his years as a patent inspector, but I think it would. 1904 was a pretty important year. Based on the Biograpghy I read about him, it sounds like he liked being a patent examiner. He was an inventor himself and enjoyed the opportunity to study other people’s inventions.
I’m not sure I’d call this studying.
Laurence Olivier in Marathon Man
I’d also mention Steve Martin in Little Shop of Horrors, although he wasn’t supposed to be torturing people.
Also Christopher Guest in The Princess Bride was using torture as more of a hobby.
To beat it into the ground of – “The Butcher” is the name of one of the most famous movies ever made. The lead was, you guessed it, a butcher. Not a hero, kind of the opposite, but still, movie was about him, mostly.
Skin Game starting James Garner. He actually made his living selling the same slave over and over again.