Yeah all of these "niche" unicorn jobs are the product of fantasies created by the pharmacy students. Kind of like "if you dream it, it exists". Unfortunately, that's just not realistic,
It can be realistic if the person doing the dreaming has enough experience. That's what I did in my second year of pharmacy school - I sat down and wrote down what my dream job would be. Broke it down to basic elements and compared to job descriptions for actual jobs. Identified the closest match and identified the best path to get there from being a fresh grad as no one would hire me for that job right away. Halfway along the way decided I didn't like where it was heading and took up an offer to try something else. A few years into it I realized that I *am* working in my dream job because I get paid to do exactly what I enjoy doing in my spare time, except with a different subject matter.
I will say that I am happy with my career to date, but I started on this path in an environment that was VERY different and I likely would not have chosen pharmacy today.
1999 - decided on pharmacy as my future career based on the combination of what I was interested in and job prospects
2002 - started working retail
2003 - started pharmacy school fully intending to work retail after graduation; while in school, participated in all kinds of activities and explored different options
2004 - decided what my dream job would be and it turned out not to be retail *surprise, surprise*
2007 - started a fellowship (not in the then-dream field but it would get me there)
2008 - started working in industry in the same field where I did my fellowhip
2010 - got a taste of what I thought would be my dream job, turned out it's not quite what I thought it would be
2011 - switched to a different but related field within industry, something I never even considered but hey, I was offered a chance to try it and I jumped on it
2014 - realized that I am in fact doing exactly what I am meant to be doing and what I enjoy doing
PS My actual 'dream dream' field would have been linguistic anthropology, but even at 18, I knew better than to expect a secure well-paying career with that degree. I still studied languages in my spare time (three different languages as my electives) but I got a practical education which was pretty interesting and quite useful even as far as my ability to manage my and my family's health needs is concerned. And my job today - market research - has more to do with anthropology than it does with pharmacy practice.