DATA QUALITY ASSURANCE ANALYST

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. 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, 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 foster strong 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 Selective Preference(s): N/A Pre-Employment Requirements: 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: Driver’s License Requirements. All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify). Benefits: 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 program here . For a complete list of benefits provided by The State of Arizona, please visit our benefits page Retirement : 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. Contact Us: 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 (602) 542-3186 or emailing [email protected]. Requests should be made as early as possible to allow sufficient time to arrange the accommodation.