Data Integration Engineer - 2 yrs exp - DC

Silverthorne Advisory Group LLC; Washington; Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

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

Job summary

Silverthorne Advisory Group LLC is seeking a Data Integration Engineer to support defense sector clients, focusing on data movement across source systems, transformation layers, and reporting platforms. You will collaborate with engineers, finance teams, and program management to stabilize data pipelines and improve reliability.

The role emphasizes source-to-target validation, three-way reconciliation, and automation using Power BI, Databricks, Palantir, Celonis, SQL, Python, and cloud-native

Qualifications

• 2+ years of professional experience in enterprise data integration or related technical initiatives.
• Bachelor's degree in a STEM field.
• Experience/development of APIs, ETL/ELT, batch processing or middleware.
• Working knowledge of SQL for querying and validating data.
• Familiarity with source-to-target validation and data quality analysis.
• Experience with SIT/UAT, production deployments, and post-production support.
• Understanding of enterprise integration patterns and interface controls.

Responsibilities

• Design, develop, configure, test, and maintain enterprise data integrations for OneStream, ERP platforms, and financial reporting systems.
• Define integration requirements, interface controls, source-to-target mappings, and transformation logic.
• Develop, test, and validate batch integrations, APIs, file transfers, ETL/ELT pipelines, and cloud-based data movement.
• Validate end-to-end data movement across source systems, staging environments, transformation layers, and reporting platforms.
• Perform source-to-target validation to verify data completeness, accuracy, timeliness, and traceability.
• Execute three-way reconciliations to identify and resolve data discrepancies.
• Troubleshoot interface failures, schema changes, and data processing errors; document root causes with senior engineers.
• Synchronize master data, reference data, metadata, mappings, and key attributes for reliable reporting.

Skills

SQL

Python

Power BI

Databricks

Palantir

Celonis Intelligence

REST APIs

ETL/ELT

Cloud platforms

Data integration

Education

Bachelor's degree in Computer Science / Information Technology / STEM

Tools

OneStream

ERP systems (SAP/Oracle)

Azure Data Factory

Azure Integration Services

Informatica

MuleSoft

Boomi

Kafka

Databricks

Job description

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

Job Description

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 OneStream, 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.

Responsibilities

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

Requirements

• 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.
• Excellent communication skills with the ability to collaborate across technical and business teams.
• Ability to manage multiple priorities within a fast-paced consulting environment.
• Demonstrated ability to learn new technologies quickly and adapt to evolving client requirements.
• U.S. citizenship with the ability to obtain and maintain a security clearance.

What Sets You Apart

• Experience supporting OneStream or other Enterprise Performance Management (EPM) platforms.
• Experience with ERP systems such as SAP, Oracle, Workday, Momentum, or CGI Momentum.
• Knowledge of federal financial management, including GTAS, USSGL, Treasury reporting, financial statement processes, audit readiness, and internal controls.
• Experience supporting Advana, War Data Platform, or other Department of War enterprise data platforms.
• Experience developing enterprise integrations using REST APIs, Azure Data Factory, Azure Integration Services, Informatica, MuleSoft, Boomi, Kafka, or similar integration technologies.
• Experience with modern cloud data platforms including Databricks, Spark, Delta Lake, Microsoft Fabric, Synapse Analytics, or similar architectures.
• Knowledge of ETL/ELT, API integration, middleware, data governance, metadata management, and master data management (MDM).
• Experience applying AI, intelligent automation, or agentic AI to data validation, reconciliation, anomaly detection, interface monitoring, or operational efficiency.
• Active Secret or Top Secret security clearance.
• Professional certifications such as Microsoft Azure Data Engineer Associate, Databricks Data Engineer Associate, AWS Certified Data Engineer, Certified Scrum Master (CSM), or Certified Data Management Professional (CDMP).
• Candidates with experience as Software Engineers, Cloud Engineers, Data Engineers, API Developers, Middleware Engineers, ETL Engineers, or ERP Integration Developers are encouraged to apply.
• Advanced degree or certifications in cloud computing, AI/ML, data engineering, or solution architecture.
• Effective communicator with a systems-thinking mindset and ability to translate business workflows into scalable solutions.
• Strong problem-solving skills and ability to solve complex data-related issues.
• Demonstrated experience working with large datasets and leveraging big data technologies to process and analyze data efficiently.
• Understanding of data modeling/visualization, database design principles, and data governance practices.
• Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams.
• Detail-oriented mindset with a commitment to delivering high‑quality results.

Benefits

• Compensation - We carefully consider a wide range of compensation factors, including but not limited to prior experience, skills, expertise, location, and other considerations permitted by law.
• Healthcare - We offer Health, Vision, and Dental Plans for our employees and their families.
• Retirement Plan -- We invest in your future with a competitive 401(k) plan, where we match 100% of your contributions up to your first 6% and give you access to Vanguard Admiral funds.
• Paid Time Off - Based on length of service, we offer a generous amount of paid leave.
• Bonus System -- As you invest in us, we invest in you. We offer bonuses to all employees who meet and exceed goals throughout the year.
• Professional Development -- Support for career growth through training programs and certifications.
• Company Retreats & Team Events -- Sponsored trips, team-building activities, and annual conferences related to your skillset.

Flexible work from home options available.