Pharmacy Analyst

HUB International

. Serve as a core analytical resource within HUB’s national pharmacy analytics team .

Posted 11/12/2026full-timeUnited StatesJuniorMid-Level💰 $80,000 - $95,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in pharmacy analytics, including the ability to analyze claims data and produce actionable insights for decision-making. Proficient in financial modeling and contract evaluation, with strong communication skills to convey complex information to diverse audiences.

Highest-signal resume keywords

Pharmacy Analytics ExperienceAdvanced Excel SkillsSQL ProficiencyPBM Pricing KnowledgeRFP Coordination

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisFinancial ModelingClaims Data AnalysisCost ProjectionsUtilization ManagementScenario ModelingFormula AuditingStatistical AnalysisMarket Data AnalysisVendor Evaluation

Soft Skills

Attention to DetailClear CommunicationProject ManagementCollaborationProblem-Solving

Tools & Technologies

ExcelPower BITableauAlteryxPythonRPowerPoint

Industry Keywords

Pharmacy Benefit ManagerPBM Transparency LegislationERISAClinical ProgramsFormulary Strategy

Tech Stack

Tools & technologies

PythonSQLTableau

About the role

Key responsibilities & impact

Serve as a core analytical resource within HUB’s national pharmacy analytics team
Deliver data-driven analyses and reporting that drive pharmacy benefit consulting decisions across all markets
Execute sophisticated pharmacy analyses
Produce actionable, client-ready reports
Translate complex claims and utilization data into clear insights for Regional Pharmacy Directors and field teams
Lead the financial and analytical evaluation of PBM proposals
Use financial models and cost projections to compare pricing structures, contract terms, and program options
Identify discrepancies, gaps, and terms requiring vendor clarification
Analyze claims, utilization, clinical program, and market data to uncover trends and savings opportunities
Quantify the financial impact of vendor, contract, and plan design decisions
Coordinate RFP timelines across multiple PBM vendors, including questionnaires, response tracking, and finalist rounds
Evaluate vendor questionnaire responses using weighted scorecards and summarize strengths, gaps, and risks
Maintain RFP activity tracking for internal reporting
Produce client-ready Excel workbooks and PowerPoint decks following HUB brand standards
Draft executive summaries for HR and finance audiences
Support consultants and account managers in finalist presentations, client meetings, and contract negotiation preparation

Requirements

What you’ll need

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 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 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
Experience conducting or supporting PBM RFPs, market checks, or claims re-pricing
SQL, Alteryx, Python, R, Power BI, or Tableau experience for larger datasets
Familiarity with ERISA, PBM transparency legislation, and state PBM reform trends
Exposure to clinical programs, including utilization management, formulary strategy, and specialty management, and their financial impact

Benefits

Comp & perks

Comprehensive health benefits
Health, dental, vision, life, and disability insurance
FSA and HSA accounts
401(k) accounts
Retirement savings matching
Paid time off, including vacation, sick, personal, floating holidays, and company holidays
Paid parental leave
Wellbeing program
Eligible annual bonuses
Equity and commissions may be available
Structured training
Licensing support
Ongoing development opportunities
Collaborative, high-performing culture
HUB Gives community impact opportunities