Data Integration and Interface Analyst | MC-III / MC-IV
RemoteUnited States
Job Summary
Define integration requirements, interface controls, mapping logic, and validation criteria for data movement across source and target platforms. Design, test, and validate batch feeds, APIs, file transfers, and transformation jobs supporting OneStream and downstream reporting. Validate source-to-target data movement, reconcile across integration layers, and perform 3-way reconciliation to identify breaks between systems. Troubleshoot load failures, schema issues, mapping defects, and rejected records; document root causes and coordinate fixes with technical teams. Confirm synchronization of reference data and master data, then support data testing, SIT, UAT, cutover validation, and early production monitoring. Partner with developers, source system owners, and stakeholders to resolve recurring issues and improve control points. Maintain documentation for interface logic, transformation rules, and operational support handoff while assisting during go-live and stabilization. This role supports the OneStream implementation for a boutique consulting firm serving the federal government.
Required Qualifications
- Experience supporting data integration, interface management, ETL/data transformation, or system remediation activities in a federal or enterprise platform implementation
- Strong understanding of source-to-target mapping, interface controls, batch processing, file-based integrations, APIs, and reconciliation methods
- Ability to analyze data movement across multiple layers and identify root causes of failures, mismatches, incomplete loads, and transformation defects
- Familiarity with federal accounting, GL structures, and government finance data flows
- Experience supporting structured testing activities, including SIT, UAT, defect triage, regression validation, and production readiness
- Familiarity with federal implementation delivery expectations such as traceability, documentation control, approval cycles, cutover discipline, and stabilization support
- Ability to work across technical, data, reporting, and PMO teams in a documentation-heavy and compliance-forward environment
- Strong documentation skills for mappings, interface specifications, validation evidence, issue logs, and support procedures
- Bachelor's degree
- 10 years of experience
- 16 years of experience
- Master's degree
- 12 years of experience
- Secret or above
Desired Qualifications
- Experience with financial system integrations, ERP feeder files, historical/current data loads, or downstream reporting interfaces
- DoD Experience
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.