Senior Data Migration Validation Analyst

SunSoft Online
Phoenix, AZ
Category Data Analyst
Job Description
Role Overview

Own data integrity on a high-stakes legacy-to-cloud migration, validating data at every hop (mainframe → SQL → Salesforce) and guaranteeing 100% data integrity.

What You Will Do

Validate data at every migration hop, review Source-to-Target Mapping (STTM) documents, write complex SQL to verify transformation logic, and validate Salesforce relational integrity post-load.

Why It Might Be a Fit

This role stands out for its senior-level ownership of validation strategy on a complex, visible migration, with a genuine hybrid work arrangement and a competitive hourly rate of $60-65/hr W2.

Requirements

  • Bachelor's degree (CS, IS, Business, or related)
  • 5+ years with SQL Server, Salesforce Service Cloud, and data conversion testing/validation
  • advanced SQL (complex joins, CTEs, window functions, profiling)
  • Salesforce data architecture and SOQL fluency
  • legacy data literacy (fixed-width flat files, EBCDIC-to-ASCII validation)
  • Python/Pandas or advanced Excel/Power Query for automated cross-system comparison
  • AI experience a plus

Benefits

  • Competitive hourly rate of $60-65/hr W2
  • Hybrid work arrangement (in-person about once a week in central Phoenix)
  • Senior-level ownership of validation strategy on a complex, visible migration
]]>