Oliver Wyman Actuarial - Health Consultant
Core
Develop national healthcare data products by extracting, validating, and delivering Medicare-derived datasets from the CMS Virtual Research Data Center (VRDC) to power client solutions and internal actuarial analysis.
Role type
Senior IC data engineer (healthcare/Medicare)
Builds
Scalable, reusable Medicare-based data products and datasets for external clients (providers, health systems, medical groups)
Domain
Healthcare / Actuarial Science / Data Engineering
Required skills
CMS Medicare data expertise, VRDC environment proficiency, SQL, Python, Excel, data quality validation, technical specification translation
Preferred skills
AWS/Databricks data lake ingestion, governed workflow experience, HTML/web-based reporting, prior VRDC seat holder experience
Responsibilities
Build and maintain VRDC programs/queries to extract Medicare data; Translate business requirements into technical specifications and VRDC query logic; Develop, test, and validate complex extraction logic; Support delivery of approved VRDC extracts into AWS/Databricks data lake; Perform data quality checks and documentation; Produce insights via HTML reporting and Excel outputs; Partner with stakeholders to refine requirements and improve data products
Seniority
Senior, hands-on IC