Oliver Wyman Actuarial – Health Consultant

Company:

Oliver Wyman

Description:

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

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   

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.  

Job Description  

As a Manager, you will work alongside and learn from Oliver Wyman’s industry leaders and other consultants while contributing to a broad range of client projects. You will eventually have interaction with Oliver Wyman’s clients, which include top tier insurance companies, healthcare systems, regulatory agencies, large employers with captive programs and private equity firms. You 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 practice seeks to 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 development for medical and other A&H products 

• Captive feasibility, funding, reserving, and risk/capital management  

• Merger and acquisition management and support 

• Economic Capital Modeling and Enterprise Risk Management 

• Regulatory support – financial examinations and review of mergers and acquisitions 

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

Qualifications and desired skills  

• Bachelor’s or Master’s degree, preferably in Actuarial Science, Mathematics, Statistics, Finance or a related field  

• Significant progress with actuarial exams, ASA/FSA preferred  

• 5+ years of actuarial experience in the actuarial field, preferably in the health insurance market or healthcare provider market  

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

• Project management skills  

• Track record of and desire for 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 PowerPoint required  

• R, SAS, SQL,VBA, or other programing language experience a plus  

Why Work for Us  
  
The Actuarial Practice of Oliver Wyman seeks to 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 life, introverts and veterans of military service at Oliver Wyman.  

In addition to competitive benefits, the Practice is dedicated to the success of actuarial students in their pursuit to become credentialed actuaries. Oliver 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 increases subsequent to passing exams. Financial incentives such as first-time pass bonuses are provided in addition to the generous salary increases. The Practice’s managers understand the demands and dedication required to 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 at US Benefits | Marsh McLennan.  
  
For more information, please visit our website at www.oliverwyman.com/actuaries.  
 
Marsh McLennan and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.  
  
The applicable base salary range for this role is $80,000 - $135,000.  
  
The base pay offered will be determined on factors such as experience, skills, training, location, certifications, and education, and any applicable minimum wage requirements. Decisions will be determined on 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, tuition assistance, 401K savings and other retirement programs as well as employee assistance programs.  

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 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information, visit oliverwyman.com, or follow us on LinkedIn and X. 

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 [email protected].

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.