Data Migration Lead

Ampcus Inc; City of White Plains (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Ampcus Inc. is seeking a Data Migration Lead to plan, coordinate, execute, and validate the migration of stakeholder and related business data into the Quorum SRM platform.

You will collaborate with stakeholders, Ampcus' implementation team, and Quorum product specialists to ensure data is transformed, validated, and loaded with quality while minimizing business disruption. The ideal candidate has a bachelor’s degree in a related field and at least 8 years of enterprise data migration

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Management, or related field.
• 8+ years planning and executing enterprise data migration projects.
• Experience migrating data into CRM/SRM/ERP or similar enterprise platforms.
• Experience with data profiling, ETL, data transformation, quality management, and reconciliation.
• Ability to define migration strategies, plans, and production cutover.
• Strong database knowledge and data governance practices.

Responsibilities

• Develop and manage the overall Data Migration Strategy, Plan, and Cutover.
• Assess source systems and identify stakeholder data for migration.
• Perform data profiling, quality assessments, and gap analysis.
• Define data mapping, transformation, cleansing, and reconciliation rules.
• Coordinate ETL activities using approved migration tools.
• Align migration processes with Quorum platform capabilities.
• Plan and execute migration rehearsals, mock conversions, and validation.
• Coordinate business validation and resolve migration issues before Go-Live.
• Support production cutover, post-migration verification, and Hypercare.
• Prepare migration documentation and data quality metrics.

Skills

Enterprise data migration

ETL processes

Data profiling

Data governance

Migration strategy

Stakeholder collaboration

SQL / relational databases

Education

Bachelor's degree in Computer Science or related discipline

Tools

CRM systems

ERP systems

SAP

Workday

ServiceNow

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Position Overview

The Data Migration Lead will be responsible for planning, coordinating, executing, and validating the migration of stakeholder and related business data from our existing systems into the proposed Quorum Stakeholder Relationship Management (SRM) Solution. Working under the direction of the Project Manager, this role will develop and execute the overall data migration strategy while ensuring data quality, integrity, security, and minimal disruption to business operations.

The Data Migration Lead will collaborate with our business and technical stakeholders, Ampcus' implementation team, and Quorum's product specialists, as required, to ensure migrated data is accurately transformed, validated, and successfully loaded into the Quorum platform.

Key Responsibilities

• Develop and manage the overall Data Migration Strategy, Migration Plan, and Cutover Plan.
• Assess source systems and identify stakeholder, contact, historical, and supporting business data required for migration.
• Perform data profiling, quality assessments, and gap analysis to identify inconsistencies, duplicates, incomplete records, and data quality issues.
• Define data mapping, transformation, cleansing, validation, and reconciliation rules in collaboration with our stakeholders.
• Coordinate data extraction, transformation, and loading (ETL) activities using approved migration tools and methodologies.
• Collaborate with Quorum's implementation specialists to ensure data structures, migration processes, and loading activities align with the supported capabilities of the Quorum platform.
• Plan and execute migration rehearsals, mock conversions, validation exercises, and production migration activities.
• Coordinate business validation of migrated data and resolve migration-related issues prior to Go-Live.
• Support production cutover, post-migration verification, reconciliation, and Hypercare activities.
• Prepare migration documentation, reconciliation reports, data quality metrics, and migration completion reports.
• Identify migration risks and implement appropriate mitigation strategies to ensure a successful and secure transition.

Minimum Qualifications (Mandatory)

• Bachelor's degree in Computer Science, Information Systems, Data Management, Engineering, or a related discipline.
• Minimum 8 years of experience planning and executing enterprise data migration projects.
• Demonstrated experience migrating data into Commercial-Off-the-Shelf (COTS) enterprise applications such as CRM, SRM, ERP, Asset Management, or similar enterprise platforms.
• Experience with data profiling, ETL processes, data transformation, data quality management, and reconciliation.
• Experience developing migration strategies, migration plans, and production cutover plans.
• Strong understanding of database concepts, relational data models, data governance, and data validation methodologies.

Preferred Qualifications

• Experience supporting data migration for Stakeholder Relationship Management (SRM), Customer Relationship Management (CRM), Enterprise Asset Management (EAM), or similar enterprise solutions.
• Experience working with enterprise applications such as SAP, Workday, ServiceNow, Primavera, Maximo, OpenText Content Server, or comparable business systems.
• Utility, energy, government, or other regulated industry implementation experience.
• Experience coordinating data migration activities with commercial software vendors during enterprise solution implementations.

Relevant Past Project Experience

The proposed Data Migration Lead should have successfully supported projects involving:

• Enterprise COTS solution data migration initiatives.
• Stakeholder, customer, asset, or enterprise master data migration.
• Data extraction, transformation, cleansing, validation, reconciliation, and production cutover.
• Enterprise application implementations involving CRM, SRM, ERP, or comparable business platforms.
• Enterprise systems integration and digital transformation projects.
• Utility, government, or other highly regulated industry implementations (preferred).

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.