- S R INTERNATIONAL INC
- Phoenix, AZ
- Full-Time
- 71 days ago
Senior Data Analyst.
Before you go
Before you leave us, sign up for our email alerts
We don't do job spam, just the best digital jobs delivered straight to your inbox.
Senior Data Analyst: our view in 3 lines...
- The Role:This role supports a large-scale data migration initiative for the State of Arizona, validating data movement between legacy Mainframe systems, SQL Server staging databases, and Salesforce Service Cloud.
- The Person:The person will validate migrated data end to end, reconcile records and financial totals, review STTM documentation, write SQL validation scripts, and work with ETL and Salesforce teams to resolve defects.
- Requirements:The ideal candidate has a bachelor's degree and 5+ years of experience with SQL Server, Salesforce Service Cloud, data conversion testing and validation, advanced SQL, SOQL, Data Loader, and Workbench.
About the role
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
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.