Senior Data Migration Architect — Federal Programs

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

Job summary

Unison Software is seeking a Senior Data Migration Consultant to lead data conversion across federal programs, owning the migration strategy for legacy data into Unison's acquisition, grants management, and contract lifecycle solutions. This is a hands-on senior delivery role with mentorship and architectural influence across source systems.

The role requires deep SQL expertise, data migration experience, and the ability to guide a team through complex conversions while delivering critical,

Qualifications

• Experience planning and executing data migration or data conversion efforts.
• Prior software development experience is highly preferred.
• Experience owning conversion strategy and data architecture decisions across multiple source systems.
• Experience guiding other technical staff through design and code reviews.

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 hold the quality bar for maintainability, performance, and security across the technical team
• Serve as the technical escalation point for complex conversion failures and data quality problems, leading root cause analysis and durable resolution
• Mentor and develop technical consultants, building depth on the team through knowledge transfer, pairing, and structured feedback
• Design, build, and execute the most complex conversions personally, including high-volume loads and multi-source consolidations
• Lead conversion planning and go or no-go readiness assessment for mock conversions, rehearsals, and production cutover, and present results to client leadership
• Partner with clients, functional consultants, and project managers to define data quality expectations, cleansing responsibilities, and disposition decisions on problem records
• Provide technical input into estimates, level of effort, staffing plans, and proposal and capture activities for new and follow-on work
• Assess conversion risk across the program, including data quality, source system availability, environment readiness, load performance, and cutover window constraints
• Serve as a trusted technical advisor in client-facing meetings, design sessions, and data governance forums

Skills

Advanced SQL

Data profiling

Data cleansing

Data deduplication

Data quality analysis

Data mapping

Transformation logic

Crosswalk development

Legacy data extraction

Data modeling

PII handling

Education

Bachelor's degree in Computer Science/Info Systems/Software Engineering or related field

Tools

Talend Data Services

SQL Loader

Oracle databases

PL/SQL

Job description

Unison Software is seeking a Senior Data Migration Consultant to lead data conversion across federal programs, owning the migration strategy for legacy data into Unison's acquisition, grants management, and contract lifecycle solutions. This is a hands-on senior delivery role with mentorship and architectural influence across source systems.

The role requires deep SQL expertise, data migration experience, and the ability to guide a team through complex conversions while delivering critical,