Pharmacy Analyst
Core
Deliver data-driven pharmacy benefit analyses and reporting to drive consulting decisions for plan sponsors.
Role type
Senior IC pharmacy analyst (financial modeling & RFP analytics)
Builds
Client-ready Excel workbooks, PowerPoint decks, and financial models for pharmacy benefit strategies
Domain
Insurance brokerage / Pharmacy benefit management (PBM)
Required skills
Financial modeling, Pharmacy claims data analysis, Excel (pivot tables, lookups, scenario modeling), RFP evaluation, Contract terminology, Data validation
Preferred skills
SQL, Alteryx, Python, R, Power BI, Tableau, ERISA knowledge, Clinical program financial impact
Technologies
Excel, SQL, Alteryx, Python, R, Power BI, Tableau
Responsibilities
Lead financial evaluation of PBM proposals, Coordinate RFP timelines across vendors, Produce client-ready reports and executive summaries, Analyze pharmacy claims and utilization data to identify savings
Seniority
Mid-level, hands-on IC