Pharmacy Analyst

Hub International

St. Louis (MO)

On-site

USD 75,000 - 110,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

The Pharmacy Analyst at HUB International will serve as a core analytical resource within HUB's national pharmacy analytics team, delivering data-driven analyses and reporting that drive pharmacy benefit consulting decisions across markets.

The role executes sophisticated pharmacy analyses, produces client-ready reports, and translates claims and utilization data into clear insights for Regional Pharmacy Directors and field teams, supporting strategic vendor and contract decisions.

Qualifications

  • Bachelor's degree in finance, economics, mathematics, health administration, pharmacy, or related field.
  • At least 2 years of experience in pharmacy analytics in PBM, health plan, or related organization.
  • Hands-on experience with pharmacy claims data at NDC level, AWP, MAC, dispensing fees, days' supply, brand/generic classification.
  • Strong Excel skills with large datasets, pivot tables, lookups, scenario modeling, and auditing.
  • Knowledge of PBM pricing terms (AWP discounts, rebates, spread pricing, pass-through, MAC lists).
  • Attention to detail and data validation before outputs to accounts.
  • Ability to manage several concurrent tasks.

Responsibilities

  • Lead RFP analytics and financial modeling to compare pricing structures and contract terms.
  • Analyze pharmacy benefit data from multiple sources to identify trends and savings.
  • Coordinate RFP timelines, evaluate responses with scorecards, and track activity for internal reporting.
  • Produce client-ready Excel workbooks and PowerPoint decks following HUB brand standards.
  • Draft executive summaries translating pricing analyses for HR and finance audiences.

Skills

Advanced Excel
Data validation
Pivot tables
Scenario modeling
Formula auditing
NDC data knowledge

Education

Bachelor's degree in finance or related field
Experience in pharmacy analytics

Tools

Excel
PowerPoint

Job description

A path for every ambition.

At HUB, we believe the best work happens when people are given real space to grow and then given the autonomy to exercise it. We power progress and protect ambition: for the clients who count on us, and equally for the people who make that possible every day.

We're creative thinkers and determined doers, guided by values that show up in how we work together: with empathy, adaptability, accountability and a genuine commitment to one another's success. We foster bold ideas, celebrate curiosity and share what we know. Because when people grow, the work they do grows with them.

Our purpose is deeply human: to help people navigate the world on their terms, at their speed, toward their future. We hold that same commitment to the people building careers here.

Whether you're starting out or leveling up, you'll find the resources to evolve, the support to take on more and a team ready to back you at every stage.

Your ambition has a home here.

ABOUT US

At HUB International, we are a team of entrepreneurs. We believe in protecting and supporting the aspirations of individuals, families, and businesses. We help our clients evaluate their risks and develop solutions tailored to their needs. We believe in empowering our employees to learn, grow, and make a difference. Our structure enables our teams to maintain their own unique, regional culture while leveraging support and resources from our corporate centers of excellence.

HUB is a global insurance and employee benefits broker, providing a boundaryless array of business insurance, employee benefits, risk services, personal insurance, retirement, and private wealth management products and services. With over $5 billion in revenue and almost 20,000 employees in 700 offices throughout North America, HUB has grown substantially, in part due to our industry leading success in mergers and acquisitions.

Position Summary

The Pharmacy Analyst will serve as a core analytical resource within HUB's national pharmacy analytics team, delivering data-driven analyses and reporting that drive pharmacy benefit consulting decisions across all markets. This position is responsible for executing sophisticated pharmacy analyses, producing actionable client-ready reports, and translating complex claims and utilization data into clear insights for Regional Pharmacy Directors and field teams. The successful candidate brings strong analytical instincts and pharmacy data expertise and thrives in a fast-paced environment where rigorous, timely analysis directly shapes the advice clients receive on their pharmacy benefit strategies.

Key Responsibilities
  • RFP Analytics & Financial Modeling
    Lead the financial and analytical evaluation of PBM proposals, turning vendor responses into clear, comparable insights for plan sponsors.
    Utilize financial models and cost projections to compare pricing structures, contract terms, and program options.
    Identify discrepancies, gaps, and terms that need vendor clarification, and make sure evaluations are consistent and defensible.
    Analyze pharmacy benefit data from multiple sources, including claims, utilization, clinical program, and market data, to uncover trends and savings opportunities.
    Support strategic recommendations by quantifying the financial impact of vendor, contract, and plan design decisions.
  • RFP Process Management
    Coordinate RFP timelines across multiple PBM vendors per engagement, including distributing questionnaires, tracking responses, and managing finalist rounds.
    Evaluate vendor questionnaire responses using weighted scorecards and summarize strengths, gaps, and risks.
    Maintain the practice's RFP activity tracking, including project volume, outcomes, and revenue by vendor, for internal reporting.
  • Deliverables & Client Support
    Produce client-ready Excel workbooks and PowerPoint decks that follow HUB brand standards.
    Draft executive summaries that translate technical pricing analysis into clear recommendations for HR and finance audiences.
    Support consultants and account managers in finalist presentations, client meetings, and contract negotiation preparation.
Required Qualifications
  • Bachelor's degree in finance, economics, mathematics, health administration, pharmacy, or a related field, or equivalent experience.
  • At least 2 years of experience in pharmacy analytics , gained at a PBM, health plan, benefits consultancy, pharmacy benefit coalition, 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 con
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Pharmacy Analyst
Pharmacy Analyst

5H0 Hub International Limited • Town and Country (MO)

On-site
USD 80,000 - 95,000
Health benefits
401(k) matching
Paid time off
Pharmacy Analyst
Pharmacy Analyst

Hub International • Chicago (IL)

On-site
USD 80,000 - 95,000
Competitive pay and benefits
Generous paid time off
Wellbeing program
+1
Pharmacy Analytics Specialist – Data-Driven PBM Insights
Pharmacy Analytics Specialist – Data-Driven PBM Insights

5H0 Hub International Limited • Town and Country (MO)

On-site
USD 80,000 - 95,000
Health benefits
401(k) matching
Paid time off
Pharmacy Analytics Specialist
Pharmacy Analytics Specialist

Hub International • Chicago (IL)

On-site
USD 80,000 - 95,000
Competitive pay and benefits
Generous paid time off
Wellbeing program
+1
Pharmacy Analytics Specialist - Data-Driven PBM Insights
Pharmacy Analytics Specialist - Data-Driven PBM Insights

Hub International • St. Louis (MO)

On-site
USD 75,000 - 110,000
Pharmacy Data Analyst
Pharmacy Data Analyst

The Health Plan (THP) • Wheeling (WV)

On-site
USD 65,000 - 90,000
Pharmacy Analyst I - Employee Benefits
Pharmacy Analyst I - Employee Benefits

Alliant • United States

Remote
USD 70,000 - 100,000
Regional Pharmacy Consultant, (South)
Regional Pharmacy Consultant, (South)

Hub International • Georgia

Hybrid
USD 80,000 - 110,000
Competitive salaries and benefits
401k matching program
Paid Parental Leave
+1
Regional Pharmacy Consultant, (South)
Regional Pharmacy Consultant, (South)

Hub International • Mayfield (KY)

Hybrid
USD 80,000 - 100,000
Competitive salaries and benefits offerings
401k matching program
Comprehensive Wellness Program
+2
Senior Analyst, Analytic Services
Senior Analyst, Analytic Services

CVS Health • United States

Remote
USD 90,000 - 120,000
Health insurance
Dental and vision coverage
Paid time off
+3