Data Integration & Interface Analyst

4 days, 21 hours ago
Full-time
Senior
Data Science and Analytics
CSCI Consulting

CSCI Consulting

CSCI Consulting is an award-winning firm offering cutting-edge solutions for government and commercial markets. They prioritize client satisfaction and provide extensive project management support, financial transparency, and custom solutions.

Professional Services
51-250

Description

  • Support definition of integration requirements, interface specifications, mapping rules, control points, and validation criteria.
  • Assist in designing, testing, and validating batch interfaces, APIs, file-based integrations, and transformation jobs.
  • Validate source-to-target data movement across source applications, staging environments, data warehouses, and reporting outputs.
  • Perform 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 for accurate financial reporting.
  • Support SIT, UAT, cutover validation, deployment readiness, and production monitoring.
  • Maintain interface documentation, mapping specifications, reconciliation procedures, runbooks, and issue records.
  • Assist with post-production stabilization and restoration of end-to-end data processing.

Requirements

  • 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 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 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.
  • Experience supporting OneStream, ERP, financial management, budgeting, accounting, or enterprise performance management implementations (preferred).
  • Familiarity with federal accounting structures, General Ledger (GL) concepts, Treasury reporting, GTAS, or government financial data flows (preferred).
  • Experience with Azure, SQL Server, ETL platforms, Power BI, or enterprise data integration technologies (preferred).
  • Past experience working with a Federal agency (preferred).
  • Department of War experience is a plus.

Benefits

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

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

TCAC Test Analyst (Job 1405)

DLH 1K-5K Construction & Engineering

DLH is seeking a TCAC Test Analyst to support SIGINT/EW systems testing and integration for U.S. Marine Corps and MARSOC operations.

Active Directory JIRA Linux
1 day, 20 hours ago

Senior Business Analyst / Data Quality Assurance Engineer — Federal Healthcare

Rackner 11-50 Internet Software & Services

Rackner is hiring a Senior Business Analyst / Data Quality Assurance Engineer to support federal healthcare systems through requirements validation, testing, and data quality assurance.

Agile Azure HIPAA SQL
1 day, 20 hours ago

Sr Quality Assurance Engineer

ELEVI Associates 11-50 Internet Software & Services

ELEVI is hiring a Senior Quality Assurance tester to support federal system upgrades and modernization efforts across web applications, databases, reporting interfaces, and secure enterprise environments.

Cybersecurity GitLab Java Windows Server
1 day, 20 hours ago

Business Analyst

Blue Water Thinking 51-250 Professional Services

Blue Water Thinking is hiring a Business Analyst / ATO Support Analyst to support the VA OAA Data Management Center application portfolio with requirements gathering, system documentation, and ATO maintenance.

Wireframing
1 day, 20 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers