Pharma Business Analyst/Reporting Specialist

Mirador Global, now a part of Coeus Holdings, is a consulting firm providing drug commercialization assessment and launch planning services for bio-pharma companies around the world. Our experts have spent much of their careers honing skills unique to bio-pharma such as Strategic Planning, Marketing, Market Access, Pricing, Medical Affairs, and Analytics.

Our areas of focus are:

*Global commercial strategy development

*Portfolio assessment and prioritization

*Payer reimbursement risk assessment & mitigation

*Commercial roadmap and launch planning

*US and global forecasting and asset evaluation

*Data strategy across commercial life cycle & functions

We are looking to add a team member with the following interests and skills:

*Interest in the pharmaceutical industry

*Desire to learn about the intricacies of the industry and the use of data to inform business decisions

*Ability to learn about new products and markets quickly, understanding the nuances that each brand faces both pre-launch and post-launch

Our goal is to bring on a team member that would be a good fit for our culture. We have been a virtual company since our founding in 2016 and have a collaborative approach to working together.

Core Responsibilities:

*Analysis of sales, prescription, medical claims and market access data to enable reporting on client KPIs or business questions; this may be monthly for certain clients or on an ad hoc basis

*Using the analysis to create Powerpoint presentations or Excel workbooks for use by clients

*Collaborating with internal team members to develop insights and recommendations based on the analysis

*Presenting results to clients in conjunction with internal team members

*Managing the reporting cadence (e.g., monthly, quarterly) across clients as needed

*Other analytical projects and internal projects as assigned

Skills & Experience:

*Strong knowledge of MS Excel, MS Access, and MS PowerPoint ·

*Technical skills in 2 of the following are required:

*SAS, Oracle SQL, R Programming, Excel VBA, Tableau, Power BI and Alteryx

*Prior experience with at least 3 of the following datasets:

*Pharmacy claims data (prescription data)

*Medical claims data/anonymized patient level data (APLD)

*EDI transaction data (867, 852, 837, 835)

*Lab values data (Quest)

*EMR data

*Epidemiological data

*Market Access data (lives covered, formulary data, organizational structure)

*Experience with Market Access data is a plus

*Prior experience in any of the following:

*Marketing insights/analytics, forecasting, commercial/sales operations

*Pharmaceutical Forecasting experience is a plus

*Pharmaceutical Report creation and generation is a plus

*Ability to solve client problems and address business questions using data

*Ability to interpret data and provide meaningful insights to clients

*Ability to visualize data in ways that communicate effectively

*Ability to manage projects, both small engagements and parts of large engagements

*Excellent written and verbal communication skills

*Ability to work independently


*Undergraduate or Master’s degree with 5 or more years of relevant pharma analytics or healthcare experience

Mirador Global is an equal opportunity employer and will consider all qualified applicants without discrimination on grounds of disability, sex or sexual orientation, pregnancy or maternity leave status, race or national or ethnic origin, age, religion or belief, gender identity, protected veteran status (if applicable) or any other characteristic protected by law.