Senior Data Integration Engineer — Hybrid (10+ yrs)

Silverthorne Advisory Group LLC; Virginia (MN); Hybrid; USD 120,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

Flexible work from home options

Job summary

Silverthorne Advisory Group LLC is seeking a Data Integration Engineer to drive enterprise data integration across financial systems, ERP platforms, and reporting layers. You will solve complex data challenges at the intersection of finance, cloud platforms, and AI technologies while collaborating with cross-functional teams.

The role emphasizes source-to-target validation, data quality, and auditable data flows, with responsibilities across OneStream, ERP tools, and modern data platforms.

Qualifications

• 10+ years of experience supporting enterprise data integration, financial systems, ERP modernization, or cloud data engineering initiatives.
• Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Engineering, Computer Engineering, Information Technology, or another STEM discipline.
• 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 SIT, UAT, production deployments, and post-production support.
• Understanding of enterprise integration patterns, data mapping, transformation logic, and interface controls.
• Familiarity with Azure, AWS, or Databricks for cloud data platforms.
• Strong analytical, troubleshooting, and root-cause analysis skills.
• Excellent communication and collaboration across technical and business teams.
• U.S. citizenship with ability to obtain/maintain a security clearance.

Responsibilities

• Design, develop, configure, and support enterprise data integrations for OneStream, ERP platforms, and financial reporting systems.
• Define 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, and 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.
• Troubleshoot interface failures, schema changes, mapping defects, and data processing exceptions with root-cause analysis.
• Support synchronization of master data, reference data, metadata, mappings, and key attributes for reliable reporting.
• Support SIT, UAT, cutover validation, deployments, and post-implementation stabilization activities.
• Collaborate with developers, data engineers, finance, and stakeholders to improve interface reliability.
• Develop interface specs, mapping docs, reconciliation procedures, runbooks, and technical docs.
• Support ERP modernization initiatives, historical data conversions, and production cutovers.
• Monitor production interfaces and identify opportunities to improve automation, performance, and resilience.
• Use Power BI, Databricks, Palantir, Celonis, SQL, Python to analyze data, develop dashboards, and improve data quality.
• Apply AI-assisted analytics to automate reconciliation, anomaly detection, and monitoring.

Skills

SQL

APIs

ETL/ELT

Data validation

Power BI

Python

Databricks

Cloud platforms

Data integration

Team collaboration

Security clearance

Education

Bachelor's degree in Computer Science, Information Systems, Software Engineering or related STEM

Tools

OneStream

ERP systems (SAP, Oracle, Workday, Momentum, CGI Momentum)

Azure Data Factory

Azure/AWS/Databricks

Informatica

MuleSoft

Boomi

Kafka

Job description

Silverthorne Advisory Group LLC is seeking a Data Integration Engineer to drive enterprise data integration across financial systems, ERP platforms, and reporting layers. You will solve complex data challenges at the intersection of finance, cloud platforms, and AI technologies while collaborating with cross-functional teams.

The role emphasizes source-to-target validation, data quality, and auditable data flows, with responsibilities across OneStream, ERP tools, and modern data platforms.