Data Migration Lead

Job Overview

This position demands authoritative leadership in data migration, ideally with extensive experience in Siebel migrations.

Key Responsibilities

• Develop comprehensive migration strategies covering scope, timelines, dependencies, resources, and controls.
• Evaluate source data architectures, interdependencies, volumes, histories, supporting documentation, quality, and embedded business rules within databases.
• Lead the mapping from source to target, design data transformations, decide on data retention, and oversee migration of both historical and current records.
• Oversee the creation of extraction, staging, transformation, loading, and incremental update processes.
• Implement Siebel's EIM, EAI, and other designated loading techniques suitable for the target environment.
• Set standards for data validation, financial and operational reconciliation, exception handling, and acceptance benchmarks.
• Organize and direct migration testing phases, including mock runs, performance checks, cutover execution, rollback procedures, and post-migration support.
• Manage coordination among business, data, database, integration, and target system teams, alongside tracking risk, issues, decisions, and progress notifications.

Desired Qualifications

• Demonstrated leadership in managing intricate data migration projects involving multiple entities.
• Deep practical knowledge of data profiling, ETL frameworks, source-target mapping, data quality assurance, reconciliation methodology, and migration testing processes.
• Extensive hands-on experience with Siebel data migration, particularly mastery of EIM and EAI components.
• Experience handling migration of complex financial or transactional datasets inclusive of relationships, audit trails, and associated documents.
• Advanced proficiency in SQL and relational database management, with preference for SQL Server environments in large-scale migration contexts.
• Capability to codify business rules into migration workflows and communicate reconciliation outcomes effectively to business stakeholders.
• Exceptional abilities in project planning, team leadership, communication, and risk management.