Enterprise Data Integration Engineer (Python/ETL) - Senior

Montcure, LLC • Washington, DC

6d • $90,000 - $115,000 • Hybrid

About The Position

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.

Requirements

• 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.
• Must be eligible for federal SECRET clearance
• Must be able to maintain this clearance during their employment with Montcure.

Nice To Haves

• 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.

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.
• 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.
• 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.
• 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.

Benefits

• 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.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior