Pharmacoepi is big, and I know of someone who was in the pharmacoepi PhD program at Maryland (not an accredited ASPH/CEPH school of public health, but a strong epi program) and worked at a top pharma company in the epi department. I did my MPH at Drexel and interned at the same company during school. I probably could have stayed but I was applying to med school -- but I'll probably go back someday. Two other people from my program are now at that same company -- one in the epi department, and the other is now working on the clinical trials side after starting in the epi dept. The former concentrated in epi, but the latter concentrated in community health/prevention.
As someone else mentioned, health management/policy is also big. If you have an interest in health finances, then cost-effectiveness analyses are always big with pharmaceutical companies; you need to make your financial case for developing and producing a drug. A backgroun in health economics is therefore valuable.
In terms of the job market, it's true that not all pharma companies will value epidemiologists as much, but just ask those questions when you go interviewing. Every company needs to know about the distribution of the diseases they are developing drugs/vaccines for, whether it's erectile dysfunction or HIV or ovarian cancer, so every company will hire epidemiologists. You may have better luck with a PhD than an MPH; it depends on the company. At the company I worked at, they were fairly willing to pay for you to get your PhD once you got started. Good luck, and feel free to PM me if you have any questions or want details.