Job Title: Senior Data Analyst (Migration Validation)
Job Code: AZ 13094 Client: State of Arizona – AZDES (Department of Economic Security) Location: Phoenix, AZ (Hybrid – Local Candidates Only) Duration: 6+ Months Work Location: Hybrid (Onsite once a week or as needed) Office Address: 1400 W. Washington St., Phoenix, AZ 85007
Work Hours: Monday – Friday | 9:00 AM – 5:00 PM (40 Hours/Week)
Closing Date: August 5, 2026 @ 4:00 PM
Position Overview
The State of Arizona is seeking a Senior Data Migration Validation Analyst to support a large-scale data migration initiative involving legacy Mainframe systems, SQL Server staging databases, and Salesforce Service Cloud. The selected candidate will validate end-to-end data migration, perform reconciliation, ensure data integrity, and verify source-to-target mappings while collaborating with ETL and Salesforce development teams.
Required Skills
Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field
5+ years of experience with SQL Server
5+ years of experience with Salesforce Service Cloud
5+ years of experience in Data Conversion Testing & Validation
Advanced SQL (Joins, CTEs, Window Functions, Data Profiling)
Salesforce Data Architecture, SOQL, Data Loader, Workbench
Data reconciliation and migration validation
Data mapping and Source-to-Target Mapping (STTM) validation
Financial and statistical reconciliation
Defect tracking and data quality analysis
Preferred Skills
AI experience
Legacy Mainframe data migration
Python (Pandas)
Scripting & Automation
Power Query / Advanced Excel
EBCDIC to ASCII conversion
Fixed-width file parsing
Key Responsibilities
Validate data throughout the migration pipeline (Mainframe → SQL Server → Salesforce).
Perform record count, hash total, and financial reconciliation across environments.
Review and validate Source-to-Target Mapping (STTM) documentation.
Develop complex SQL scripts to validate data transformation logic.
Validate Salesforce data using SOQL, Data Loader, and Workbench.
Verify relational integrity, object relationships, and external IDs.
Identify, document, and resolve data migration defects.
Work closely with ETL and Salesforce development teams to resolve data issues.
Automate validation and reconciliation processes using Python or Power Query where applicable.
Important Notes
Local Phoenix, AZ candidates only.
Resume must clearly indicate current Phoenix-area location.
Hybrid schedule (onsite once per week or as needed).
Candidate must be available for an in-person interview within one week of the posting close date.
Candidate must be able to start within two weeks of receiving an offer.
HireRight background check and drug screening required.
Primary Skills
SQL Server, Salesforce Service Cloud, Data Migration, Data Conversion Testing, Data Validation, Data Reconciliation, SQL, SOQL, Data Loader, Workbench, ETL, Data Mapping, Source-to-Target Mapping (STTM), Data Profiling, Python, Pandas, Power Query, Excel, Legacy Mainframe, EBCDIC, ASCII, Data Integrity, Scripting, Automation, Salesforce CRM, Data Quality, AI.