Federal Systems Integration Consultant

Unison Inc.; Tysons, Northern (VA, KY); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Unison is seeking a Technical Consultant to design, develop, and support integration, data migration, and reporting solutions across the Unison platform ecosystem for federal civilian, defense, and intelligence community customers.

This hands-on role works directly with clients, functional consultants, project managers, and technical stakeholders to architect approaches and build scalable solutions enabling reliable data exchange, accurate data conversion, and actionable reporting.

Qualifications

• Experience designing, developing, or supporting system integrations, data migration, or reporting solutions.
• Experience with enterprise software implementations.
• Experience in structured delivery environments (Agile, Waterfall, or hybrid).
• Experience supporting software implementations for federal government agencies or government contractors is preferred.

Responsibilities

• Design, develop, test, and deploy integration solutions supporting real-time, near real-time, and batch data exchange between Unison and client systems.
• Design and execute data migration strategies, including extraction, transformation, validation, cleansing, reconciliation, and load activities.
• Develop and maintain reports, queries, extracts, and dashboards that support client operational, financial, and compliance reporting needs.
• Develop and maintain APIs, web services, data transformation processes, and integration workflows using approved platforms and technologies.
• Partner with clients, functional consultants, and project managers to gather requirements, evaluate technical approaches, and recommend solutions.
• Troubleshoot complex integration, data, and reporting issues, perform root cause analysis, and implement sustainable resolutions.
• Create and maintain technical documentation, including solution designs, mapping specifications, deployment procedures, and support documentation.
• Participate in code reviews, unit and system testing, and quality assurance activities to ensure reliable, maintainable, and secure solutions.
• Support implementation, upgrade, cutover, and post-production activities, including production support and defect resolution.
• Serve as a trusted technical advisor in client-facing meetings, workshops, and design sessions, and identify opportunities to improve technical standards and delivery frameworks.

Skills

SQL

REST APIs

SOAP APIs

Data integration

Data migration

Reporting

Java

Cloud integration

Security concepts

Education

Bachelor's degree in CS/IS/Software Eng

Tools

Talend

Power BI

Oracle BI

Jasper Reports

Crystal Reports

SQL Loader

Job description

Unison is seeking a Technical Consultant to design, develop, and support integration, data migration, and reporting solutions across the Unison platform ecosystem for federal civilian, defense, and intelligence community customers.

This hands-on role works directly with clients, functional consultants, project managers, and technical stakeholders to architect approaches and build scalable solutions enabling reliable data exchange, accurate data conversion, and actionable reporting.