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 migrations into the Quorum SRM solution.

You will work with the Project Manager, business and technical stakeholders, and Ampcus' implementation team to ensure data quality and a secure Go-Live. The role requires 8+ years in enterprise data migration, experience with CRM/SRM/ERP data, ETL and data quality processes, and strong data governance.

Qualifications

• Bachelor's degree required in a related field.
• 8+ years leading enterprise data migrations.
• Experience with data profiling, mapping, and validation.
• Experience with ETL, data transformation, and reconciliation.

Responsibilities

• Develop and manage the overall Data Migration Strategy, Migration Plan, and Cutover Plan.
• Assess source systems and identify stakeholder, contact, historical, and supporting data.
• Perform data profiling, quality assessments, and gap analysis.
• Define data mapping, transformation, cleansing, validation, and reconciliation rules.
• Coordinate ETL activities using approved migration tools and methodologies.
• Collaborate to ensure data structures and loading align with the Quorum platform.
• Plan and execute migration rehearsals, mock conversions, and production migration.
• Coordinate business validation of migrated data and resolve issues pre Go-Live.
• Support production cutover, post-migration verification, and Hypercare.
• Prepare migration documentation and data quality metrics.

Skills

8+ years data migration experience

Data governance

ETL proficiency

Migration planning

Education

Bachelor's degree in Computer Science, Information Systems, Data Management, Engineering, or a related discipline

Tools

SAP

Workday

ServiceNow

Primavera

Maximo

OpenText Content Server

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.