Pharmacy Analytics Specialist

Hub International; Chicago (IL); On-site; USD 80,000 - 95,000; Full time

Benefits offered by this job

Competitive pay and benefits

Generous paid time off

Wellbeing program

Career growth opportunities

Job summary

HUB International is seeking a Pharmacy Analyst to join its national pharmacy analytics team. The role delivers data-driven analyses and client-ready reports to guide pharmacy benefit decisions across markets.

You will translate complex claims data into actionable insights for regional directors and field teams, thriving in a fast-paced environment where rigorous analysis informs client strategy. The position emphasizes strong pharmacy data expertise, analytical rigor, and clear communication,

Qualifications

• Bachelor’s degree or equivalent in a related field as specified.
• At least 2 years of experience in pharmacy analytics in PBM/health plan/benefits space.
• Hands-on experience with pharmacy claims data: NDC, AWP, MAC, dispensing fees, days’ supply, brand/generic.
• Advanced Excel skills with large datasets, pivot tables, lookups, scenario modeling.
• Knowledge of PBM pricing terms (AWP discounts, rebates, spread pricing, pass-through).
• Strong attention to data validation and ability to manage multiple projects.

Responsibilities

• Lead financial and analytical evaluation of PBM proposals.
• Use financial models to compare pricing, contract terms, and program options.
• Identify discrepancies and ensure defensible evaluations.
• Analyze claims data to uncover trends and savings opportunities.
• Quantify financial impact of vendor, contract, and plan design decisions.
• Produce client-ready Excel workbooks and PowerPoint decks.

Skills

Advanced Excel skills

Analytical thinking

Communication

Attention to detail

Project coordination

Education

Bachelor’s degree in finance, economics, mathematics, health administration, pharmacy, or related field

Tools

SQL

Alteryx

Python

R

Power BI

Tableau

Job description

HUB International is seeking a Pharmacy Analyst to join its national pharmacy analytics team. The role delivers data-driven analyses and client-ready reports to guide pharmacy benefit decisions across markets.

You will translate complex claims data into actionable insights for regional directors and field teams, thriving in a fast-paced environment where rigorous analysis informs client strategy. The position emphasizes strong pharmacy data expertise, analytical rigor, and clear communication,