Senior Data Integration Engineer - Hybrid & AI-Driven Pipelines

Silverthorne Advisory Group; Arlington (VA); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Retirement plan

401(k)

401(k) matching

Bonus based on performance

Company parties

Competitive salary

Health insurance

Dental insurance

Vision insurance

Paid time off

Training & development

Opportunity for advancement

Job summary

Silverthorne Advisory Group seeks a Data Integration Engineer to support defense clients, designing and validating data interfaces across ERP, finance, and reporting systems.

Hybrid role in the Washington DC area, with onsite sites in Rosslyn, Mark Center, and the Pentagon; collaboration with developers, data teams, and stakeholders to deliver reliable, auditable data solutions and modern integration architectures.

Qualifications

• 10+ years of experience in enterprise data integration, financial systems, ERP modernization, or cloud data engineering.
• 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.
• Understanding of enterprise integration patterns and interface controls.
• Familiarity with cloud-based data platforms such as Azure, AWS, or Databricks.

Responsibilities

• Design, develop, configure, and support enterprise data integrations for 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 completeness, accuracy, timeliness, and traceability of data.
• 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, and data processing exceptions; document root causes and coordinate resolutions.
• Support synchronization of master data, reference data, metadata, mappings, and key business attributes for reliable enterprise reporting.
• 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 and develop dashboards.
• Prepare technical documentation, executive briefings, and client deliverables.

Skills

Data integration

ETL/ELT

SQL

Python

APIs

Data quality

Data modeling

Cloud platforms

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

Databricks

Palantir

Celonis Intelligence

SQL

Job description

Silverthorne Advisory Group seeks a Data Integration Engineer to support defense clients, designing and validating data interfaces across ERP, finance, and reporting systems.

Hybrid role in the Washington DC area, with onsite sites in Rosslyn, Mark Center, and the Pentagon; collaboration with developers, data teams, and stakeholders to deliver reliable, auditable data solutions and modern integration architectures.