Senior Data Migration Validation Analyst

About the role

We are seeking a Data Migration Analyst to oversee end-to-end data reconciliation and quality assurance for a system transformation. In this role, you will bridge the gap between legacy infrastructure and modern cloud architecture, ensuring data integrity, relational mapping, and zero record loss as data moves through staging environments into Salesforce Service Cloud.

Responsibilities

• Execute end-to-end data reconciliation across each stage of the migration pipeline to verify record counts, hash totals, and summary figures across legacy staging and cloud target environments.
• Author and execute SQL validation scripts (utilizing window functions, CTEs, and advanced joins) to audit Source-to-Target Mapping (STTM) rules, transformation logic, and field constraints.
• Validate Salesforce target environments using SOQL, Data Loader, and API workbench tools to verify relational schema integrity, parent-child object mappings, and external IDs.
• Triage, document, and track data defects (such as character encoding errors, orphaned records, and constraint violations) in close collaboration with ETL developers and platform engineers.
• Build automated validation workflows using Python, data profiling scripts, or advanced analytical tools to conduct row-by-row cross-system file comparisons.

Requirements

• 5+ years of hands-on experience with SQL Server query writing, schema verification, and database auditing.
• Proven experience validating Salesforce Service Cloud environments, including familiarity with SOQL, object schemas, and data loader utilities.
• Demonstrated track record in data conversion testing, end-to-end reconciliation, and ETL/migration validation.
• Familiarity with legacy data structures, including fixed-width flat files or legacy mainframe extraction validation.
• Experience with Python scripting, automation tools, or AI-assisted data tools for automated file comparisons (Preferred).