Department of Education

The Arizona Department of Education is a service organization committed to raising academic outcomes and empowering parents.

Data Quality Assurance Analyst

Job Location:

Address:  Information Technology Division
Phoenix, AZ 85007

Posting Details:

Salary: $78,000 - $82,500 

Grade: 23

Closing Date: 01/28/26

Job Summary:

• 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.

Job Duties:

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, Skills & Abilities (KSAs):

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 Bachelor’s 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 identify anomalies using profiling metrics
• Strong problem-solving, troubleshooting, and root cause analysis skills
• Intermediate skill in using Microsoft Outlook, W