Senior Data Migration Architect for Federal Programs

Unison; McLean (VA); On-site; USD 110,000 - 160,000; Full time

Job summary

Unison is seeking a Senior Data Migration Consultant to serve as the senior technical authority for data conversion across federal programs, owning the migration strategy that moves legacy data into Unison's acquisition, grants management, and contract lifecycle solutions.

This hands-on senior delivery role requires leading complex conversions, setting data quality standards, and mentoring a team of technical consultants while delivering the most challenging migrations.

Qualifications

• Professional experience planning and executing data migration or data conversion efforts.
• Experience owning conversion strategy and data architecture decisions across multiple source systems.
• Experience supporting enterprise software or large-scale system implementations.

Responsibilities

• Own the data migration strategy and architecture across the program, including source system inventory, conversion sequencing, target data architecture, and cutover approach.
• Establish and enforce standards for data mapping, transformation logic, cleansing rules, reconciliation, and conversion documentation.
• Provide technical direction to other technical consultants, including task assignment, design guidance, and review of their work products.
• Conduct design and code reviews and maintain high quality for maintainability, performance, and security.
• Serve as the technical escalation point for complex conversion failures and data quality problems, leading root cause analysis.
• Mentor and develop technical consultants through knowledge transfer and feedback.
• Design, build, and execute the most complex conversions personally, including high-volume loads and multi-source consolidations.
• Lead conversion planning and go/no-go readiness for mock conversions and production cutover, presenting results to client leadership.
• Partner with clients and PMs to define data quality expectations and disposition decisions on problem records.
• Provide input into estimates and staffing plans for new work.

Skills

Advanced SQL

ETL Tools

Data Profiling

Data Mapping

Oracle/PLSQL

Data Modeling

Data Security

Mentorship

Education

Bachelor's degree in Computer Science / Information Systems / Software Engineering

Tools

Talend Data Services

SQL Loader

Job description

Unison is seeking a Senior Data Migration Consultant to serve as the senior technical authority for data conversion across federal programs, owning the migration strategy that moves legacy data into Unison's acquisition, grants management, and contract lifecycle solutions.

This hands-on senior delivery role requires leading complex conversions, setting data quality standards, and mentoring a team of technical consultants while delivering the most challenging migrations.