Silverthorne Advisory Group

Solutions Engineer

• Design, develop, configure, and support enterprise data integrations supporting 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 the completeness, accuracy, timeliness, and traceability of financial and operational 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, rejected records, transformation errors, and data processing exceptions while documenting root causes and coordinating 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 proactively identify 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.
• Leverage 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.

Senior Data Integration Engineer

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

Senior Data Integration Engineer

Data Integration Engineer, 2 yrs exp