Oliver Wyman Actuarial – Health Consultant

Oliver Wyman

Job Description

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.

Responsibilities

• 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 organizations 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).

Qualifications 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 patterns.
• Experience producing or supporting HTML/web-based reporting (or working with teams that deliver web-based analytics outputs).
• Background building reusable datasets or data products intended for external client delivery (e.g. healthcare providers systems medical groups).
• Prior experience as a VRDC seat holder or in a similar access-controlled research/data environment.

Company Overview

TheHealth PracticeofOliver Wymanstrives 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 strategicobjectives and gaining trusted advisor practiceseeksto 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.

Job Description

As aManager you will work alongside and learn from Oliver Wymans industry leaders and other consultants while contributing to a broad range of client will eventuallyhave interaction withOliver Wymans clients which include top tier insurance companies healthcare systems regulatory agencies large employers with captive programs and private equity will be part of a motivated and highly knowledgeable team.

The Health Practice of Oliver Wyman is rapidly growing and seeking individuals who are highly motivated to expand our team. The practiceseeksto inspire a collaborative team-based 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.

Potential projects may include:

• Valuation and reserve developmentfor medical and other A&H products

• Captive feasibility fundingreserving and risk/capital management

• Merger and acquisition management and support

• Economic Capital Modeling and Enterprise Risk Management

• Regulatory support financial examinations and review ofmergers and acquisitions

• Support of pricing product development strategy and otherproject work performed within the health practice across all lines of business

Qualifications and desired skills

• Bachelors or Mastersdegree preferably in Actuarial Science Mathematics StatisticsFinanceor a related field

• Significant progresswithactuarial examsASA/FSApreferred

• 5 years of actuarial experience in the actuarial field preferably in thehealth insurancemarket orhealthcareprovider market

• Exceptional organizational skills with an ability to prioritize and handle multiple tasks in a fast-paced work environment

• Project management skills

• Track recordof anddesirefor rapid learning high performance and professional growth

• Excellent written and verbal communication skills with the ability to build strong relationships with clients colleagues and industry stakeholders

• Excellent time management skills

• Understanding of the value of collaboration and the ability to work effectively in a team setting

• Deep critical-thinking skills and problem-solving ability

• Highly motivated individual and willingness to work in a dynamic environment

• Strong skills with MS Excel MS PowerPointrequired

• R SASSQLVBAor other programing languageexperience a plus

Why Work for Us

The Actuarial Practice of Oliver Wymanseeksto invest in its people by fostering a safe and inclusive environment respecting and welcoming different perspectives promoting an ownership culture providing opportunities for individuals to develop their personal brand and celebrating successes and rewarding performance.

There are employee groups for: the LGBT community racially and ethnically diverse employees women family lifeintrovertsand veterans of military service at Oliver Wyman.

In addition to competitive benefits the Practice is dedicated to the success of actuarial students in their pursuitto becomecredentialed Wyman offers a competitive study program which includes paid time off for exam study and exam day financial support for materials reimbursement of exam costs and salary increasessubsequent topassing incentives such as first-time pass bonuses are provided in addition to the generous salary increases. The Practices managers understand the demands and dedicationrequiredto pass actuarial exams and are supportive and flexible with the actuarial students work loads.

Oliver Wyman offers a performance-based pay program that rewards colleagues for the contributions they make to our business results including year-end bonuses based on personal and corporate performance. We also offer an impressive array of benefits. Explore all the benefits offered atUS Benefits Marsh McLennan.

For more information please visit our website McLennan and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.

The applicable base salary range for this role is $80000 - $135000.

The base pay offered will bedeterminedon factors such as experience skills training location certifications and education and any applicable minimum wage requirements. Decisions will bedeterminedon a case-by-case basis.

In addition to the base salary this position may be eligible for performance-based incentives.

We are excited to offer a competitive total rewards package which includes health and welfare benefits tuitionassistance 401Ksavingsand other retirement programs as well as employeeassistanceprograms.

Oliver Wyman is a business of Marsh (NYSE: MRSH) a global leader in risk reinsurance and capital people and investments and management consulting advising clients in 130 countries. With annual revenue of over $27 billion and more than 95000 colleagues Marsh helps build the confidence to thrive through the power of perspective. For more information or follow us onLinkedInandX.

The Actuarial Practice of Oliver Wyman a Marsh business advises clients across a broad spectrum of risk management issues. We are a rapidly growing group with offices expanding across the globe. Our actuaries hold the highest professional qualifications and are nationally recognized as experts in their field(s). We use mathematical and statistical modeling skills and our qualitative assessment methodologies to assist clients in evaluating and addressing risk. Our solutions help clients manage and prepare for the potential financial consequences of uncertain future events. We bring a combination of broad-based expertise with specialized knowledge of specific risks allowing us to provide independent objective advice in the three primary areas of risk: healthcare life and annuity and property and casualty.

Marsh is committed to embracing a diverse inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background disability ethnic origin family duties gender orientation or expression marital status nationality parental status personal or social status political affiliation race religion and beliefs sex/gender sexual orientation or expression skin color veteran status (including protected veterans) or any other characteristic protected by applicable law. If you have a need that requires accommodation please let us know by contacting

Marsh is committed to hybrid work which includes the flexibility of working remotely and the collaboration connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one anchor day per week on which their full team will be together in person.