Data Analytics Engineer

POSITION SUMMARY:

Milliman is seeking a Data Analytics Engineer to join our Health Research Team. This position plays a critical role in ensuring the accuracy, efficiency, and integrity of our medical claims data processing workflows.  The successful candidate will partner with other Health Research Team professionals to write and maintain translation and loading routines, run software for grouping and categorizing data, and maintain up-to-date process documentation and client-facing reference documentation.  In addition, this function will develop new programs to replace on-prem data refresh processes with cloud-based data refresh processes that are performed in AWS Databricks and standalone EC2 instances.

This position reports to the Health Research Team DevOps Manager.

RESPONSIBILITIES:

• Design and implement efficient data processing workflows of very large volumes of medical claims data. 
• Develop and optimize routines for ETL procedures.
• Utilize homegrown and public software and frameworks to augment medical claims data. 
• Develop and implement data quality checks and validation procedures to identify and resolve inconsistencies or errors in the processed data.
• Collaborate with analysts, consultants, and subject matter experts to endure high quality and reliable output.
• Create and maintain comprehensive documentation related to process workflow, ETL routines and data field definitions.  Keep documentation up to date in a changing environment.
• Monitor and optimize data workflows to enhance efficiency, reduce processing time and expense, improve scalability, identify, and implement performance tuning techniques.
• Work closely with cross-functional teams, including data scientists, analysts, and business stakeholders to understand their requirements and provide data engineering support. 
• Adhere to data security and privacy regulations and Milliman policies while handling sensitive medical claims data. 

SKILLS & QUALIFICATIONS REQUIRED:

• Bachelor's or master’s degree in computer science, data science, information systems or related field
• The ideal candidate must have minimum two years' experience working with medical data or closed claims data.
• The ideal candidate must have strong programming skills such as Python, R, Spark or Scala.  Currently, Python, SQL and SAS are the most common languages used by this team.
• The ideal candidate must have a solid understanding of ETL pipelines and data warehousing principles.
• The ideal candidate must have proficiency working with big data technologies such as Hadoop, Spark etc. 
• Must have excellent problem-solving ability.
• Must have attention to detail, with a commitment to data accuracy and integrity.

SKILLS & QUALIFICATIONS PREFERRED:

• Experience migrating SAS to Databricks environments.

LOCATION:

Candidates hired into this role will be required to work in-person in the Milliman office in Chicago, IL; this is a hybrid role where the person is expected to work out of Chicago office at least twice a week.

BENEFITS:

At Milliman, we focus on creating an environment that recognizes – and meets – the personal and professional needs of the individual and their family. We offer competitive benefits which include the following based on plan eligibility:

• Medical, dental and vision coverage for employees and their dependents, including domestic partners.
• A 401(k) plan with matching program, and profit-sharing contribution
• Employee Assistance Program (EAP)
• A discretionary bonus program.
• Paid Time Off (PTO) starts accruing on the first day of work and can be used for any reason; full-time employees will accrue 15 days of PTO per year, and employees working less than a full-time schedule will accrue PTO at a prorated amount based on hours worked.
• Family building benefits, including adoption and fertility assistance and paid parental leave up to 12 weeks for employees who have worked for Milliman for at least 12 months and have worked at least 1,250 hours in the preceding 12-month period.
• A minimum of 8 paid holidays
• Milliman covers 100% of the premiums for life insurance, AD&D, and both short-term and long-term disability coverage.
• Flexible spending accounts allow employees to set aside pre-tax dollars to pay for dependent care, transportation, and applicable medical needs.

ABOUT MILLIMAN:

Independent for over 70 years, Milliman delivers market-leading services and solutions to clients worldwide. Today, we are helping companies take on some of the world’s most critical and complex issues, including retirement funding and healthcare financing, risk management and regulatory compliance, data analytics and business transformation.

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.

EQUAL OPPORTUNITY:

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