Data Integration Engineer - 2 yrs exp - DC

Benefits

• Retirement Plan
• 401(k)
• 401(k) matching
• Bonus based on performance
• Company parties
• Competitive salary
• Dental insurance
• Health insurance
• Opportunity for advancement
• Paid time off
• Training & development
• Vision insurance

Silverthorne Advisory Group is seeking a Data Integration Engineer to join an exciting and growing opportunity supporting Defense sector clients. This position is ideal for an engineer who enjoys solving complex enterprise data integration challenges while working at the intersection of financial management, cloud data platforms, enterprise applications, and emerging artificial intelligence technologies. The successful candidate will support enterprise modernization initiatives by supporting the design, validation, testing, implementation, and stabilization of data layer integrations across financial systems, ERP platforms, staging environments, analytics platforms, and reporting solutions.

Working alongside technical developers, source system owners, data layer teams, finance stakeholders, and program management teams, you will assist in ensuring financial and operational data moves accurately, completely, and securely from source systems through transformation pipelines into downstream reporting platforms. This role places a strong emphasis on source-to-target validation, three-way reconciliation, interface reliability, data quality, traceability, and operational readiness. You will support enterprise platforms such as One Stream, ERP systems, GTAS reporting, War Data Platform, and other mission-critical financial systems while leveraging technologies including Power BI, Databricks, Palantir, Celonis Intelligence, SQL, Python, cloud-native integration services, and agentic AI solutions to automate validation, improve data quality, and accelerate issue resolution.

The ideal candidate has a strong technical foundation in software development, data integration, or cloud technologies and is eager to expand their knowledge of enterprise financial systems while collaborating with experienced technical and functional teams. This role offers the opportunity to build technical expertise delivering modern integration architectures that improve financial reporting, strengthen internal controls, and enable data-driven decision-making across federal organizations.

The position will be hybrid and based in the Washington, DC metropolitan area. Onsite work locations are in Rosslyn, the Mark Center, and Pentagon.

• Support the design, development, configuration, testing, and maintenance of enterprise data integrations supporting One Stream, ERP platforms, and financial reporting systems.
• Assist with defining integration requirements, interface controls, source-to-target mappings, transformation logic, and validation criteria.
• Support the development, testing, and validation of 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 the completeness, accuracy, timeliness, and traceability of financial and operational data.
• Assist in executing 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 working with senior engineers to implement technical resolutions.
• Support synchronization of master data, reference data, metadata, mappings, and key business attributes required for reliable enterprise reporting.
• Support System Integration Testing (SIT), User Acceptance Testing (UAT), cutover validation, production deployments, and post-implementation stabilization activities.
• Collaborate with software developers, data engineers, finance organizations, source system owners, and business stakeholders to improve interface reliability and reduce manual processing.
• Develop interface specifications, mapping documents, reconciliation procedures, operational runbooks, and technical documentation.
• Support ERP modernization initiatives, enterprise system implementations, historical data conversions, and production cutovers.
• Monitor production interfaces and assist in identifying opportunities to improve automation, performance, scalability, and operational resilience.
• Utilize Power BI, Databricks, Palantir, Celonis Intelligence, SQL, and Python to analyze enterprise data, develop dashboards, and support data quality initiatives.
• Support the use of AI-assisted analytics and agentic AI technologies to automate reconciliation, anomaly detection, interface monitoring, and operational support.
• Prepare technical documentation, executive briefings, and client deliverables supporting project leadership and…