Data Migration ETL Engineer

Integral Consulting Services

Tysons (VA)

On-site

USD 130,000 - 140,000

Full time

7 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

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
Professional Training Reimbursement

Job summary

Integral Federal in Tysons Corner, VA seeks a Data Migration ETL Engineer to design repeatable pipelines migrating data from legacy VA sources into VA-EISS. You will review AI-generated ETL scripts to ensure integrity and accuracy during modernization.

Responsibilities include building pipelines, validating data quality, and coordinating with VA stakeholders to resolve schema issues, ensuring auditability and secure data handling. Public Trust clearance is required.

Qualifications

  • Bachelor’s Degree in computer science or IT related degree with 3-6 years’ experience.
  • Hands-on SQL and data engineering experience with ETL/ELT, relational data modeling and large-volume database migration.
  • Ability to code and debug Python/SQL scripts and review AI-generated transformation logic critically.
  • Practical understanding of source-to-target reconciliation, exception management and migration testing.
  • Experience building repeatable, version-controlled pipelines and supporting cutovers.
  • Public Trust

Responsibilities

  • Build SQL/Python/ETL pipelines, staging schemas, data cleansing rules, transformation jobs and automated reconciliation reports.
  • Review AI-generated extraction, migration and rollback scripts for accuracy, performance, idempotency, security and repeatability.
  • Execute migration rehearsals, measure throughput and data quality, diagnose exceptions and support final cutover plans.
  • Implement automated row-level and business-rule reconciliation across source/target systems with appropriate evidence and audit logs.
  • Coordinate with Data Analyst, Data Architect, QA Lead and VA stakeholders to resolve schema mismatches and mapping defects.

Skills

SQL
Python
ETL/ELT
Data modeling
Data migration
Code review
Reconciliation

Education

Bachelor’s Degree in computer science or IT related degree

Tools

SQL Server
Oracle
Salesforce extracts
AWS GovCloud
VAEC services
DevSecOps automation

Job description

Position Title: Data Migration ETL Engineer

Location: US-Virginia-Tysons Corner

Job ID: 5501

# of Openings: 1

Category: Information Technology

Clearance: Public Trust

Clearance Status: Ability to Obtain

Type: Regular Full-Time

The Data Migration ETL Engineer implements repeatable, auditable migration pipelines from BOSS-E, MBMS and related VA legacy sources into VA-EISS. Critically review AI-generated ETL scripts and data transformations, verifying that every conversion preserves required business meaning and record integrity in support of VA-EISS modernization.

Responsibilities:
  • Build SQL/Python/ETL pipelines, staging schemas, data cleansing rules, transformation jobs and automated reconciliation reports.
  • Review AI-generated extraction, migration and rollback scripts for accuracy, performance, idempotency, security and repeatability.
  • Execute migration rehearsals, measure throughput and data quality, diagnose exceptions and support final cutover plans.
  • Implement automated row-level and business-rule reconciliation across source/target systems with appropriate evidence and audit logs.
  • Coordinate with Data Analyst, Data Architect, QA Lead and VA stakeholders to resolve schema mismatches and mapping defects.

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.
  • Hands-on SQL and data engineering experience with ETL/ELT, relational data modeling and large-volume database migration.
  • Ability to code and debug Python/SQL scripts and review AI-generated transformation logic critically.
  • Practical understanding of source-to-target reconciliation, exception management and migration testing.
  • Experience building repeatable, version-controlled pipelines and supporting cutovers.
  • Public Trust

Preferred:

  • SQL Server, Oracle, Salesforce extracts, AWS GovCloud/VAEC services and DevSecOps automation.
  • Federal benefits or cemetery systems, auditability/PII protections, historical conversion and GIS data migration.
  • Experience with synthetic data, reconciliation automation and VA-authorized AI coding tools.

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.

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

Equal employment opportunity, including veterans and individuals with disabilities.

PI288312455

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
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
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 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 Analyst
Data Migration Analyst

Integral Federal, Inc. • Tysons (VA)

On-site
USD 130,000 - 140,000
Medical, Dental & Vision Insurance
401(k) with immediate vesting
Parental leave
+7
Data Integration Developer
Data Integration Developer

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

Integral Consulting Services • Tysons (VA)

On-site
USD 135,000 - 145,000
Medical, Dental & Vision Insurance
401(k) with immediate vesting
Paid Time Off & Holidays
+1
Enterprise Data Architecture Lead
Enterprise Data Architecture Lead

Integral Consulting Services • Tysons (VA)

On-site
USD 150,000 - 160,000
Medical, Dental & Vision Insurance
401(k) Retirement Plan
Paid Time Off & Holidays
+4