Senior Data Analyst

Job Description

Job Description

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.