Business Analyst

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”.