Data Integration Engineer, 2 yrs exp

Silverthorne Advisory Group

Data Integration Engineer working on enterprise data integration for defense sector clients. Collaborating on financial management and AI technologies in a hybrid work environment.

Posted 7/26/2026full-timeWashington • District of Columbia, Washington • 🇺🇸 United StatesJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in enterprise data integration, including API development, ETL/ELT pipeline support, and data reconciliation. Proficient in SQL for data validation and analysis, with a strong focus on ensuring data quality and integrity across financial systems.

Highest-signal resume keywords

Enterprise Data IntegrationAPI DevelopmentETL/ELT Pipeline SupportSQL ProficiencyData Reconciliation

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data IntegrationAPI DevelopmentETLELTSQLData MappingData TransformationData ValidationData Quality AnalysisBatch Processing

Soft Skills

Analytical SkillsTroubleshootingRoot-Cause AnalysisTime ManagementCollaboration

Tools & Technologies

OneStreamERP PlatformsCloud Data PlatformsAzureAWSDatabricksMiddleware Platforms

Industry Keywords

Financial Reporting SystemsSystem Integration TestingUser Acceptance TestingData Movement ProcessesEnterprise Data Quality

Tech Stack

Tools & technologies

AWSAzureCloudERPETLSQL

About the role

Key responsibilities & impact

Support the design, development, configuration, testing, and maintenance of enterprise data integrations supporting OneStream, 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.

Requirements

What you’ll need

2+ years of professional experience supporting enterprise data integration, financial systems, ERP modernization, cloud data engineering, software development, or related technical initiatives.
Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Engineering, Computer Engineering, Information Technology, or another STEM discipline.
Experience or academic/project experience developing or supporting APIs, ETL/ELT pipelines, batch processing, file-based integrations, or middleware platforms.
Working knowledge of SQL with experience querying, validating, and analyzing datasets.
Experience or familiarity with source-to-target validation, data reconciliation, and enterprise data quality analysis.
Experience supporting or participating in System Integration Testing (SIT), User Acceptance Testing (UAT), production deployments, and post-production support.
Foundational understanding of enterprise integration patterns, data mapping, transformation logic, and interface controls.
Familiarity with cloud-based data platforms such as Azure, AWS, or Databricks.
Strong analytical, troubleshooting, and root-cause analysis skills.
Ability to manage multiple priorities within a fast-paced consulting environment.
U.S. citizenship with the ability to obtain and maintain a security clearance.

Benefits

Comp & perks

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