Senior Data Migration Technical Consultant

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’s products power the business of government to work smoother and smarter, making critical federal processes and acquisitions simpler and more effective. Trusted by over 200,000 federal employees and government contractors, our AI-infused software and deep domain expertise help contract shops, cost engineers, 1102s, program managers, and budgeting professionals cut through friction, keep compliance airtight, and sharpen decisions. Our federal focus brings efficiency, transparency, and clarity to complex data, regulations, and workflows, empowering agencies and executives to spend more minutes on mission and achieve strategic objectives. Unison is how federal business gets done.

Unison is proud to be recognized as a 2026 Quantum Certified Workplace™ in Washington D.C., reflecting our continued focus on building a workplace where people feel supported and teams thrive.

Position Summary

Unison Software is seeking 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 community customers.

This is a hands-on technical delivery role. Data Migration Consultants profile and analyze source data, build extraction and transformation routines, execute mock conversions and production loads, and reconcile results, working directly with clients, functional consultants, and project managers to ensure converted data is accurate, complete, and usable on day one.

Data volume, number of source systems, and depth of independent ownership scale with experience level and are defined in the specific job posting.

Key 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, and document results
• Partner with clients and functional consultants to resolve data quality issues, define cleansing rules, and make disposition decisions on problem records
• Coordinate conversion activities with configuration, testing, training, and cutover workstreams so converted data is available when needed
• Troubleshoot conversion failures and data defects, perform root cause analysis, and implement sustainable resolutions
• Create and maintain technical documentation, including mapping specifications, conversion procedures, reconciliation results, and cutover runbooks
• Support post-conversion activities, including data validation support, defect resolution, and residual cleanup

Qualifications

Preferred Experience

• Professional experience planning and executing data migration or data conversion efforts, with depth of experience commensurate with the level of the position
• Prior software development experience is highly preferred
• Experience converting data into enterprise systems such as ERP, financial management, procurement, or personnel systems
• Experience supporting enterprise software or large-scale system implementations
• Experience working in structured delivery environments (Agile, Waterfall, or hybrid)
• Experience supporting software implementations for federal government agencies or government contractors is preferred

Technical Skills and Exposure

• Advanced SQL skills and hands-on experience with relational databases
• ETL processes and tools such as Talend Data Services or comparable platforms
• Data profiling, cleansing, deduplication, and data quality analysis techniques
• Data mapping, transformation logic, and crosswalk development between source and target systems
• Oracle databases, PL/SQL, SQL Loader, or comparable bulk data load technologies
• Reconciliation methods, control totals, and validation reporting
• Legacy system data extraction, including flat files, exports, and direct database extraction
• Data modeling concepts and relational database structures
• Handling of sensitive data during conversion, including masking and protection of test and production data sets

Federal Delivery and Data Environment

Familiarity with one or more of the following is preferred:

• Federal acquisition, contract, grants, and financial data structures and the systems that produce them
• Interfaces with federal financial, procurement, personnel, and reporting systems
• Handling of sensitive federal data, including personally identifiable information (PII) and controlled unclassified information (CUI)
• Federal security and compliance requirements, including FISMA, authority to operate (ATO), and Section 508 accessibility
• Working with government technical points of contact, information system security officers, and system owners

Core Skills and Abilities

• Strong analytical and problem-solving skills, including with ambiguous or poorly documented systems and data
• Clear, concise written and verbal communication, including with non-technical client stakeholders
• Ability to manage multiple priorities in a collaborative, client-facing environment
• Ability to adapt quickly to new technologies and evolving client requirements

Education and Certifications

• Bachelor's degree (BA or BS) in Computer Science, Information Systems, Software Engineering, or a related technical field, or equivalent professional experience
• Relevant technical certifications in database, cloud, or integration platform technologies are a plus

Clearance

Applicants may need to be the subject of a security investigation and may need to meet eligibility requirements for access to classified information.

Work Location and Travel

Work location, on-site requirements, and travel expectations vary by program.

In-Person Interview:

Our hiring process requires an in-person meeting, typically the final interview. Travel and accommodations will be provided.

Clearance:

Applicants may need to be the subject of a security investigation and may need to meet eligibility requirements for access to classified information, to include U.S. Citizenship.

Why Join Unison:

Unison has pioneered the creation of innovative software for federal agencies, program offices, and government contractors worldwide. We believe that there is power in moving in unison. Our culture and values reflect this belief and are central to achieving our mission of powering the business of government. Rather than chasing short-lived tech trends, Unison delivers proven software that simplifies the complexities of federal business. Our technology combines innovative thinking with precise federal know-how, addressing critical details others overlook. Designed with purpose and engineered to endure, our software provides consistent performance, allowing federal agencies and contractors to stay focused on their missions.

Unison provides equal employment opportunities to all employees and applicants for employment without regard to race, color, national origin, sex, gender identity, sexual orientation, religion, disability status, age, genetics, veteran status, or any other characteristic protected by federal, state, or local laws.