Pharmacy Analytics Specialist – Data-Driven PBM Insights

5H0 Hub International Limited; Town and Country (MO); On-site; USD 80,000 - 95,000; Full time

Benefits offered by this job

Health benefits

401(k) matching

Paid time off

Job summary

HUB International is seeking a Pharmacy Analyst to deliver data-driven analyses and reporting that guide pharmacy benefit decisions across markets. You will execute advanced analytics on claims data, produce client-ready reports, and translate complex information into actionable insights for regional leaders.

In this fast-paced role, you will lead PBM proposal evaluations, manage multiple RFPs, and craft executive summaries for HR and finance audiences.

Qualifications

• Bachelor’s degree in finance, economics, mathematics, health administration, pharmacy, or related field, or equivalent experience.
• At least 2 years of experience in pharmacy analytics, gained at a PBM, health plan, benefits consultancy, or similar organization.
• Hands-on experience with pharmacy claims data, including NDC-level data, AWP, MAC, dispensing fees, days’ supply, and brand/generic/specialty classifications.
• Advanced Excel skills, including large datasets, pivot tables, lookups, scenario modeling, and formula auditing.
• Working knowledge of PBM pricing and contract terminology (AWP discounts, rebate guarantees, spread pricing, pass-through, MAC lists, specialty channel management).
• Strong attention to detail and data validation before outputs reach account teams.
• Ability to manage several concurrent projects and deadlines in a fast-paced environment.
• Clear written and verbal communication skills, including explaining technical findings to non-technical audiences.

Responsibilities

• Lead the financial and analytical evaluation of PBM proposals, turning vendor responses into clear, comparable insights for plan sponsors.
• Coordinate RFP timelines across multiple PBM vendors per engagement, including distributing questionnaires, tracking responses, and managing finalist rounds.
• Produce client-ready Excel workbooks and PowerPoint decks that follow HUB brand standards and translate pricing analyses into clear recommendations.

Skills

Pharmacy analytics

Excel proficiency

Data visualization

NDC data experience

PBM pricing knowledge

Attention to detail

Project management

Education

Bachelor's degree in health administration/finance/math/pharmacy or related field

Tools

SQL

Alteryx

Python

R

Power BI

Tableau

Job description

HUB International is seeking a Pharmacy Analyst to deliver data-driven analyses and reporting that guide pharmacy benefit decisions across markets. You will execute advanced analytics on claims data, produce client-ready reports, and translate complex information into actionable insights for regional leaders.

In this fast-paced role, you will lead PBM proposal evaluations, manage multiple RFPs, and craft executive summaries for HR and finance audiences.