Data Migration Lead for Legacy Modernization (Hybrid)

iShift

Harrisburg (Dauphin County)

Hybrid

USD 120,000 - 150,000

Full time

19 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

iShift in Harrisburg, PA is seeking a Data Migration Lead / Data Conversion Analyst to drive end-to-end data migration for a large CAI application modernization initiative. This role requires strong SQL skills, relational data modeling, and hands-on ETL/ELT development to ensure accurate, secure data across systems.

The ideal candidate will lead migrations from discovery to production cutover, supervise testing and validation, and collaborate with product managers, architects, DBAs, and vendors

Qualifications

  • 7+ years of experience in data migration, data conversion, data engineering or related fields.
  • Strong hands-on SQL and relational database expertise.
  • Led large-scale legacy data migration from discovery through production cutover.
  • Understanding of data modeling, entity relationships, normalization, keys and referential integrity.
  • Hands-on source-to-target mapping, data profiling, cleansing and ETL/ELT development.
  • Experience with automated data validation, reconciliation, migration testing and defect resolution.
  • Ability to plan migrations, rehearsals, cutovers, rollback strategies and post-migration validation.

Responsibilities

  • Own end-to-end data migration strategy, architecture, planning, execution and delivery.
  • Analyze legacy databases, files, interfaces, historical records and data dependencies.
  • Design and maintain mappings, data dictionaries and data models.
  • Define migration, transformation, remediation, archival and retention strategies.
  • Develop and optimize ETL/ELT processes, SQL scripts, staging, validation and reconciliation.
  • Lead data profiling, cleansing, de-duplication and exception management.
  • Lead migration testing, trial conversions and data quality validation.
  • Plan production migrations, cutovers, rollback strategies and post-go-live validation.
  • Ensure data accuracy, integrity, security, traceability and privacy compliance.
  • Collaborate with PMs, BAs, architects, DBAs, developers and vendors.
  • Maintain technical documentation, runbooks, test results and defect logs.

Skills

Data migration leadership
SQL proficiency
Relational database modeling
ETL/ELT development
Data profiling & cleansing
Data reconciliation
Production cutover planning
Documentation & runbooks
Cross-functional collaboration

Education

Bachelor's degree in Computer Science / Information Systems / Data Engineering

Tools

Microsoft SQL Server
Microsoft Azure data services
Azure Data Factory
SSIS
Azure DevOps

Job description

iShift in Harrisburg, PA is seeking a Data Migration Lead / Data Conversion Analyst to drive end-to-end data migration for a large CAI application modernization initiative. This role requires strong SQL skills, relational data modeling, and hands-on ETL/ELT development to ensure accurate, secure data across systems.

The ideal candidate will lead migrations from discovery to production cutover, supervise testing and validation, and collaborate with product managers, architects, DBAs, and vendors

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Migration Lead / Data Conversion Analyst - 2 days Onsite Hybrid in Harrisburg, PA - Long Term Contract
Data Migration Lead / Data Conversion Analyst - 2 days Onsite Hybrid in Harrisburg, PA - Long Term Contract

iShift • Harrisburg

Hybrid
USD 120,000 - 150,000
Senior Data Conversion Lead: Drive Large-Scale Migrations
Senior Data Conversion Lead: Drive Large-Scale Migrations

Experis Technology Group • Town of Montana (WI)

On-site
USD 120,000 - 150,000
Medical Plans
Prescription Drug Plans
Dental Plan
+3
Senior Data Center Migration and Transformation Lead
Senior Data Center Migration and Transformation Lead

HMG AMERICA LLC • Pennsylvania

On-site
USD 140,000 - 190,000
Remote Data Migration Lead, ETL & Data Conversion
Remote Data Migration Lead, ETL & Data Conversion

Public Consulting Group • Boston (MA)

Hybrid
USD 75,000 - 125,000
Remote Senior Data Migration Engineer – Modernization
Remote Senior Data Migration Engineer – Modernization

Concept Solutions, LLC • Reston (VA)

Hybrid
USD 170,000 - 180,000
Hybrid Full-Stack Data Engineer: Modernization & Migration
Hybrid Full-Stack Data Engineer: Modernization & Migration

Manulife • Chicago (IL)

Hybrid
USD 86,000 - 136,000
Health insurance
Dental insurance
Mental health benefits
+5
Strategic Lead, Data Migration & Modernization
Strategic Lead, Data Migration & Modernization

Guidehouse • Arlington (VA)

Hybrid
USD 150,000 - 190,000
Medical, Rx, Dental & Vision Insurance
401(k) Retirement Plan
Tuition Reimbursement
+1
Data Migration Lead — Global Team, SQL/ETL
Data Migration Lead — Global Team, SQL/ETL

Applied Systems • United States

Remote
USD 120,000 - 170,000
Data Migration Analyst — AI-Assisted Legacy Data Mappings
Data Migration Analyst — AI-Assisted Legacy Data Mappings

Intégral • Tysons (VA)

On-site
USD 130,000 - 140,000
Paid parental leave
401(k) vesting
Medical, Dental & Vision Insurance
+3
Senior Data Migration & Modernization Lead
Senior Data Migration & Modernization Lead

Jobtome • Universal City (TX)

On-site
USD 149,000 - 248,000
Medical, Rx, Dental & Vision Insurance
401(k) Retirement Plan
Mobility Stipend
+1