Senior Data Integration Engineer (Python/ETL) Hybrid/Remote

Montcure LLC; Washington (District of Columbia); Hybrid; USD 90,000 - 115,000; Full time

Job summary

Montcure, LLC is seeking an Enterprise Data Integration Engineer (Python/ETL) – Senior to support enterprise financial data integration and modernization efforts.

This role focuses on designing, developing, and maintaining robust ETL/ELT data pipelines that transform complex data from multiple enterprise systems into trusted, business-ready datasets for downstream reporting, analytics, and business applications.

Qualifications

• Bachelor's degree or equivalent experience in a related 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 including complex joins, aggregations, and query optimization.
• Experience integrating data from multiple enterprise systems.
• Experience with data 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 while preserving data quality and integrity.
• Optimize pipeline performance, reliability, scalability, and maintainability.
• Analyze data from multiple enterprise systems and develop transformation logic that standardizes data structures, terminology, and business rules into consistent datasets.
• Collaborate with subject matter experts to understand financial business rules and validate data interpretations.
• Identify and resolve data quality, reconciliation, and normalization issues to ensure trusted datasets.
• Develop and maintain canonical datasets suitable for enterprise reporting and analytics.
• Support evolution of canonical data models as new source systems are introduced.
• Maintain data lineage and traceability throughout transformation processes.
• Document transformation logic, mappings, and business rules.
• Support data validation, reconciliation, and quality assurance activities.
• Partner with engineers, data modelers, and stakeholders to deliver production-ready data assets.

Skills

Python

SQL

Data integration

ETL/ELT

Data modeling

Data governance

Data quality

Problem solving

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 an Enterprise Data Integration Engineer (Python/ETL) – Senior to support enterprise financial data integration and modernization efforts.

This role focuses on designing, developing, and maintaining robust ETL/ELT data pipelines that transform complex data from multiple enterprise systems into trusted, business-ready datasets for downstream reporting, analytics, and business applications.