Senior Data Engineer (ETL) - SkySail

Milliman Ireland; Brookfield (WI); Remote; USD 104,000 - 233,000; Full time

Job summary

A leading consulting and SaaS company is seeking a Senior Data Engineer to manage ETL pipelines and ensure data transformation for Databricks. The role involves working with Python, Bash, SQL, and AWS services, focusing on automation and optimization of data workflows. This remote position offers a competitive salary and comprehensive benefits.

Benefits

Medical, Dental and Vision Coverage

401(k) Plan with Matching

Discretionary Bonus Program

Flexible Spending Accounts (FSA)

Paid Time Off (PTO)

Paid Parental Leave

Life Insurance & AD&D

Short-Term and Long-Term Disability

Qualifications

• 5+ years of relevant experience in data engineering or related roles.
• Strong SQL skills for data querying, manipulation, and validation.
• Familiarity with AWS infrastructure, specifically EC2 and S3.

Responsibilities

• Develop and maintain ETL pipelines for data ingestion and transformation.
• Collaborate with stakeholders to ensure data pipelines meet business requirements.
• Participate in on-call rotation to support ETL processes.

Skills

Python

Bash

SQL

Problem Solving

Communication

Tools

AWS

Databricks

Job description

04-Milwaukee 15-Solutions
Brookfield, WI 530451128, USA

Description

Milliman SkySail is seeking a Senior Data Engineer to join our team. In this role, you will manage and maintain ETL pipelines, ensuring the smooth ingestion and transformation of data ultimately destined for Databricks. You will primarily work with Python, Bash and SQL, using AWS services like EC2 and S3. Databricks familiarity is a plus but not required.

Who We Are

Milliman SkySail is a consulting and software-as-a-service (SaaS) unit of Milliman, specializing in pharmacy claims analysis and reporting. Established in 2015 and acquired by Milliman in 2021, we have rapidly grown into a team of around fifty experts focused on pharmaceutical claims analysis, data engineering, and application development.

Job Responsibilities

What You'll Do as a Senior Data Engineer at Milliman SkySail

• Collaborate: Work closely with key stakeholders and the rest of the data platform team to ensure data pipelines meet business requirements.
• Develop and Maintain ETL Pipelines: Design, develop, and manage robust ETL processes to efficiently ingest and transform data into Databricks.
• Automation and Optimization: Write and maintain scripts in Bash and Python to automate data workflows, optimize performance, and ensure reliability.
• Deploy and manage data pipelines in production: Deploy ETL workflows into production environments, ensuring robust operation, monitoring performance, and promptly addressing any pipeline issues to maintain reliability and stability.
• Troubleshooting and Support: Proactively monitor ETL processes, troubleshoot issues, and support timely resolution of data pipeline challenges.
• Client Engagement: Participate in client meetings and calls related to ETL requirements, providing clear communication and technical expertise.
• On-Call Availability: Participate in an on-call rotation to support ETL processes.
• 5+ years of relevant experience in data engineering or related roles.
• Proficiency in Python scripting and Bash.
• Strong SQL skills for data querying, manipulation, and validation.
• Familiarity with AWS infrastructure, specifically EC2 and S3.

Competencies and Behaviors that Support Success in this Role

• Familiarity with Databricks or similar big data platforms.
• Familiarity with DevOps best practices for ETL processes.
• Experience in healthcare data or pharmaceutical claims processing.
• Strong problem-solving abilities and attention to detail.
• Excellent written and verbal communication skills.

Individual(s) 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.

The overall salary range for this role is $104,900 - $232,680. A combination of factors will be considered, including, but not limited to, education, relevant work experience, qualifications, skills, certifications, etc.

For candidates residing in:

Alaska, California, Connecticut, Illinois, Maryland, Massachusetts, New Jersey, Pennsylvania, Virginia, Washington, or the District of Columbia:

• $115,390 - $190,410 if overall experience is less than 8 years; and
• $129,250 - $213,290 for experience greater than 8 years.

New York City, Newark, San Jose, or San Francisco:

• $125,880 - $207,720 if overall experience is less than 8 years; and
• $141,000 - $232,680 for experience greater than 8 years.

All other states:

• $104,900 - $173,100 if overall experience is less than 8 years; and
• $117,500- $193,900 for experience greater than 8 years.

Location: This is a remote position.

The expected application deadline for this job is August 19, 2025.

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.

Milliman is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran Status, age, or any other characteristic protected by law.

#LI-CS1 #LI-REMOTE

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.