Senior Federal Data Migration Architect

Unison; United States; On-site; USD 120,000 - 170,000; Full time

Job summary

Unison seeks a Data Migration Consultant to plan, build, and execute the conversion of legacy data into Unison's acquisition, grants management, and contract lifecycle solutions for federal civilian, defense, and intelligence customers.

This hands-on technical delivery role profiles source data, builds extraction and transformation routines, and ensures converted data is accurate and usable on day one, coordinating with clients, consultants, and project managers.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Software Engineering, or a related technical field.
• Relevant technical certifications in database, cloud, or integration platform technologies are a plus.

Responsibilities

• Analyze and profile legacy source data to assess structure, quality, completeness, and fitness for conversion.
• Develop data mapping specifications and transformation logic between source systems and Unison target structures.
• Build, test, and execute extraction, transformation, cleansing, and load routines using approved ETL platforms and database technologies.
• Plan and execute mock conversions, conversion rehearsals, and production cutover loads against the project schedule.
• Develop and run reconciliation and validation routines, including control totals, record counts, and exception reporting.

Skills

SQL

ETL tools

Data profiling

Data mapping

Oracle SQL

Data cleansing

Data modeling

Education

Bachelor's degree

Tools

Talend Data Services

Job description

Unison seeks a Data Migration Consultant to plan, build, and execute the conversion of legacy data into Unison's acquisition, grants management, and contract lifecycle solutions for federal civilian, defense, and intelligence customers.

This hands-on technical delivery role profiles source data, builds extraction and transformation routines, and ensures converted data is accurate and usable on day one, coordinating with clients, consultants, and project managers.