Senior Data Integration Engineer: ERP & Data Automation Lead

Jobtailor; Washington (District of Columbia); On-site; USD 120,000 - 180,000; Full time

Job summary

Jobtailor is seeking an experienced data integration professional in Washington, DC to design, implement, and validate enterprise data interfaces across ERP and financial reporting systems. You will refine requirements, build batch and API integrations, and ensure end-to-end data accuracy and timeliness.

The role involves three-way reconciliations, troubleshooting, and post-deployment support while collaborating with finance, data engineers, and business stakeholders.

Qualifications

• 10+ years of experience supporting enterprise data integration, financial systems, ERP modernization, or cloud data engineering initiatives.
• Experience developing or supporting APIs, ETL/ELT pipelines, batch processing, file-based integrations, or middleware platforms.
• Strong SQL skills with experience querying, validating, and reconciling large datasets.
• Experience performing source-to-target validation, data reconciliation, and enterprise data quality analysis.
• Experience supporting System Integration Testing (SIT), User Acceptance Testing (UAT), production deployments, and post-production support.
• Understanding of enterprise integration patterns, data mapping, transformation logic, and interface controls.
• Familiarity with cloud-based data platforms such as Azure, AWS, or Databricks.
• Excellent communication skills with the ability to collaborate across technical and business teams.
• U.S. citizenship with the ability to obtain and maintain a security clearance.

Responsibilities

• Design, develop, configure, and support enterprise data integrations supporting OneStream, ERP platforms, and financial reporting systems.
• Support definition of integration requirements, interface controls, source-to-target mappings, transformation logic, and validation criteria.
• Develop and validate batch integrations, APIs, file transfers, ETL/ELT pipelines, and cloud-based data movement processes.
• Validate end-to-end data movement across source systems, staging environments, transformation layers, enterprise data platforms, and downstream reporting solutions.
• Perform source-to-target validation to verify data completeness, accuracy, timeliness, and traceability.
• Execute three-way reconciliations between source systems, transformed datasets, and reporting platforms to identify and resolve data discrepancies.
• Troubleshoot interface failures, schema changes, mapping defects, rejected records, transformation errors, and data processing exceptions while documenting root causes and coordinating resolutions.
• Support synchronization of master data, reference data, metadata, mappings, and key business attributes for reliable reporting.
• Support SIT, UAT, cutover validation, production deployments, and post-implementation stabilization activities.
• Collaborate with developers, data engineers, finance orgs, source system owners, and stakeholders to improve interface reliability.
• Develop interface specifications, mapping documents, reconciliation procedures, runbooks, and technical documentation.
• Support ERP modernization initiatives, historical data conversions, and production cutovers.
• Monitor production interfaces and identify opportunities to improve automation, performance, and resilience.
• Utilize Power BI, Databricks, Palantir, Celonis Intelligence, SQL, and Python to analyze enterprise data, develop dashboards, and support data quality initiatives.
• Leverage AI-assisted analytics to automate reconciliation and anomaly detection.

Skills

Enterprise Data Integration

SQL Proficiency

ETL/ELT Pipeline Development

System Integration Testing (SIT)

Cloud Data Platforms

Analytical Skills

Troubleshooting

Root-Cause Analysis

Communication Skills

Collaboration

Education

Bachelor's degree in STEM

Tools

Power BI

Databricks

Palantir

Celonis Intelligence

Azure

AWS

Middleware Platforms

Job description

Jobtailor is seeking an experienced data integration professional in Washington, DC to design, implement, and validate enterprise data interfaces across ERP and financial reporting systems. You will refine requirements, build batch and API integrations, and ensure end-to-end data accuracy and timeliness.

The role involves three-way reconciliations, troubleshooting, and post-deployment support while collaborating with finance, data engineers, and business stakeholders.