Hybrid Pharmacy Analytics Specialist — PBM RFP & Insights

Hub International; St. Louis, Oak Ridge Park, Omaha (MO, LA, NE, OK); Hybrid; USD 80,000 - 95,000; Full time

Benefits offered by this job

Health benefits

Retirement plan (401k)

Paid time off and holidays

Job summary

HUB International in St. Louis, MO, is seeking a Pharmacy Analyst to be a core analytical resource for national pharmacy analytics, delivering data-driven analyses and client-ready reports that shape pharmacy benefit decisions.

The role requires 2+ years in pharmacy analytics, expertise with pharmacy claims data, advanced Excel, and PBM pricing knowledge. This hybrid position offers growth, cross-market collaboration, and a competitive compensation package.

Qualifications

• Bachelor’s degree or equivalent experience in a related field.
• At least 2 years of experience in pharmacy analytics.
• 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 with large datasets, pivots, lookups, and scenario modeling.
• Attention to detail and ability to validate data before outputs to account teams.

Responsibilities

• Lead the financial and analytical evaluation of PBM proposals and provide clear insights for plan sponsors.
• Coordinate RFP timelines across multiple PBM vendors and evaluate responses.
• Produce client-ready Excel workbooks and PowerPoint decks following HUB brand standards.
• Draft executive summaries translating pricing analysis for HR and finance audiences.

Skills

Pharmacy analytics

Advanced Excel

NDC data handling

PBM pricing knowledge

Data validation

Stakeholder communication

Education

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

Tools

SQL

Alteryx

Python

Power BI

Tableau

Job description

HUB International in St. Louis, MO, is seeking a Pharmacy Analyst to be a core analytical resource for national pharmacy analytics, delivering data-driven analyses and client-ready reports that shape pharmacy benefit decisions.

The role requires 2+ years in pharmacy analytics, expertise with pharmacy claims data, advanced Excel, and PBM pricing knowledge. This hybrid position offers growth, cross-market collaboration, and a competitive compensation package.