Data Migration Analyst

Job description

**Role Summary** Own the data migration workstream for Vault CRM engagements. Define migration approach, build ETL pipelines, execute mock runs and cutover, and ensure data quality and reconciliation across source Veeva CRM (Salesforce) and target Vault CRM. **Role & responsibilities** • Define migration strategy: scope, approach, tooling, environments, mock runs, cutover plan - Perform data profiling and quality assessment on source Veeva CRM and other legacy systems - Build extraction, transformation, and load routines using Vault Loader, Vault APIs, and ETL tools (Informatica, Talend, Python) - Design and apply data cleansing, de-duplication, and standardization rules - Map source-to-target at the object and field level (accounts, HCPs, call data, territories, activities, content, cycle plans) - Execute mock migrations; coordinate with client data stewards and business for validation - Lead cutover: final extracts, loads, reconciliation, sign-offs - Document migration artifacts: source-to-target mapping, transformation rules, reconciliation reports **Preferred candidate profile** • Proven experience migrating data into Veeva CRM or Vault CRM from legacy systems - Hands-on with Vault Loader and Vault Bulk API for high-volume data loads - Hands-on with Salesforce Data Loader or dataloader.io for legacy Veeva CRM extractions - Strong SQL skills; experience with ETL tools (Informatica, Talend) or scripting (Python) - Ability to manage reconciliation across millions of records with strong attention to detail - Experience in GxP / validated data migration is strongly preferred