Data Quality Assurance Analyst

Department of Education Data Quality Assurance Analyst Job Location

Address:
Information Technology Division, Phoenix, AZ 85007

Salary: $78,000 - $82,500
Grade: 23
Closing Date: 03/15/26

The Data Quality Assurance Analyst works with Product Owners, Project Managers, Business Analysts, and Data Developers to analyze and run 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 established 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 related to the position.

• Knowledge:
  Quality Assurance and testing tools/processes; database and reporting development; ETL workflow and data pipeline testing; data validation, profiling, modeling, cleansing; QA methodologies; BI tools (Power BI, SSRS); industry standard software Quality Assurance testing methods; data systems development assessment; test automation practices and tools; SQL Server databases and T-SQL;
  Microsoft Test Manager (MTM) or Azure Dev Ops Test Plans;
  Team Foundation Server (TFS) or Azure Dev Ops;
  Agile SCRUM methodology;
  Bachelor’s Degree plus 2-5 years experience in QA testing and analysis or equivalent.
• Skills:
  
  Customer service; excellent interpersonal, written and oral communication; data quality assurance; design end-to-end test cases; define validation criteria; write SQL queries; perform detailed data comparisons; strong problem‑solving skills; intermediate proficiency with Microsoft Outlook, Word, Excel.
• Abilities:
  Create and maintain reusable test suites; contribute to test data management strategies; identify systematic data issues and trends; work collaboratively within teams across organizational groups; document, schedule, and monitor code defects; support development testing needs; balance and organize multiple project tasks; learn new systems, technologies, tools; write queries; verify BI/reporting outputs against source data.

N/A

Offers are contingent upon successful completion of all background and reference checks and required documentation. All newly hired State employees must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify). This position may require driving; if so, a valid driver’s license is required.

• Affordable medical, dental, life,…