Senior Data Engineer (Health Research Team)

Individuals must be legally authorized to work in the United States without the need for immigration support or sponsorship from Milliman now or in the future.â

Millimans Health Research Team (HRT) isseekingan enthusiastic and detail-oriented Senior Data Engineer to join our team under the guidance of the Senior Manager Health Data this role you will designmaintain and enhance data ETL pipelines ensuring the smooth ingestion and transformation of dataultimately destinedfor Databricks. You will primarily work with PythonPySpark and SQL using AWS services like EC2 and S3. Additionally you will process healthcare data through a variety of Milliman tools.

This role is based out of the Milliman office in Chicago IL but candidates hired into this role may work remotely anywhere in the US or in the office on a weekly basis with flexible work arrangements.âTravel to Millimans Chicago office for threeâconsecutiveâdays each quarter isârequired.ââ

Whoâwe are:â

TheâHRTâsupports Milliman products and practices in a variety of capacities.âThese include but are not limited to financial functions client support project management data engineering and data analytics services. As a shared service team we pride ourselvesâonâdelivering high qualityâtimelyâsupport to Millimans clients consultants and leadership teams.ââ

Job Responsibilities:â

• Work closely with key stakeholders to ensure data pipelines meet businessobjectivesand data transformations meet data analyst requirements

• Write incorporate and maintain Databricks notebook scripts within our standard data and tool processing jobs

• Ensure the integrity of the HRTs data pipelines Databrickslakehouse APIs and Millimans products by conducting in-depth validation reviews and by applying data governance and retention policies
• Lead comprehensive data pipeline reviews across HRTs data assets ensuring accuracy completeness consistency and timeliness of healthcare data pipelines and downstream products
• Design develop and execute systematic data validation frameworks to identify anomalies discrepancies and integrity issues within our data pipelines and product tools
• Investigate and document root causes of data pipeline failures partnering with data engineering and analytics teams to implement corrective actions and preventive controls
• Establish and maintain data quality metrics scorecards and dashboards to monitor ongoing pipeline health and communicate findings to stakeholders at all levels

• Deploy workflows into production environments ensuring robust operation monitoring performance and promptly addressing any pipeline issues tomaintainreliability and stability

• Collaborate with other HRT data analytics engineering and project management professionals toidentify propose and implement process enhancements

• Assistin developing ad hoc data workflows which support Health Research Board (HRB) approved initiatives and Milliman practice client projects

• Provide support to Millimans practices via our help desk system by answering a variety of questions most oftenâabout our data assetsâand data use policiesâ

• Collaborate with HRT finance operations and project management teammates through providing technicalâand healthcare dataâexpertiseâ

• Communicateâprogress status issues decisions onâaâregular cadenceââ

Minimumârequirements:â

• A bachelors degree in Computer / Software Engineering Computer Science Information Technology Electrical Engineering Data Science Actuarial Science or similar fields
• 6 years of relevant experience in data engineering or related roles with advanced programming in SQL or Python languages
• Demonstrates a strong capability to consistently produceâhigh qualityâaccurateâdeliverables on schedule and effectively communicate progress outcomes and recommended next actionsâ

• Fouror more years of experience in the following areas:â

• • Building data pipelines for enrollment claims (medical or pharmacy) risk scores or other common healthcare data sources
  • Data modeling and architecture within Databricks or similar cloud-based analytics and AI platforms
  • Utilizing distributed data processing frameworks preferably Apache Spark (PySpark/Spark SQL)
  • Using GitHub for version control code review and branching strategies
  • Applying best data governance and retention practices
  • Practicing intermediate or higher knowledge of other Microsoft Office applications including Teams Word PowerPoint SharePoint and Outlook as well as Adobe Acrobat

• Travel to Millimans Chicago office for threeâconsecutiveâdays each quarter isârequired

Competencies and Behaviors that Support Success in this Role

• Ability to use REST API to perform standard database functions

• Experience migrating between AWS and Azure

• Competent with coding in the SAS Windowing Environment

• General business knowledge of at least two healthcare lines of business ( employer group Medicare Part D Medicaid Dental etc.)

• Exposure toCMS LDSâSAFâdata filesâ

• Proficiencyin performing intermediate Excel skills including complex formulas Power Query or VBA automation

• Experience working in a project management settingâ

• Articulate:âStrong written and verbal communication skills especially communicating technical details to nontechnical audiencesâ

• Collaborative & professional:âPolished demeanor with a consultative approach capable of interacting with influencing and communicating effectively with all levels of health professionals; flexible with a strong work ethic and a team-player attitudeâ

• Enthusiasticâ& coachable:âDisplays aâpositiveâattitude a growth mindset and eagerness to learn;âopen to receiving and integrating feedback effectivelyâ

• Adaptable:Stays up to date with the rapidly evolving data technology landscape

• Resourceful:âService-oriented dependable and tactful with the ability to work independentlyâ

• Trustworthy:âDemonstratesâintegrity and respect for confidentialityâ

• Efficient & organized:âSkilled in prioritizing and managing multiple projects and tasks amidst interruptions and tight deadlinesâ

• Detail-oriented &âsolutions-minded:âTakes pride in their work andâshowcasesâexcellent problem-solving abilityâwhich adds value to the businessâ

The Teamâ

Milliman is one of the leading experts in healthcare financing and delivery. We advise clients on a wide range of issuesfrom assessing the impact of healthcare reform on organizations or populations to streamlining operations while advancing the quality of patient care. Our consulting work is supported by a powerful toolkit of data analytics solutions and informed by the most trusted comprehensive set of cost guidelines in the industry.ââââ

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

Location

This role is based out of the Milliman office in Chicago IL but candidates hired into this role may work remotely anywhere in the US or in the office on a weekly basis with flexible work arrangements. The expected application deadline for this job isAugust 19 2026.

Compensation

The overall salary range for this role is$104900- $ candidatesâresidingâin:â

Alaska California Connecticut Illinois Maryland Massachusetts New Jersey New York City Newark San Jose San Francisco Pennsylvania Virginia Washington or the District of Columbia:â

• $120635â- $199065â

All other states:â

• $104900â- $173100â

A combination of factors will be considered including but not limited to education relevant work experience qualifications skills certifications etc.

Benefits

We offer a comprehensive benefits package designed to support employees health financial security and well-being. Benefits include:

• Medical Dental and Vision Coverage for employees dependents and domestic partners.

• Employee Assistance Program (EAP) Confidential support for personal and work-related challenges.

• 401(k) Plan Includes a company matching program and profit-sharing contributions.

• Discretionary Bonus Program Recognizing employee contributions.

• Flexible Spending Accounts (FSA) Pre-tax savings for dependent care transportation and eligible medical expenses.

• Paid Time Off (PTO) Beginsaccruingon the first day of work. Full-time employeesaccrue15 daysper year and employees working less than full-timeaccruePTO on a prorated basis.

• Holidays A minimum of 10 observed holidays per year.

• Family Building Benefits Includes adoption and fertilityassistance.

• Paid Parental Leave Up to12 weeksof paid leave for employees who meet eligibility criteria.

• Life Insurance & AD&D 100% ofpremiums covered by Milliman.

• Short-Term and Long-Term Disability Fully paid by Milliman.

Equal Opportunityâ

All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation national origin disability or status as a protected veteran.

#LI-CS1 #LI-REMOTE

Required Experience:

Senior IC