Pharmacy Analyst

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.

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.

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 HUBRecruiting@HUBInternational.com. 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.