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.Â
Milliman’s Health Research Team (HRT) is seeking an enthusiastic and detail-oriented Senior Data Engineer to join our team, under the guidance of the Senior Manager, Health Data Analytics. In this role, you will design, maintain, and enhance data ETL pipelines, ensuring the smooth ingestion and transformation of data ultimately destined for Databricks. You will primarily work with Python, PySpark, 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 Milliman’s Chicago office for threeconsecutivedays each quarter isrequired.Â
Whowe are:Â
TheHRTsupports 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 ourselvesondelivering high quality,timelysupport to Milliman's clients, consultants, and leadership teams.Â
Job Responsibilities:Â
- Work closely with key stakeholders to ensure data pipelines meet business objectives and 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 HRT’s data pipelines, Databricks lakehouse, APIs, and Milliman’s products by conducting in-depth validation reviews and by applying data governance and retention policiesÂ
- Lead comprehensive data pipeline reviews across HRT's 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, to maintain reliability and stabilityÂ
- Collaborate with other HRT data analytics, engineering, and project management professionals to identify, propose, and implement process enhancementsÂ
- Assist in developing ad hoc data workflows, which support Health Research Board (HRB) approved initiatives and Milliman practice client projectsÂ
- Provide support to Milliman’s practices via our help desk system by answering a variety of questions, most oftenabout our data assetsand data use policiesÂ
- Collaborate with HRT finance, operations, and project management teammates through providing technicaland healthcare dataexpertiseÂ
- Communicateprogress, status, issues, decisions onaregular cadenceÂ
Minimumrequirements:Â
- A bachelor’s 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 producehigh quality,accuratedeliverables on schedule and effectively communicate progress, outcomes, and recommended next actionsÂ
- Four or 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 Milliman’s Chicago office for threeconsecutivedays each quarter isrequired
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 (e.g. individual, employer group, Medicare, Part D, Medicaid, Dental, etc.)Â
- Exposure to CMS’ LDSSAFdata filesÂ
- Proficiency in 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 apositiveattitude, 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:Demonstratesintegrity 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 andshowcasesexcellent problem-solving abilitywhich 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 issues—from 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 unparalleled expertise in 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 is August 19, 2026.Â
Compensation
The overall salary range for this role is $104,900 - $199,065. For candidatesresidingin:
Alaska, California, Connecticut, Illinois, Maryland, Massachusetts, New Jersey, New York City, Newark, San Jose, San Francisco, Pennsylvania, Virginia, Washington, or the District of Columbia:Â
All other states:Â
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) – Begins accruing on the first day of work. Full-time employees accrue 15 days per year, and employees working less than full-time accrue PTO on a prorated basis.Â
- Holidays – A minimum of 10 observed holidays per year.Â
- Family Building Benefits – Includes adoption and fertility assistance.Â
- Paid Parental Leave – Up to 12 weeks of paid leave for employees who meet eligibility criteria.Â
- Life Insurance & AD&D – 100% of premiums 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Â