Pharmacy Audit Data Analyst

We are seeking a Pharmacy Audit Data Analyst to join our Pharmacy Benefits Audit team in our San Diego Health practice. In this role you will conduct data analysis on pharmacy claims, financial guarantees, and rebates, translating contract terms into data definitions, business rules, and testable audit logic that quantify how PBMs are performing against their contracts. Day to day, you will work hands-on in SQL with large claims data sets, build and monitor data quality checks, and produce the reports and analytic deliverables that clients and PBMs rely on to resolve disputes.

This position may be performed remotely.

Independent for over 75 years, Milliman delivers market-leading services and solutions to clients worldwide. Today, we are helping companies take on some of the world's most critical and complex issues, including retirement funding and healthcare financing, risk management and regulatory compliance, data analytics, and business transformation.

Milliman invests in skills training and career development and gives all employees access to a variety of learning and mentoring opportunities. Our growing number of Milliman Employee Resource Groups (ERG's) are employee-led communities that influence policy decisions, develop future leaders, and amplify the voices of their constituents. We encourage our employees to give back to their varied professions, including leadership in professional organizations.

Please visit our website () to learn more about Milliman's commitments to our people, inclusion, and sustainability.

Through a team of professionals ranging from actuaries to clinicians, technology specialists to plan administrators, we offer unparalleled expertise in employee benefits, investment consulting, healthcare, life insurance and financial services, and property and casualty insurance.

In this role, you will:

• Perform audit testing of pharmacy claims data against contract terms, including discount and dispensing fee pricing guarantees, administrative fees, and other contractual financial guarantees
• Write, troubleshoot, and optimize SQL queries in SQL Server Management Studio (SSMS) to analyze large pharmacy claims data sets.
• Conduct rebate audits, including minimum rebate guarantee reconciliations, pass-through rebate testing, and rebate credit reviews.
• Translate client and PBM contracts into audit rules by identifying guarantee terms, exclusions, and reporting requirements subject to testing.
• Build and maintain validation checks to confirm data completeness and accuracy before analysis begins.
• Design, document, and implement new audit tests as contract terms, regulatory requirements, and industry standards evolve.
• Prepare client-ready exhibits and reports that clearly communicate audit findings and financial impact.
• Support the resolution process by researching PBM responses and rebuttals and substantiating findings with claim-level detail.
• Clearly identify and communicate data limitations and any findings that cannot be validated with available information.
• Communicate audit findings and data-driven recommendations directly to clients, PBMs, and internal consultants through clear reports and exhibits at key points in the audit lifecycle.
• Respond to ad hoc data requests, including claims data monitoring and one-off data pulls, analyses, or exhibits requested by clients and consultants.
• Contribute to process improvements, automation, and the development of internal audit tools and templates.

• Bachelor's degree, preferably in math, health, science, or business discipline
• 2-6 years of relevant experience that includes:
• Health insurance, Pharmacy benefit design, or PBM industry experience (PBM, health plan, insurance, consulting, or pharmacy operations)
• Working knowledge of pharmacy benefit concepts, including copays/coinsurance, AWP-based pricing, MAC, brand and generic classification, specialty drugs, formulary design, and rebates
• Demonstrated ability to write and troubleshoot SQL queries; experience with SQL Server Management Studio preferred
• Proficiency in Excel, Word, and PowerPoint, including work with large data sets
• Strong analytical, problem-solving, and documentation skills
• Ability to work independently and prioritize competing demands across multiple engagements

• Ability to explain technical terms, data, and analytic concepts in clear, plain language to non-technical audiences, including clients and vendors
• Exceptional…