Data Integration & Interface Analyst

Job Description

CSCI Consulting is seeking a Data Integration & Interface Analyst to support its Department of War (DoW / DoD) client. This role is responsible for helping define, validate, test, and stabilize mission-critical data integrations across source systems, staging environments, transformation layers, and downstream reporting platforms.

Working closely with technical developers, ERP owners, finance stakeholders, data teams, and PMO resources, the Data Integration & Interface Analyst ensures data moves accurately, completely, and reliably across the implementation landscape. This position plays a key role in source-to-target validation, reconciliation activities, interface testing, cutover readiness, production stabilization, and issue resolution supporting federal financial reporting and decision-making processes.

Responsibilities

• Support definition of integration requirements, interface specifications, mapping rules, control points, and validation criteria for data movement across source and target systems
• Assist in designing, testing, and validating batch interfaces, APIs, file-based integrations, and transformation jobs supporting OneStream and reporting platforms
• Validate source-to-target data movement across source applications, staging environments, data warehouses, and reporting outputs
• Perform reconciliation activities, including three-way reconciliations between source systems, transformed datasets, and downstream reports
• Identify and troubleshoot interface failures, rejected records, mapping defects, schema issues, data quality problems, and processing exceptions
• Coordinate with developers, system owners, and business stakeholders to investigate root causes and implement corrective actions
• Validate reference data, master data, hierarchies, and key attributes required for accurate financial reporting and operational processing
• Support System Integration Testing (SIT), User Acceptance Testing (UAT), cutover validation, deployment readiness, and production monitoring activities
• Maintain interface documentation, mapping specifications, reconciliation procedures, operational runbooks, and issue management records
• Assist with post-production stabilization by triaging data integration issues and supporting restoration of reliable end-to-end data processing

Minimum Requirements

• Active Secret Clearance required
• Bachelor's degree in Information Systems, Computer Science, Data Analytics, Accounting, Finance, Business, or a related field
• 5+ years of experience supportin