Pharmacy Analyst

Hub International Insurance•Saint Louis, MO

About The Position

The Pharmacy Analyst serves as a core analytical resource within HUB’s national pharmacy analytics team. The role delivers data-driven analyses and reporting that inform pharmacy benefit consulting decisions across markets. It executes sophisticated pharmacy analyses, produces client-ready reports, and translates 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 works effectively in a fast-paced environment where timely, rigorous analysis shapes client advice on pharmacy benefit strategies. The role leads the financial and analytical evaluation of PBM proposals, using financial models and cost projections to compare pricing structures, contract terms, and program options. It analyzes pharmacy benefit data from claims, utilization, clinical programs, and market sources to identify trends and savings opportunities and to quantify the impact of vendor, contract, and plan-design decisions. It also coordinates RFP processes across PBM vendors, evaluates vendor responses, maintains internal RFP activity tracking, and supports client-facing deliverables and consulting activities. HUB International is a global insurance and employee benefits broker with over $5 billion in revenue, almost 20,000 employees, and 700 offices throughout North America. The expected salary range is $80,000 to $95,000, with actual compensation affected by skills, experience, work location, business line, scope, and level.

Requirements

  • 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 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 working with large datasets, pivot tables, lookups, scenario modeling, and formula auditing.
  • Working knowledge of PBM pricing and contract terminology, including AWP discounts, rebate guarantees, spread pricing, pass-through, MAC lists, and specialty channel management.
  • Strong attention to detail and ability to validate data 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 the ability to explain technical findings to non-technical audiences.

Nice To Haves

  • Experience conducting or supporting PBM RFPs, market checks, or claims re-pricing.
  • Experience with SQL, Alteryx, Python, R, Power BI, or Tableau for larger datasets.
  • Familiarity with ERISA, PBM transparency legislation, and state PBM reform trends.
  • Exposure to clinical programs such as utilization management, formulary strategy, and specialty management, and their financial impact.

Responsibilities

  • Lead financial and analytical evaluations of PBM proposals, turning vendor responses into clear, comparable insights for plan sponsors.
  • Use financial models and cost projections to compare pricing structures, contract terms, and program options.
  • Identify discrepancies, gaps, and terms requiring vendor clarification, and ensure evaluations are consistent and defensible.
  • Analyze pharmacy benefit claims, utilization, clinical program, and market data to identify trends and savings opportunities.
  • Quantify the financial impact of vendor, contract, and plan-design decisions to support strategic recommendations.
  • Coordinate RFP timelines across multiple PBM vendors, including distributing questionnaires, tracking responses, and managing finalist rounds.
  • Evaluate vendor questionnaire responses using weighted scorecards and summarize strengths, gaps, and risks.
  • Maintain internal tracking of RFP activity, including project volume, outcomes, and revenue by vendor.
  • Produce client-ready Excel workbooks and PowerPoint decks following HUB brand standards.
  • Draft executive summaries that explain technical pricing analysis and recommendations to HR and finance audiences.
  • Support consultants and account managers in finalist presentations, client meetings, and contract negotiation preparation.
  • Validate data and maintain accuracy before analysis outputs reach account teams.

Benefits

  • Health, dental, vision, life, and disability insurance.
  • Flexible spending accounts (FSA) and health savings accounts (HSA).
  • 401(k) accounts and retirement savings matching.
  • Paid time off, including vacation, sick, personal, floating holidays, and company holidays.
  • Eligible annual bonuses, equity, and commissions may be available for some positions.
  • Structured training, licensing support, and ongoing development opportunities.
  • Company-paid life and disability plans.
  • Paid parental leave.
  • Wellbeing program.
  • Community impact opportunities through HUB Gives.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service