DATA QUALITY ASSURANCE ANALYST

Arizona Department of Administration • Phoenix, AZ

1d • $78,000 - $82,500 • Hybrid

About The Position

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, diagrams, and flowcharts, 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

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

Responsibilities

• 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.
• Other duties as assigned as related to the position.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level