Federal Data Migration & Mapping Analyst

Integral; Tysons (VA); Hybrid; USD 130,000 - 140,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k) plan

PTO & Holidays

Bonuses & Awards

Training Reimbursement

Employee Assistance

Job summary

Integral is seeking a Data Migration Analyst to translate legacy data into approved VA-EISS mappings, rules and reconciliation criteria. The role collaborates with SMEs, architects, and engineers to validate data meaning, retention and migration acceptance.

The ideal candidate has 3–6 years of experience, strong SQL and data profiling skills, and a track record of translating complex legacy data into testable conversion specifications. Public Trust clearance is required.

Qualifications

• Bachelor’s Degree in computer science or IT with 3–6 years’ experience.
• Strong SQL, data profiling, source-to-target mapping, data quality and reconciliation experience.
• Ability to validate AI-generated mappings, SQL against source evidence.
• Public Trust

Responsibilities

• Profile legacy data and document source-to-target field mappings, lineage and exceptions for VA-EISS conversion.
• Collaborate with SMEs, Architects, developers and data engineers on data meaning and migration rules.
• Review AI-generated mappings, profiling SQL and reconciliation scripts for correctness and completeness.
• Define and execute data quality checks, sampling and migration rehearsal criteria.
• Track mapping decisions and data defects; verify converted records and audit evidence.

Skills

SQL

Data profiling

Mapping

Data quality

Reconciliation

Legacy data interpretation

Facilitation

Education

Bachelor’s Degree in CS or IT

Tools

Python

Oracle

Salesforce

SQL Server

Job description

Integral is seeking a Data Migration Analyst to translate legacy data into approved VA-EISS mappings, rules and reconciliation criteria. The role collaborates with SMEs, architects, and engineers to validate data meaning, retention and migration acceptance.

The ideal candidate has 3–6 years of experience, strong SQL and data profiling skills, and a track record of translating complex legacy data into testable conversion specifications. Public Trust clearance is required.