Federal Data Migration Specialist - SQL & AI Validation

Integral Consulting Services

Tysons (VA)

On-site

USD 130,000 - 140,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, Dental & Vision Insurance
Flexible Spending Accounts
Short-Term and Long-Term Disability
Life Insurance
Paid Time Off & Holidays
Earned Bonuses & Awards
Professional Training Reimbursement

Job summary

Integral Federal is seeking a Data Migration Analyst to translate legacy data into approved VA-EISS mappings and business rules. You will validate AI-assisted drafts, run SQL, and ensure data quality during modernization projects.

The role collaborates with SMEs, architects, developers, and data engineers to confirm meaning and retention rules, while documenting lineage and exceptions for accurate migration.

Qualifications

  • Bachelor’s degree in computer science or IT related field; 3–6 years’ experience (additional years may substitute for a degree).
  • Strong SQL, data profiling, source-to-target mapping, data quality and reconciliation experience.
  • Experience interpreting complex legacy relational data and translating business rules into testable conversion specifications.
  • Ability to independently validate AI-generated mappings, SQL queries and analytical results against source evidence.
  • Strong facilitation skills with technical and business stakeholders.

Responsibilities

  • Profile legacy data, document source-to-target field mappings, lineage, reference codes, relationships and exceptions for VA-EISS conversion.
  • Collaborate with NCA SMEs, Functional Architects, developers and data engineers to confirm data meaning, retention and migration acceptance rules.
  • Review AI-generated mapping drafts, profiling SQL and reconciliation scripts for correctness, completeness and unsupported assumptions.
  • Define and execute data quality checks, sampling, exception queues and migration rehearsal acceptance criteria.
  • Track mapping decisions and data defects; verify converted records and audit evidence with the pod QA engineer.

Skills

SQL
Data profiling
Source-to-target mapping
Data quality
Reconciliation
AI validation
Facilitation
Public Trust

Education

Bachelor’s Degree in computer science or IT

Tools

Oracle
Salesforce
SQL Server

Job description

Integral Federal is seeking a Data Migration Analyst to translate legacy data into approved VA-EISS mappings and business rules. You will validate AI-assisted drafts, run SQL, and ensure data quality during modernization projects.

The role collaborates with SMEs, architects, developers, and data engineers to confirm meaning and retention rules, while documenting lineage and exceptions for accurate migration.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Federal Data Migration & Mapping Analyst
Federal Data Migration & Mapping Analyst

Integral • Tysons (VA)

Hybrid
USD 130,000 - 140,000
Medical Insurance
Dental Insurance
Vision Insurance
+5
Data Migration ETL Engineer — AI-Validated Pipelines
Data Migration ETL Engineer — AI-Validated Pipelines

Integral • Tysons (VA)

Hybrid
USD 130,000 - 140,000
Medical Insurance
Dental Insurance
Vision Insurance
+8
Data Migration ETL Engineer - AI-Validated Pipelines
Data Migration ETL Engineer - AI-Validated Pipelines

Integral Federal, Inc. • Tysons (VA)

On-site
USD 130,000 - 140,000
Medical, Dental & Vision Insurance
Flexible Spending Accounts
Disability Insurance
+5
Security-Cleared Data Migration ETL Engineer
Security-Cleared Data Migration ETL Engineer

Integral Federal, Inc. • McLean (VA)

On-site
USD 130,000 - 140,000
Medical, Dental & Vision Insurance
Paid Time Off & Holidays
Professional Training Reimbursement
+1
Data Migration ETL Engineer: AI-Driven Pipelines & Audits
Data Migration ETL Engineer: AI-Driven Pipelines & Audits

Integral Consulting Services • Tysons (VA)

On-site
USD 130,000 - 140,000
Medical, Dental & Vision Insurance
Flexible Spending Accounts
Short-Term and Long-Term Disability
+3
Data Migration ETL Engineer: SQL/Python Pipelines & Reconciliation
Data Migration ETL Engineer: SQL/Python Pipelines & Reconciliation

Integral Federal, Inc. • Tysons (VA)

On-site
USD 130,000 - 140,000
Medical, Dental & Vision Insurance
401(k) Matching
Paid Time Off & Holidays
+3
Enterprise Data Architecture Lead - Data Integration & Migration
Enterprise Data Architecture Lead - Data Integration & Migration

Integral Federal, Inc. • Tysons (VA)

On-site
USD 150,000 - 160,000
Medical, Dental & Vision Insurance
Flexible Spending Accounts
Short-Term and Long-Term Disability
+5
Data Migration Analyst
Data Migration Analyst

Integral Consulting Services • Tysons (VA)

On-site
USD 130,000 - 140,000
Medical, Dental & Vision Insurance
Flexible Spending Accounts
Short-Term and Long-Term Disability
+4
Data Integration Developer - AI-Reviewed Mappings & ETL
Data Integration Developer - AI-Reviewed Mappings & ETL

Integral Consulting Services • Tysons (VA)

On-site
USD 130,000 - 140,000
Medical, Dental & Vision Insurance
Flexible Spending Accounts
Short-Term and Long-Term Disability
+5
Data Migration Analyst
Data Migration Analyst

Integral • Tysons (VA)

Hybrid
USD 130,000 - 140,000
Medical Insurance
Dental Insurance
Vision Insurance
+5