Data Migration Analyst

Integral Federal, Inc.

Tysons (VA)

On-site

USD 130,000 - 140,000

Full time

8 days ago

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
401(k) with immediate vesting
Parental leave
Flexible Spending Accounts
Short-Term and Long-Term Disability
Life Insurance
Paid Time Off & Holidays
Bonuses & Awards
Training Reimbursement
Employee Assistance Program

Job summary

Integral Federal is seeking a Data Migration Analyst to translate legacy BOSS-E and MBMS data into approved mappings, business rules, and reconciliation criteria for VA-EISS modernization.

You will profile legacy data, document source-to-target mappings, collaborate with SMEs and developers, and review AI-generated drafts while validating SQL against authoritative records.

Qualifications

  • Bachelor’s Degree in computer science or IT related degree with 3-6 years’ experience.
  • 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 and relationships for VA-EISS.
  • Collaborate with SMEs, Architects, developers and data engineers to confirm data meaning and migration rules.
  • Review AI-generated mapping drafts, profiling SQL and reconciliation scripts for correctness.
  • Define and execute data quality checks, sampling, and migration rehearsal acceptance criteria.
  • Track mapping decisions and data defects; verify converted records and audit evidence.

Skills

SQL
Data profiling
Data mapping
Data quality
Reconciliation
Facilitation
AI-assisted data analysis

Education

Bachelor’s Degree in CS or IT-related field

Tools

Oracle
Salesforce
SQL Server
Python

Job description

Overview

The Data Migration Analyst translates legacy BOSS-E, MBMS and related data into approved VA-EISS source-to-target mappings, business rules and reconciliation criteria. Use AI-assisted analysis only where VA-authorized and validate generated mappings and SQL against authoritative records in support of VA-EISS modernization.

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.
Qualifications

Required:

  • Bachelor’s Degree in computer science or IT related degree with 3-6 years’ experience. Additional years of experience can substitute for a degree for the right candidate.
  • 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.
  • Public Trust

Preferred:

  • BOSS-E, MBMS, EISS or cemetery/memorial case data; Oracle, Salesforce and SQL Server data structures.
  • Large-scale federal data migration, record retention and personally identifiable information controls.
  • Python, data catalog/lineage methods and approved AI-assisted data analysis.

Salary range: $130,000-$140,000

This position is in the proposal stage. The above salary range represents a general guideline. Integral Federal considers a number of factors when determining base salary offers, such as the scope and responsibilities of the position and the candidate's experience, education, skills, and current market conditions.

Depending on the position, employees may be eligible for overtime, shift differential, and/or discretionary bonuses in addition to base pay.

Company Overview

Integral partners with federal defense, intelligence, and civilian leaders to tackle their most important challenges and deliver positive outcomes. Since our founding in 1998, we have helped clients leverage existing and emerging technologies to transform their enterprises, empower growth, drive innovation, and build sustainable success. The forward-leaning solutions we deliver are tailored to each mission with a focus on keeping our nation safe and secure.

Integral is headquartered in McLean, VA and serves clients throughout the country.

We offer a comprehensive total rewards package including paid parental leave and immediate vesting in our 401(k). Give us a try and become part of a curated group of professionals at Integral Federal!

Our package also includes:

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

Equal Opportunity Employer/Protected Veteran/Disability

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Migration Analyst
Data Migration Analyst

Integral • Tysons (VA)

Hybrid
USD 130,000 - 140,000
Medical Insurance
Dental Insurance
Vision Insurance
+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 Migration ETL Engineer with Security Clearance
Data Migration ETL Engineer with Security Clearance

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
Data Migration ETL Engineer

Integral Federal, Inc. • Tysons (VA)

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

Integral Federal, Inc. • Tysons (VA)

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

Integral • Tysons (VA)

Hybrid
USD 130,000 - 140,000
Medical Insurance
Dental Insurance
Vision Insurance
+8
Enterprise Data Architecture Lead
Enterprise Data Architecture Lead

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
+7
Integration and Data Software Engineer
Integration and Data Software Engineer

Integral Federal, Inc. • Tysons (VA)

On-site
USD 135,000 - 145,000
Medical Insurance
Dental Insurance
Vision Insurance
+4
Integration and Data Software Engineer
Integration and Data Software Engineer

Intégral • Tysons (VA)

On-site
USD 135,000 - 145,000
Medical, Dental & Vision Insurance
Flexible Spending Accounts
Short-Term and Long-Term Disability
+5
Integration and Data Software Engineer
Integration and Data Software Engineer

Integral • Tysons (VA)

Hybrid
USD 135,000 - 145,000
Medical, Dental & Vision Insurance
401(k) with immediate vesting
Paid Time Off & Holidays