Senior Data Integration Engineer — Python/ETL

ADP, Inc.; Washington (District of Columbia); Hybrid; USD 90,000 - 115,000; Full time

Job summary

Montcure, LLC seeks a Senior Enterprise Data Integration Engineer (Python/ETL) to design, develop, and maintain scalable data pipelines supporting enterprise reporting and analytics. You will transform data from multiple sources into trusted datasets for downstream applications.

The role emphasizes collaboration with stakeholders, data modeling, governance, and ensuring data quality while adapting pipelines to evolving business needs.

Qualifications

• Bachelor's degree in CS, IS, Data Engineering, or related field
• 5+ years of enterprise ETL/ELT or data integration experience
• Strong Python programming for data processing and automation
• Strong SQL skills with complex joins, aggregations, and optimization
• Experience integrating data from multiple enterprise systems
• Understanding of data lineage, metadata management, and data governance principles

Responsibilities

• Design, develop, test, and maintain scalable ETL/ELT data pipelines using Python, SQL, and modern data engineering practices
• Maintain and enhance existing data pipelines as enterprise data sources evolve
• Develop transformation logic that standardizes data from multiple enterprise source systems
• Build reusable data processing components for enterprise reporting and analytics
• Monitor and adapt pipeline logic to changes in source systems while preserving data quality
• Optimize pipeline performance, reliability, scalability, and maintainability

Skills

Python

SQL

ETL/ELT

Data integration

Problem solving

Analytical thinking

Education

Bachelor's degree

Tools

Jupyter notebooks

PySpark

Apache Spark

Databricks

Job description

Montcure, LLC seeks a Senior Enterprise Data Integration Engineer (Python/ETL) to design, develop, and maintain scalable data pipelines supporting enterprise reporting and analytics. You will transform data from multiple sources into trusted datasets for downstream applications.

The role emphasizes collaboration with stakeholders, data modeling, governance, and ensuring data quality while adapting pipelines to evolving business needs.