Role: Senior Product Manager/Business Analyst – Data Migration & Legacy Systems
Location: Pleasanton, CA (Hybrid)
Duration: 6+ months
Pay Rate: $85 to $90
Overview: We are seeking a Senior Product Manager/Business Analyst to lead legacy system transformation and data migration initiatives. This is a technical, data-focused role requiring someone who can work hands-on with complex, inconsistent (“messy”) legacy data and ensure accurate migration into modern systems without breaking integrations or losing historical integrity.
Key Responsibilities:
- Own and drive data migration and legacy system retirement initiatives
- Analyze, cleanse, and map legacy data structures to modern platforms
- Develop and maintain Data Mapping Documents (DMDs) and transformation logic
- Perform data modeling, data analysis, and data cleanup activities
- Write and validate SQL queries for data validation and reconciliation
- Collaborate with engineering teams on API integrations and data flows
- Identify and mitigate risks related to data loss, latency, and system cutover
- Execute parallel testing, rollback strategies, and migration validation
- Translate business needs into clear product requirements and technical specifications
Required Skills & Experience:
- 5–10 years of experience as a Product Manager / Business Analyst
- Strong experience in data conversion, migration, and legacy system modernization
- Hands-on expertise with data modeling, data cleanup, and data mapping
- Working knowledge of SQL queries and API integrations
- Proven experience handling dirty/incomplete data and resolving data gaps
- Strong understanding of data integrity, reconciliation, and historical data preservation
- Experience in legacy system decommissioning and transition planning
- Excellent analytical, problem-solving, and communication skills
Preferred Qualifications:
- Experience in insurance or financial systems
- Exposure to enterprise-scale transformation or modernization programs
