Senior Data Engineer (ETL / Python) (Remote) (W2 Only)

Posted 3 days ago

msrcosmosKansas City (MO)

Data Warehousing Specialists Computer Systems Design Services

SENIORITY

Lead

Apply

About the role

Senior Data Engineer (ETL / Python Developer) (Remote) (W2 Only)

Primary Responsibilities:

Pipeline Development & Engineerin
Design, develop, and maintain enterprise ETL pipelines using Azure Data Factory (ADF), Informatica PowerCenter, and Python-based frameworks
Build and optimize scalable data processing solutions using Python, Spark, and Databricks
Write and optimize SQL and stored procedures across relational platforms such as Snowflake, Oracle, and SQL ServerFollow data engineering best practices for performance, reliability, reusability, and security
Analytics, Reporting & Data Qualit
Support Medicaid analytics and federal reporting initiatives (e.g., T-MSIS, PERM, MARS, Quality of Care)
Develop robust data validation, reconciliation, and audit-traceable data pipelines
Collaborate with analysts, QA, and reporting teams to ensure data quality, accuracy, and timeliness
Modernization, Operations & Collaboration
Participate in cloud migration and modernization initiatives within Azure-based architectures
Support production operations, incident resolution, and root cause analysis

Participate in code reviews, source control, and CI/CD processes using Azure DevOps and GitHub. Required Qualification 5+ years of data engineering experience with a focus on enterprise data warehousing 5+ years of hands-on ETL development using Informatica PowerCenter, Teradata, Azure Data Factory, or similar tools 5+ years of Python development for data engineering and automation 5+ years of Teradata experience, including Teradata loader utilities 3+ years of experience with Spark-based processing frameworks (Databricks or equivalent) Solid SQL expertise and experience with relational databases (such as Snowflake, Oracle, SQL Server)3+ years of experience with Snowflake using SnowSQL and Snowpark (Python) Experience with source control and DevOps practices (Azure DevOps, GitHub, CI/CD) Proven solid analytical, problem-solving, and troubleshooting skills Periodic travel may be required based on project or customer needs Preferred Qualification Bachelor’s degree or higher in Computer Science, Engineering, Analytics, or a related field Azure certifications related to data engineering or analytics Experience supporting State Medicaid EDW or MMIS analytics environments Healthcare or public sector analytics experience (Medicaid / Medicare preferred) Data modeling experience in enterprise data warehouse environments Scripting experience (PowerShell, Bash) for automation and orchestration Experience designing or consuming APIs (REST) within data platforms Familiarity with data quality frameworks, reconciliation, and audit support

Before you apply

Applying takes about a minute. These four things decide how fast it moves after that.

Your profile is current

It's what we read first. Occupations, seniority and locations matter more than a long history.

Two examples you can talk through

Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.

A number in mind

What you're on now and what would make you move. We negotiate better when we know both.

Your notice period

Employers plan around it, and it's the question that stalls offers most often.

Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.