Data Integration, Interface Analyst

This is a fully remote position, open to applicants in United States.

📋 Description

• Assist in defining integration requirements, interface specifications, mapping rules, control points, and validation criteria for the movement of data between source and target systems.

• Contribute to the design, testing, and validation of batch interfaces, APIs, file-based integrations, and transformation jobs that support OneStream and reporting platforms.

• Ensure validation of data movement from source to target across source applications, staging environments, data warehouses, and reporting outputs.

• Conduct reconciliation activities, including three-way reconciliations among source systems, transformed datasets, and downstream reports.

• Detect and resolve interface failures, rejected records, mapping defects, schema issues, data quality challenges, and processing exceptions.

• Collaborate with developers, system owners, and business stakeholders to investigate root causes and apply corrective measures.

• Validate reference data, master data, hierarchies, and key attributes necessary for precise financial reporting and operational processes.

• Facilitate System Integration Testing (SIT), User Acceptance Testing (UAT), cutover validation, deployment readiness, and production monitoring tasks.

• Maintain documentation for interfaces, mapping specifications, reconciliation procedures, operational runbooks, and issue management records.

• Aid in post-production stabilization by prioritizing data integration issues and assisting in the restoration of reliable end-to-end data processing.

⛳️ Requirements

• An active Secret Clearance is mandatory.

• A Bachelor's degree in Information Systems, Computer Science, Data Analytics, Accounting, Finance, Business, or a related field; equivalent experience may be considered.

• Over 5 years of experience in data integration, interface management, ETL processes, system remediation, or enterprise platform implementations.

• Proficient in working with source-to-target mapping, data transformation, interface controls, and reconciliation methodologies.

• A solid understanding of batch processing, file-based integrations, APIs, and data movement architectures.

• Capability to analyze data flows across various systems and identify root causes of data quality, transformation, and interface problems.

• Experience in supporting testing activities including SIT, UAT, defect triage, regression testing, and production readiness validation.

• Knowledge of documentation standards, traceability requirements, change control, and implementation governance procedures.

• Skilled in SQL, data analysis tools, Microsoft Excel, and collaboration platforms utilized for implementation delivery.

• Creative and adaptable in problem-solving.

• Ability to engage with clients to understand their requirements.

• Strong organizational and time-management capabilities.

• Exceptional written and verbal communication proficiency.

• A professional demeanor.

🏝️ Benefits

• Competitive salaries.

• Generous Paid Time Off (PTO) package.

• Paid holidays that align with the Federal calendar.

• Comprehensive health benefits, including medical, dental, vision, and life insurance.

• 401(k) retirement plan.

• Team-building events.

• Support for professional development.