Pharmacy Analyst

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

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 concurrent projects and deadlines in a fast‑paced environment.
• Clear written and verbal communication skills, including explaining technical findings to non‑technical audiences.

Preferred Qualifications

• 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 (utilization management, formulary strategy, specialty management) and their financial impact.

Core Competencies

• Analytical rigor
• Accuracy under deadlines
• Ownership and follow-through
• strong verbal & written communication
• Professional skepticism
• Collaboration across regions
• growth minded
• team oriented

JOIN OUR TEAM

Do you believe in the power of innovation, collaboration, and transformation? Do you thrive in a supportive and client focused work environment? Are you looking for an opportunity to help build and drive change in a rapidly growing and evolving organization? When you join HUB International , you will be part of a community of learners and doers focused on our Core Values: entrepreneurship, teamwork, integrity, accountability, and service.

What we offer you

We invest in your growth. HUB offers structured training, licensing support, and ongoing development opportunities designed to accelerate your career. Benefits and programs vary based on employment status, role, location, and applicable eligibility requirements.

• Competitive pay with comprehensive health benefits, retirement savings matching, and company-paid life and disability plans
• Generous paid time off, paid parental leave and a wellbeing program designed to support real work/life balance
• A collaborative, high-performing culture with meaningful engagement, community impact through HUB Gives and genuine room to grow your career

The HUB difference

HUB International is one of North America’s largest insurance brokers, delivering risk management, insurance, employee benefits, retirement and wealth management solutions to businesses and individuals across the United States and Canada — through locally led teams backed by national expertise, giving you the agility of a local partner and the reach of a global organization.

Equal Employment Opportunity:

HUB International Limited is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.

Reasonable Accommodations:

HUB International Limited is committed to providing reasonable accommodations to qualified individuals with disabilities throughout the application and hiring process. If you need a reasonable accommodation to access our career site, complete an application, or participate in any part of the hiring process, please contact the Recruiting Team at [e-mail]. This contact information is for accommodation requests only and should not be used to inquire about the status of an application.

E-Verify:

HUB International Limited participates in E-Verify. Please refer to Our Recruiting Process | Applicant Notices: E-Verify Program for additional information.

The expected salary range for this position is $80,000 to $95,000 and will be impacted by factors such as the successful candidate’s skills, experience and working location, as well as the specific position’s business line, scope and level. HUB International is proud to offer comprehensive benefit and total compensation packages which could include health/dental/vision/life/disability insurance, FSA, HSA and 401(k) accounts, paid-time-off benefits such as vacation, sick, personal, floating holidays and company holidays. In addition, eligible annual bonuses, equity and commissions may be available for some positions.