Data Integration, Interface Analyst

CSCI Consulting

Data Integration & Interface Analyst supporting Department of War (DoD) client at CSCI Consulting. Focusing on mission-critical data integrations and reporting platforms in a collaborative environment.

Posted 7/17/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data integration, interface management, and ETL processes, with a strong focus on validation, reconciliation, and testing methodologies. Proficient in SQL and data analysis tools, ensuring accurate financial reporting and operational processing.

Highest-signal resume keywords

Data IntegrationInterface ManagementETL ProcessesSQL ProficiencySystem Integration Testing (SIT)

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data TransformationSource-to-Target MappingBatch ProcessingFile-Based IntegrationsAPIsReconciliation MethodologiesData Quality AnalysisDefect TriageRegression TestingProduction Readiness Validation

Soft Skills

Problem-SolvingOrganizational SkillsTime-Management SkillsWritten CommunicationVerbal Communication

Tools & Technologies

Data Analysis ToolsMicrosoft ExcelCollaboration Platforms

Certifications & Qualifications

Active Secret Clearance

Industry Keywords

Integration RequirementsInterface SpecificationsControl PointsValidation CriteriaOperational RunbooksChange ControlImplementation Governance

Tech Stack

Tools & technologies

ETLSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

Active Secret Clearance required
Bachelor's degree in Information Systems, Computer Science, Data Analytics, Accounting, Finance, Business, or a related field; equivalent experience may be substituted
5+ years of experience supporting data integration, interface management, ETL processes, system remediation, or enterprise platform implementations
Experience working with source-to-target mapping, data transformation, interface controls, and reconciliation methodologies
Strong understanding of batch processing, file-based integrations, APIs, and data movement architectures
Ability to analyze data flows across multiple systems and identify root causes of data quality, transformation, and interface issues
Experience supporting testing activities including SIT, UAT, defect triage, regression testing, and production readiness validation
Familiarity with documentation standards, traceability requirements, change control, and implementation governance processes
Proficiency with SQL, data analysis tools, Microsoft Excel, and collaboration platforms used for implementation delivery
Creativity and adaptability in problem-solving
Ability to work with clients to understand their needs
Strong organizational and time-management skills
Excellent written and verbal communication skills
Professional presence

Benefits

Comp & perks

Competitive salaries
Generous Paid Time Off (PTO) package
Paid holidays aligned to the Federal calendar
Full health benefits including medical, dental, vision, and life insurance
401(k) retirement plan
Team building events
Professional development support