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

iShift

Harrisburg (Dauphin County)

Hybrid

USD 120,000 - 150,000

Full time

19 hours 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

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

Location: Harrisburg, PA
Work Arrangement: Hybrid
Employment Type: Long-Term Contract
Duration: 2+ Years
Position Overview

We are seeking an experienced, hands-on Data Migration Lead / Data Conversion Analyst to lead the end-to-end data conversion workstream for a large-scale Customer Account Information (CAI) application modernization initiative.

The ideal candidate will have strong expertise in legacy data migration, relational database modeling, SQL, ETL/ELT processes, data profiling, cleansing, transformation, and reconciliation.

This role will be responsible for assessing legacy databases, defining data migration strategies, designing source-to-target mappings, developing conversion processes, and leading migration testing, production cutover, and post-migration validation.

Key Responsibilities
  • Own the end-to-end data migration strategy, architecture, planning, execution, and delivery.
  • Analyze legacy databases, files, interfaces, historical records, business rules, and data dependencies.
  • Design and maintain source-to-target mappings, data dictionaries, logical and physical data models, and entity relationships.
  • Define data migration, transformation, remediation, archival, and retention strategies.
  • Develop and optimize ETL/ELT processes, SQL scripts, staging structures, validation controls, and reconciliation reports.
  • Perform data profiling, cleansing, de-duplication, standardization, and exception management.
  • Lead migration testing, trial conversions, data quality validation, and reconciliation activities.
  • Plan and execute production migrations, cutovers, rollback strategies, and post-go-live validation.
  • Ensure data accuracy, integrity, security, traceability, and compliance with applicable privacy requirements.
  • Collaborate with Product Managers, Business Analysts, Solution Architects, Developers, DBAs, and business stakeholders.
  • Maintain technical documentation, migration runbooks, test results, defect logs, and knowledge-transfer materials.
Required Qualifications
  • 7+ years of experience in Data Migration, Data Conversion, Data Engineering, Database Development, or Data Analysis.
  • Strong hands-on SQL experience and relational database expertise.
  • Proven experience leading at least one large-scale legacy application data migration from discovery through production cutover.
  • Strong understanding of relational data modeling, entity relationships, normalization, keys, and referential integrity.
  • Hands-on experience with source-to-target mapping, data profiling, cleansing, ETL/ELT development, and complex data transformations.
  • Experience with automated data validation, reconciliation, migration testing, and defect resolution.
  • Experience planning migration rehearsals, production cutovers, rollback strategies, and post-migration validation.
  • Ability to work closely with technical teams, architects, DBAs, business stakeholders, and vendors.
  • Strong documentation, communication, analytical, and problem-solving skills.
  • Understanding of data security, role-based access, data integrity, auditability, and privacy requirements.
Preferred Qualifications
  • Experience modernizing legacy transactional, customer information, or case-management applications.
  • Experience with public-sector, utilities, financial services, or other regulated industries.
  • Familiarity with Microsoft SQL Server, Microsoft Azure data services, Azure Data Factory, or SSIS.
  • Experience with phased migrations, incremental/delta conversions, and data synchronization.
  • Knowledge of data governance, metadata management, data lineage, master data, and data quality management.
  • Experience with Azure DevOps, source control, and automated migration pipelines.
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent experience.
  • PMP or relevant data engineering certifications are a plus.
Ideal Candidate Profile

The ideal candidate will have hands-on experience leading enterprise-level data migration and conversion projects, particularly involving legacy application modernization and complex transactional databases.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Migration Lead for Legacy Modernization (Hybrid)
Data Migration Lead for Legacy Modernization (Hybrid)

iShift • Harrisburg

Hybrid
USD 120,000 - 150,000
Product /Project Manager – Large Scare Data Migration background (Public Sector background) - 2 days Onsite Hybrid in Harrisburg, PA - 4 Years Contract
Product /Project Manager – Large Scare Data Migration background (Public Sector background) - 2 days Onsite Hybrid in Harrisburg, PA - 4 Years Contract

iShift • Harrisburg

Hybrid
USD 120,000 - 160,000
Data Migration Lead
Data Migration Lead

Procentrix • Washington

On-site
USD 150,000 - 170,000
Data Conversion Specialist
Data Conversion Specialist

Tryfacta, Inc. • Miami (FL)

On-site
USD 80,000 - 110,000
Salesforce Data Migration Architect
Salesforce Data Migration Architect

Access Data Consulting Corporation • Phoenix (AZ)

Hybrid
USD 85,000 - 121,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
Senior Technical Data Migration Lead – Salesforce & Azure
Senior Technical Data Migration Lead – Salesforce & Azure

NexTurn • King of Prussia (PA)

On-site
USD 150,000 - 190,000
Data Engineer-DBA
Data Engineer-DBA

Amtex Enterprises,Inc • Trenton (NJ)

Hybrid
USD 120,000 - 150,000
Sr. Data Analyst – ETL, SQL, AWS Glue
Sr. Data Analyst – ETL, SQL, AWS Glue

Mavensoft Technologies, LLC • Portland (OR)

Hybrid
USD 95,000 - 145,000
Senior Data Engineer
Senior Data Engineer

S R INTERNATIONAL INC • United States

Remote
USD 130,000 - 170,000