Senior Product Manager/Business Analyst Data Migration

Role: Senior Product Manager – Data Migration & Legacy SystemsLocation: Pleasanton, CA (Hybrid)Duration: 6+ monthsOverview: The Product Management team is seeking a senior-level consultant with deep expertise in data analysis, enterprise data architecture, and modernization of siloed legacy systems. This role will be instrumental in designing and establishing a unified enterprise data pipeline that supports long-term legacy system decommissioning and modernization initiatives. This is a highly technical and strategic role requiring strong experience across enterprise data ecosystems, integration patterns, data engineering, and modernization of complex legacy environments. The ideal candidate will help drive consistency, standardization, governance compliance, and architectural integrity across all modernization and transformation activities. The consultant will work closely with product, architecture, engineering, security, and business teams to ensure enterprise data flows are scalable, aligned, and capable of supporting future-state modernization objectives.Key Responsibilities:Lead enterprise data modernization and legacy system transformation initiativesDesign and help establish a unified enterprise data pipeline supporting modernization and decommissioning roadmapsDefine and standardize enterprise data flows, integration patterns, and data movement strategiesAnalyze, profile, cleanse, and map complex legacy data structures to modern platforms and enterprise systemsDevelop and maintain Data Mapping Documents (DMDs), transformation logic, and migration strategiesPartner with engineering and architecture teams on APIs, ETL processes, system interoperability, and enterprise integrationsPerform hands-on data analysis, reconciliation, validation, and data quality assessmentsEnsure consistency, scalability, and standardization across enterprise data ecosystemsEnsure compliance with enterprise governance, security, and architectural frameworksIdentify and mitigate risks related to data integrity, data loss, system cutovers, and modernization activitiesSupport migration testing strategies including validation, reconciliation, rollback planning, and post-migration verificationTranslate business and modernization objectives into product requirements, technical specifications, and implementation roadmapsCollaborate with cross-functional stakeholders to support long-term legacy system decommissioning initiativesRequired Skills & Experience:5–10+ years of experience in Product Management, Data Modernization, Data Architecture, Data Engineering, or related technical leadership rolesStrong expertise in enterprise data modernization and complex legacy system transformation initiativesHands-on experience with data analytics, data engineering, and enterprise data architectureStrong understanding of enterprise integration patterns, API-based integrations, ETL processes, and enterprise data flowsExperience designing or supporting enterprise-scale data pipelines and modernization frameworksStrong expertise in data modeling, data mapping, data profiling, reconciliation, and data quality managementAdvanced SQL skills for data analysis, validation, troubleshooting, and reconciliationProven experience handling siloed, inconsistent, or incomplete legacy data environmentsStrong understanding of data governance, security frameworks, data integrity, lineage, and historical data preservationExperience supporting legacy system decommissioning, transition planning, and modernization roadmapsExcellent analytical, communication, stakeholder management, and problem-solving skillsAbility to work cross-functionally with architecture, engineering, security, and business teamsPreferred Qualifications:Experience within Workers' Compensation or Property & Casualty (P&C) insurance environmentsExposure to enterprise-scale digital transformation or modernization programsExperience working in regulated enterprise environments with governance and compliance requirementsFamiliarity with enterprise security and architectural governance standards