Oliver Wyman Actuarial – Health Consultant

Company: Oliver Wyman Description: Company Overview     The  Health Practice  of  Oliver Wyman  strives to be the consulting firm of choice for clients and employees, and to be recognized as the premier health actuarial consultancy by fostering the power of ideas to lead our industry, consistently helping clients achieve their strategic objectives, and gaining trusted advisor status.  The practice seeks to inspire a team-oriented culture which fosters free flowing ideas, values diversity, and allows for challenges to the status quo. Its colleagues are proud to perform exciting, diverse, and leading-edge work.   Our vision is to discover what lies beyond the obvious, achieve breakthroughs for our clients, and persist as an industry leader. Our mission is to be the leader in the integration of actuarial science, data science, and information technology to solve our clients’ most demanding challenges. We combine traditional actuarial principles with non-traditional solutions and communicate honestly and independently. We believe that diverse perspectives and approaches are business imperatives, and these can only stem from a diverse group of people. Investing in our people and local communities while delivering unequaled value to our clients is core to our mission at Oliver Wyman.

We are seeking a Medicare data professional to support the development of national healthcare data products by translating business requirements into programs and complex queries within the CMS Virtual Research Data Center (VRDC). This role is a backfill for a former VRDC seat holder and will play a key role in extracting, validating, and delivering Medicare-derived datasets used to power client solutions and internal actuarial analysis. The successful candidate will be comfortable working in highly governed data environments and partnering with business stakeholders to reproduce complex business logic in code.

Serve as a key contributor (and VRDC power user) responsible for building and maintaining VRDC programs/queries to extract Medicare data. Translate business requirements and healthcare business logic into implementable technical specifications and VRDC query logic. Develop, test, and validate complex extraction logic to ensure outputs align to business definitions and intended use cases. Support delivery of approved VRDC extracts into the organization’s AWS/Databricks data lake , enabling broader access for actuarial and analytics teams. Perform data quality checks and documentation to support repeatable, auditable extracts and downstream use. Produce and/or support delivery of insights via web-based (HTML) reporting and Excel-based outputs (Power BI/Tableau are not used). Partner with internal stakeholders (e.g., actuaries, analytics leads, product teams) to refine requirements, troubleshoot results, and improve data products. Contribute to building scalable, reusable datasets and processes that support commercialization of Medicare-based data products for external clients (providers, health systems, medical groups).

Required Experience working with CMS Medicare data and familiarity with common Medicare datasets and terminology. Hands-on experience working in the VRDC environment (including understanding of VRDC constraints, workflows, and data model concepts). Strong ability to translate ambiguous business requirements into clear technical logic and executable queries/programs. Proficiency in SQL and experience using Python for data analysis and validation. Practical experience working with datasets in Excel for validation, reconciliation, or client-ready outputs. Demonstrated ability to perform data quality validation and document extraction logic for reuse and governance. Preferred Experience supporting a governed workflow where files require approval prior to download/ingestion . Familiarity with AWS and Databricks and contributing to data lake ingestion