- 541406
- PHOENIX
- DEPT OF EDUCATION
- Full-time
- Closing at: Aug 6 2026 - 23:55 MST
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: 08/06/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.
Job Duties:
- 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.
- 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.
- 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.
- 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.
Knowledge, Skills & Abilities (KSAs):
- 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.)