Senior Enterprise Data Integration Engineer | Python/ETL

Montcure LLC; Idaho; Hybrid; USD 90,000 - 115,000; Full time

Job summary

Montcure, LLC is seeking a Senior Enterprise Data Integration Engineer (Python/ETL) to design, develop, and maintain scalable ETL/ELT pipelines across enterprise systems transforming complex data into trusted datasets for reporting, analytics, and applications.

The role emphasizes collaboration with stakeholders to translate business rules into robust pipelines using Python, SQL, and modern data engineering practices, while ensuring data quality, lineage, and governance in a federal context.

Qualifications

• Bachelor's degree or equivalent experience in a relevant field.
• 5+ years of experience developing enterprise ETL/ELT or data integration solutions.
• Strong Python programming skills for data processing and automation.
• Strong SQL skills with complex joins, aggregations and query optimization.
• Experience integrating data from multiple enterprise systems.
• Experience profiling, cleansing, normalization, reconciliation, and transformation.
• Experience creating source-to-target mapping documentation.
• Understanding of data lineage, metadata management, and data governance principles.
• Strong analytical, troubleshooting, and problem-solving skills.
• Strong written and verbal communication skills.

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 and reporting requirements evolve.
• Develop transformation logic that standardizes and integrates data from multiple enterprise source systems.
• Build reusable data processing components that support enterprise reporting and analytics.
• Monitor and adapt pipeline logic to accommodate changes in source systems while preserving data quality.
• Optimize pipeline performance, reliability, scalability, and maintainability.
• Collaborate with subject matter experts to understand financial business rules and data lineage.
• Provide technical recommendations to improve data quality and long-term scalability.

Skills

Python

SQL

ETL/ELT

Data integration

Data profiling

Troubleshooting

Communication

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Mathematics, or related field

Tools

Jupyter notebooks

PySpark

Apache Spark

Databricks

Job description

Montcure, LLC is seeking a Senior Enterprise Data Integration Engineer (Python/ETL) to design, develop, and maintain scalable ETL/ELT pipelines across enterprise systems transforming complex data into trusted datasets for reporting, analytics, and applications.

The role emphasizes collaboration with stakeholders to translate business rules into robust pipelines using Python, SQL, and modern data engineering practices, while ensuring data quality, lineage, and governance in a federal context.