First seen by Alion on Nov 17, 2026.
Job Summary:
We are looking for an experienced Data Migration Lead with 10+ years of experience in data engineering, ETL, and enterprise data migration. The candidate will lead end-to-end data migration activities across multiple workstreams, including source-to-target mapping, data cleansing, transformation, loading, validation, and reconciliation.
The role requires strong technical expertise in SQL, Python, ETL processes, and ERP/CRM migrations, along with proven experience in managing complex migration projects and coordinating with cross-functional stakeholders.
Key Responsibilities:
- Lead end-to-end data migration activities across assigned workstreams.
- Define and manage source-to-target data mappings for customers, products, licences, orders, contracts, and other business entities.
- Perform data profiling, cleansing, deduplication, and standardisation to address missing fields, invalid codes, and inconsistent formats.
- Develop and execute data transformation and loading scripts using SQL, Python, or equivalent scripting languages.
- Manage data migration into enterprise systems such as SAP, Salesforce, ERP, CRM, legacy platforms, and e-commerce applications.
- Oversee customer data matching, cross-system ID mapping, and record reconciliation.
- Plan and execute QA cycles, mock migrations, test loads, and production migration activities.
- Generate record-count reports, field-level reconciliation reports, and exception reports.
- Identify and resolve migration defects in coordination with source-system owners and technical teams.
- Drive automation of repetitive migration activities to minimise manual intervention.
- Maintain documentation of data mappings, transformation rules, migration procedures, and cutover activities.
- Coordinate with business, technical, and application teams to ensure successful migration and post-migration support.
Required Skills & Qualifications:
- 10+ years of experience in Data Engineering, Data Migration, ETL development, or related technical roles.
- Proven experience delivering at least two end-to-end production data migration projects.
- Strong proficiency in SQL and Python (or equivalent scripting languages).
- Hands-on experience with ERP/CRM migration tools, preferably SAP LSMW, BAPIs, Migration Cockpit, IDocs, Salesforce Data Loader, or Bulk API.
- Strong understanding of ETL processes, data profiling, cleansing, deduplication, and reconciliation techniques.
- Experience working with file-based data extracts and cloud storage platforms such as AWS S3.
- Experience leading migration workstreams, troubleshooting complex data issues, and coordinating with multiple stakeholders.
- Strong analytical, problem-solving, documentation, and communication skills.
Preferred Skills:
- Experience with legacy platforms such as AS400/IBM i, including CL, RPG, or DB2 for i.
- Knowledge of Kafka or other enterprise integration platforms.
- Exposure to entitlement and licensing data, including institutional licences, IP ranges, SSO, and consortia affiliations.
- Familiarity with cloud data warehouses such as Google BigQuery.
- Domain experience in subscription-based, licensing, or content-driven businesses.
Key Success Metrics:
- Completion and sign-off of source-to-target mappings for assigned entities.
- Successful migration loads meeting agreed data reconciliation and quality thresholds.
- Timely identification and resolution of defects during mock migration and QA cycles.
- Accurate and complete migration of data into target systems.
- Effective automation, documentation, and handover of migration processes.
Ideal Candidate Profile:
A senior data migration professional with strong hands-on technical expertise and proven leadership experience in managing complex enterprise data migration initiatives. The candidate should be capable of independently driving migration workstreams, ensuring data integrity, managing stakeholders, and delivering successful production cutovers.
Skills
Data Engineering, Data Migration, ETL, SQL, Python, Data Profiling, Kafka, BigQuery, Data Warehousing

