Job Summary
We are seeking an experienced PDV Data Modeler / LSC Migration Lead to lead data modeling, mapping, transformation, and migration initiatives within enterprise data environments. The ideal candidate will have strong experience in data modeling, data migration, data architecture, and data integration, with the ability to translate business and source-system requirements into scalable target data models. The role involves collaborating with business stakeholders, data architects, engineering teams, and application teams to support LSC/PDV data migration, ensure data quality and integrity, and drive successful migration from legacy platforms to target-state environments.
Key Responsibilities
• Lead the design and development of conceptual, logical, and physical data models for PDV/LSC data domains.
• Analyze legacy and source-system data structures and define target data models, mappings, and transformation rules.
• Lead end-to-end data migration activities, including data discovery, profiling, mapping, transformation, validation, reconciliation, and cutover.
• Collaborate with business stakeholders, data architects, data engineers, and application teams to understand data requirements and define migration solutions.
• Develop and maintain detailed source-to-target mappings, data dictionaries, business rules, and technical documentation.
• Identify data quality issues, inconsistencies, and dependencies and coordinate with relevant teams to resolve them.
• Establish data validation and reconciliation processes to ensure the completeness, accuracy, consistency, and integrity of migrated data.
• Provide technical leadership throughout migration planning, execution, testing, deployment, and post-migration support.
• Support data integration across enterprise applications and platforms while ensuring alignment with data architecture and governance standards.
• Identify migration risks, dependencies, and technical challenges and develop appropriate mitigation strategies.
• Coordinate with cross-functional teams to track migration milestones, deliverables, and issues.
• Mentor team members and establish best practices for data modeling, migration, documentation, and data quality.
• Lead onshore and offshore technical teams and manage migration deliverables.
Required Qualifications
• 8+ years of experience in data modeling, data architecture, data migration, or data engineering.
• Strong hands-on experience with conceptual, logical, and physical data modeling.
• Experience with PDV/LSC data environments or similar enterprise data platforms.
• Experience with large-scale enterprise data migration and transformation initiatives.
• Strong SQL skills and experience working with relational and/or cloud data platforms.
• Experience developing source-to-target mappings, transformation logic, data dictionaries, and migration specifications.
• Strong understanding of data quality, data profiling, reconciliation, and validation processes.
• Experience collaborating with cross-functional teams, including business analysts, architects, data engineers, and application teams.
• Strong communication, analytical, problem-solving, and technical leadership skills.
• Experience with ETL/ELT tools such as Informatica, Talend, DataStage, or similar platforms.
• Familiarity with data governance, metadata management, and master/reference data concepts.
• Experience with data modeling tools such as ER/Studio, Erwin, or similar tools.
Preferred Qualifications
• Experience with life sciences data and related enterprise applications.
• Experience with Snowflake, Databricks, AWS, Azure, or GCP.
• Experience leading onshore and offshore technical teams and managing migration deliverables.
