Senior Data Analyst
S R INTERNATIONAL INC · Phoenix, Arizona, United States
IT Services and IT Consulting · 11-50 employees
About the role
The analyst will validate end-to-end data migration from legacy Mainframe systems to SQL Server and Salesforce Service Cloud. They are responsible for performing financial and statistical reconciliation, verifying source-to-target mappings, and automating validation processes.
What they look for
Requirements
Candidates must hold a bachelor's degree and possess at least 5 years of experience in SQL Server, Salesforce Service Cloud, and data conversion testing. Proficiency in advanced SQL, data architecture, and defect tracking is required for this role.
Full 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.
