Address: Information TechnologyDivision
Phoenix AZ 85007

Salary: $78000 - $82500

Grade: 23

Closing Date: 01/28/26

The Data Quality Assurance Analyst works with Product Owners Project Managers Business Analysts and Data Developers to analyze and runs tests on new or modified data and reporting solutions including documentation diagram and flowchart and software development procedures used to verify that programs function according to user requirements and conform to establish guidelines.
Occasional in-state travel is required for this position.

The Arizona Department of Education currently utilizes a hybrid work environment with up to two days of remote work (contingent upon business needs). Candidates should apply with an ability and willingness to work in-office up to five days per week as business needs necessitate.

Requirements Analysis & Test Planning:
- Review business requirements acceptance criteria design specifications and data mapping documents to ensure clarity of deliverables across databases ETL and reporting.
- Define scope develop test strategies and create detailed test plans for data validation transformation logic and data migration following QA standards.
Test Design Query Development & Execution:
- Design end-to-end test cases for databases ETL and reporting workflows; define validation criteria for business rules mappings and data quality checks.
- Write SQL queries (joins aggregations) to reconcile source vs. target data and validate accuracy integrity and completeness.
- Execute test cases and perform regression testing after changes or enhancements.
Defect Management & Collaboration:
- Report bugs/issues with clear reproduction steps data samples and expected vs. actual results.
- Collaborate with Developers Data Engineers and Business Analysts to resolve defects production issues and performance bottlenecks. Support UAT by providing release notes and assisting during testing.
Automation & Continuous Improvement:
- Identify repetitive validations for automation and collaborate on building reusable validation scripts.
- Contribute to process improvements and ensure adherence to organizational Quality Assurance best practices.
Other duties as assigned as related to the position.

Knowledge in:
Quality Assurance and testing tools/processes
Database and reporting development (analysis design coding testing issue resolution planning)
ETL workflow and data pipeline testing
Data validation profiling modeling cleansing
Quality Assurance methodologies
BI tools (Power BI SSRS)
Thorough understanding of industry standard software Quality Assurance testing methods (exploratory scenario-based risk-based data-centric etc.)
Knowledge and understanding of data systems development to assess testing needs and recommend appropriate strategies for testing
Ensure tests are executed and analyzed properly
Test automation practices and tools such as Selenium power apps
Experience with SQL Server databases and T-SQL database query language
Experience in Microsoft Test Manager (MTM) or Azure DevOps Test Plans
Experience in Team Foundation Server (TFS) or Azure DevOps
Experience working in Agile SCRUM methodology
Experience in Team Foundation Server (TFS) or Azure DevOps
Experience working in Agile SCRUM methodology
A Bachelors Degree plus two to five years experience in quality assurance testing and analysis or equivalent experience to substitute for the degree is required

Skills in:
Customer service
Excellent interpersonal written and oral communication
Data quality assurance
Design end-to-end test cases for ETL and reporting workflows
Define validation criteria for business rules and data quality checks
Write SQL queries for data reconciliation and validation (joins window functions and aggregations)
Perform detailed data comparisons and identifyanomalies using profiling metrics
Strong problem-solving troubleshooting and root cause analysis skills
Intermediate skill in using Microsoft Outlook Word and Excel

Ability to:
Create and maintain reusable test suites SQL query libraries and data quality checklists
Contribute to test data management strategies for efficiency and consistency
Identify systematic data issues recurring defects and trends work proactively on prevention through upstream controls mapping corrections and validation of automation
Work collaboratively within teams and across organizational groups to fosterstrong communication and alignment
Ensure any code defects or issues are properly documented escalated and monitored
Work closely with development to support testing needs of assigned team
Balance and organize multiple project tasks and handle changing assignments and priorities
Work collaboratively within teams and across organizational groups
Learn new systems technologies tools and work processes
Write queries to examine analyze and validate data
Verify BI/reporting outputs against source data for accuracy and consistency

N/A

Offers are contingent upon successful completion of all background and reference checks required documents and if applicable a post-offer medical/physical evaluation.

If this position requires driving or the use of a vehicle as an essential function of the job to conduct State business then the following requirements apply:Drivers License Requirements.

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

The State of Arizona provides an excellent comprehensive benefits package including:

Affordable medical dental life and short-term disability insurance plans
Top-ranked retirement and long-term disability plans
Ten paid holidays per year
Vacation time accrued at 4.00 hours bi-weekly for the first 3 years
Sick time accrued at 3.70 hours bi-weekly
Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
Deferred compensation plan
Wellness plans

Learn more about the Paid Parental Leave pilot programhere. For a complete list of benefits provided by The State of Arizona please visit our benefits page

You will be required to participate in the Arizona State Retirement System (ASRS) upon your 27th week of employment subject to waiting period. On or shortly after your first day of employment you will be provided with enrollment instructions and effective date.

The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer. Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by calling or emailing Requests should be made as early as possible to allow sufficient time to arrange the accommodation.