Enterprise Data Integration Engineer (Python/ETL) - Senior

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

Enterprise Data Integration Engineer (Python/ETL) - Senior

Location:On-location at Pentagon (Hybrid and Remote eligible)

Level: Senior

Clearance:Must be eligible for federal SECRET clearance

*Candidates must have the above clearance level and, at a minimum, be able to maintain this clearance during their employment with Montcure.

Montcure, LLC is a Service-Disabled Veteran-Owned Small Business (SDVOSB) founded with a vision to revolutionize consulting and advisory services through innovative, data-driven solutions. The Montcure team recognizes the unique challenges faced by organizations and governments in today’s rapidly evolving business environment.

Job Summary

Montcure 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. The successful candidate will work closely with functional stakeholders to understand business rules, translate inconsistent source data into standardized data models, and implement scalable transformation logic using Python, SQL, and modern data engineering practices.

Key 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, business rules, and reporting requirements evolve over time.
• 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, data structures, and evolving business requirements while preserving data quality and integrity.
• Optimize pipeline performance, reliability, scalability, and maintainability.

Data Integration & Transformation

• Analyze data from multiple enterprise systems and develop transformation logic that standardizes differing data structures, terminology, and business rules into consistent, business-ready datasets.
• Collaborate with functional subject matter experts to understand financial business rules, validate data interpretations, and ensure transformation logic accurately reflects business intent.
• Identify and resolve data quality, reconciliation, and normalization issues to ensure accurate, trusted, and traceable enterprise datasets.

Data Modeling & Governance

• Develop and maintain canonical datasets suitable for enterprise reporting and analytics.
• Support the ongoing evolution of canonical data models as new source systems, business entities, and reporting requirements are introduced.
• Maintain data lineage and traceability throughout the transformation process.
• Document transformation logic, mapping specifications, and business rules.
• Support data validation, reconciliation, and quality assurance activities.

Technical Collaboration

• Partner with application engineers, data modelers, and functional stakeholders to deliver trusted, production-ready data assets supporting enterprise reporting and business applications.
• Collaborate with downstream development teams to ensure datasets support evolving reporting, analytics, and application requirements.
• Participate in solution design, testing, troubleshooting, deployment, and continuous improvement activities.
• Provide technical recommendations that improve data quality, pipeline reliability, maintainability, and long-term scalability.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Mathematics, or related field (or equivalent experience).
• 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.

Preferred Qualifications:

• Experience working with Navy financial systems, financial data, or enterprise financial datasets (e.g., Navy ERP or other Department of the Navy financial applications).
• Experience supporting federal financial management, budget execution, accounting, audit readiness, or financial reporting.
• Experience with Jupyter notebooks, PySpark, Apache Spark, Databricks, or comparable data engineering technologies.
• Active Secret clearance or ability to obtain one.

Status:

Contingency – This work is contingent upon award.

Salary Range

$90-$115k per year

Montcure, LLC is an Equal Opportunity Employer. Montcure, LLC does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.