$100K - 110K a year
Analyze pharmacy claims data and PBM contracts to develop forecasts and insights that support client decision-making and reporting.
Bachelor's degree with 3+ years in healthcare consulting or pharmacy benefits, strong Excel skills, ability to manage multiple projects, and experience with data visualization and analytics tools.
Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers. The Brown & Brown National Pharmacy Team (NPT) is a team of 200+ teammates from across Brown & Brown, including pharmacists, client service representatives, actuaries, analysts, data engineers, developers, care team coordinators and more. The NPT brought together pharmacy specialist resources from many businesses across Brown & Brown organizing our teammates into three distinct teams: Pharmacy Consulting and Analytics Auditing PillarRx Copay Maximization We are seeking a detail-oriented, data-driven Business Analyst to join our growing team. This position will consist of using data analytics techniques to take an in-depth look at pharmacy claims experience and develop key takeaways that drive informed decision-making for clients. This individual will regularly collaborate with account representatives, pharmacists and industry experts to understand business needs by evaluating trends, building forecasts, and detecting patterns to uncover actionable insights. The ideal candidate has experience with healthcare claims data, PBM contract modeling, or actuarial/financial analysis, and thrives in a fast-paced, client-focused consulting environment. Key Responsibilities Analyze PBM pricing proposals, contracts, and claims datasets to support RFPs, prospects, audits, and overall procurement processes. Maintain and update Excel savings forecast models that provide side-by-side cost comparisons of PBM vendors utilizing client-specific utilization and plan design. Estimate and model PBM rebate performance based on utilization, formulary positioning, and plan contract terms. Develop pharmacy budget forecasts using historical claims data, pipeline trends, and plan design inputs. Collaborate with senior consultants to synthesize findings into client-facing presentations and reports. Conduct ad hoc analyses on formulary changes, plan design scenarios, and trend drivers (i.e., GLP-1’s, specialty utilization, etc.). Stay informed on PBM industry trends, policy updates, and pricing dynamics to bring added context to client deliverables. Work on multiple projects & requests at a time (sometimes with quick turnaround) and be able to prioritize tasks accordingly. Required Qualifications Bachelor’s degree in Actuarial Science, Finance, Data Analytics, Public Health, or related field. 3+ years of relevant working experience in healthcare consulting, pharmacy benefits, health insurance, or data analytics. Pharmaceutical, healthcare or medical data experience. Strong understanding of Microsoft Office tools (Excel, PowerPoint, etc.) with proficiency in Excel Ability to thrive in a fast-paced environment, responding quickly to oversight and following instruction closely, while anticipating needs and developing efficiencies on repeat tasks. Must be able to adapt to change in direction and priorities in a project and deadline-oriented environment. Strong sense of project ownership and the ability to manage high project volume effectively. Excellent problem-solving, critical thinking and analytics skills with the ability to work in a cross-functional team. Outstanding verbal and written communication skills with experience in developing and maintaining effective, collaborative working relationships with clients and internal stakeholders. Self-directed and comfortable supporting the business needs of multiple teams, systems and products. A drive to learn and master new technologies and techniques. Preferred Qualifications VBA, SQL, or any other scripting language experience Experience in project tracking tools (Wrike, Asana, Microsoft Project) Adept in all phases of the product development cycle Broad understanding of business intelligence, reporting and statistics a plus Hands on knowledge of data visualization tools such as Tableau, Power BI, or Alteryx Experience working with self-insured employers or benefits consultants Familiarity with PBM pricing structures (Biosimilar adoption, rebate arrangements, etc.) and drug trend drivers Exposure to actuarial methods for pricing or reserving pharmacy claims Advanced Excel Modeling (i.e., pivot tables, nested formulas, scenario testing) What We Offer Competitive salary and 401(k) Retirement Savings Plan Health, Dental, and Vision benefits Flexible work environment (remote/hybrid options) Generous discretionary time-off Pay Range $100,000.00 - $110,000.00 Annual The pay range provided above is made in good faith and based on our lowest and highest annual salary or hourly rate paid for the role and takes into account years of experience required, geography, and/or budget for the role. Teammate Benefits & Total Well-Being We go beyond standard benefits, focusing on the total well-being of our teammates, including: Health Benefits: Medical/Rx, Dental, Vision, Life Insurance, Disability Insurance Financial Benefits: ESPP; 401k; Student Loan Assistance; Tuition Reimbursement Mental Health & Wellness: Free Mental Health & Enhanced Advocacy Services Beyond Benefits: Paid Time Off, Holidays, Preferred Partner Discounts and more. Not reflective of all benefits. Enrollment waiting periods or eligibility criteria may apply to certain benefits. Benefit details and offerings may vary for subsidiary entities or in specific geographic locations. The Power To Be Yourself As an Equal Opportunity Employer, we are committed to fostering an inclusive environment comprised of people from all backgrounds, with a variety of experiences and perspectives, guided by our Diversity, Inclusion & Belonging (DIB) motto, “The Power to Be Yourself”. We think of ourselves as a team, so we have teammates - not employees. We strive to attract people who are competitive, driven, and disciplined. Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers. Founded in 1939 as a small, two-partner firm, Brown & Brown (NYSE: BRO) and our team of companies have grown into one of the world’s largest insurance brokerages while staying true to our foundation of trust, resilience, and delivering results. With a team that is as connected locally as it is globally, our high-performing, highly collaborative team delivers innovative risk and insurance solutions. We look for individuals who embrace our culture, thrive in a collaborative environment, are driven to grow and succeed, and are committed to always doing what is right. With a unique culture built on integrity, superior capabilities and grit, we value teamwork, trust and courage. We think of ourselves as a team, so we have teammates—not employees, and leaders—not managers. Everything we do is about the greater “WE”—never “me.” While diverse in abilities and experience, we are all connected through our core values, a commitment to our local communities and a shared mission—always doing what is best for our customers. If you are an existing Brown & Brown teammate, please click here to apply to a job on our internal career site.
This job posting was last updated on 8/19/2025