Senior Data Engineer (ETL / Python Developer)

MSR Technology Group; Illinois; On-site; USD 120,000 - 160,000; Full time

Job summary

MSR Technology Group in the United States seeks a Senior Data Engineer (ETL/Python) to design, build, and maintain scalable data pipelines for an Enterprise Data Warehouse and analytics initiatives.

The role collaborates with architects, analysts, QA, project managers, and BI teams, working with Azure Data Factory, Informatica, Snowflake, Spark, and Databricks to ensure trusted, compliant data assets in a regulated environment.

Qualifications

• 5+ years in data engineering focusing on enterprise data warehousing.
• 5+ years ETL development using Informatica or Azure tools.
• 5+ years Python development for data engineering and automation.
• 3+ years Spark, Snowflake, Oracle, SQL Server experience.

Responsibilities

• Design, develop, and maintain enterprise ETL pipelines using ADF, PowerCenter, and Python.
• Build and optimize data processing using Python, Spark, and Databricks.
• Develop and optimize SQL queries across Snowflake, Oracle, and SQL Server.
• Apply data engineering best practices for performance, scalability, reliability, and security.
• Support healthcare analytics and regulatory reporting initiatives.
• Participate in cloud migration and Azure-based data architecture.
• Collaborate with cross-functional teams to deliver scalable data solutions.

Skills

Data engineering

ETL development

Python

SQL

Spark

Teradata

Azure Data Factory

PowerCenter

Azure Databricks

Snowflake

Oracle

SQL Server

Azure DevOps

GitHub

REST APIs

Education

Bachelor's degree or higher

Tools

Informatica PowerCenter

Azure Data Factory

Databricks

Job description

Enterprise Data Warehouse (EDW) & Analytics Program

Work Arrangement

Remote

Travel

Periodic travel as required based on project or customer needs

Reports To

EDW Delivery Lead / Data Engineering Manager

About the Role

We are seeking a hands-on Senior Data Engineer (ETL / Python Developer) to support a large-scale Enterprise Data Warehouse (EDW) and Analytics Program. This role is responsible for designing, developing, and maintaining scalable data ingestion and transformation pipelines that support healthcare analytics, regulatory reporting, and enterprise decision support

.The ideal candidate will bring strong expertise in ETL development, Python engineering, Teradata, and modern cloud-based data platforms. This position requires close collaboration with architects, analysts, QA teams, project managers, subject matter experts, developers, and business intelligence teams to deliver high-quality, reliable data solutions in a regulated and audit-sensitive environment

.Key Responsibilitie

• gDesign, 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, Apache Spark, and Databricks
• .Develop and optimize SQL queries, stored procedures, and database objects across platforms such as Snowflake, Oracle, and SQL Server
• .Apply data engineering best practices to ensure performance, scalability, reliability, reusability, and security

.Analytics, Reporting & Data Qualit

• ySupport healthcare analytics and regulatory reporting initiatives
• .Develop robust data validation, reconciliation, and audit-ready data pipelines
• .Partner with analysts, QA teams, and reporting stakeholders to ensure data quality, accuracy, and timeliness
• .Implement controls and monitoring processes to maintain trusted and compliant data assets

.Modernization, Operations & Collaboratio

• nParticipate in cloud migration and modernization initiatives leveraging Azure-based data architectures
• .Support production operations, incident management, troubleshooting, and root cause analysis
• .Contribute to code reviews, source control management, and CI/CD processes using Azure DevOps and GitHub
• .Collaborate across cross-functional teams to deliver scalable and maintainable data solutions

.Required Qualificatio

• ns5+ years of experience in data engineering with a focus on enterprise data warehousin
• g.5+ years of hands-on ETL development experience using Informatica PowerCenter, Teradata, Azure Data Factory, or similar technologie
• s.5+ years of experience developing solutions in Python for data engineering and automatio
• n.5+ years of experience working with Teradata, including Teradata loading and utility tool
• s.3+ years of experience with Spark-based processing frameworks such as Databrick
• s.Strong SQL expertise and experience working with relational databases, including Snowflake, Oracle, and SQL Serve
• r.3+ years of experience with Snowflake, including SnowSQL and Snowpark (Python
• ).Experience with source control and DevOps practices using Azure DevOps, GitHub, and CI/CD pipeline
• s.Strong analytical, problem-solving, and troubleshooting skill
• s.Ability to work effectively in a fast-paced, collaborative environmen
• t.Willingness to travel periodically as require

d.Preferred Qualificati

• onsBachelor's degree or higher in Computer Science, Engineering, Analytics, or a related fie
• ld.Azure certifications related to Data Engineering or Analyti
• cs.Experience supporting Enterprise Data Warehouse (EDW) environmen
• ts.Healthcare, payer, public sector, or regulated-industry analytics experien
• ce.Data modeling experience in enterprise data warehouse environmen
• ts.Automation and orchestration scripting using PowerShell or Ba
• sh.Experience designing, integrating, or consuming REST APIs within data platfor
• ms.Familiarity with data quality frameworks, reconciliation processes, and audit support requiremen

ts.Location & Work Mo

• delWork Arrangement: Remote (U.S.-bas
• ed)Travel: Periodic travel may be required based on project or customer nee