Data Migration Lead

About the Role
This position requires strong leadership in migration efforts, with a preference for candidates who have experience with Siebel migrations. The successful applicant will define and execute a comprehensive migration strategy while leading data migration initiatives that encompass various business systems.

Responsibilities

• Define the migration strategy, scope, work plan, dependencies, resource needs, and delivery controls.
• Assess source data structures, relationships, volumes, history, documents, data quality, and business rules embedded in database code.
• Lead source-to-target mapping, transformation design, data retention decisions, and migration of historical and in-flight records.
• Direct the design and development of extraction, staging, transformation, loading, and delta processes.
• Apply Siebel EIM, EAI, and other approved Siebel loading methods as appropriate to the target design.
• Establish data validation, financial and operational reconciliation, exception management, and acceptance criteria.
• Plan and lead migration testing, mock runs, performance testing, cutover, rollback, and post-migration support.
• Coordinate business, data, database, integration, and target-system teams; manage risks, issues, decisions, and progress reporting.

Qualifications

• Proven experience leading complex, multi-entity data migration programs.
• Strong hands-on understanding of data profiling, ETL, source-to-target mapping, data quality, reconciliation, and migration testing.
• Substantial Siebel data migration experience is highly required, including practical knowledge of EIM and EAI.
• Experience migrating financial or transactional data with complex relationships, audit history, and supporting documents.
• Strong SQL and relational database experience, preferably with SQL Server and large-scale migration environments.
• Ability to translate business rules into migration logic and explain reconciliation results to business stakeholders.
• Strong planning, leadership, communication, and risk-management skills.