Position SummaryThe 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 ResponsibilitiesRFP 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 CompetenciesAnalytical rigor • Accuracy under deadlines • Ownership and follow-through • strong verbal & written communication • Professional skepticism • Collaboration across regions • growth minded • team oriented
JOIN OUR TEAMDo 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 youWe 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
