State of Arizona · 8 hours ago
DATA QUALITY ASSURANCE ANALYST
Phoenix, AZ
Full-time
Hybrid
Entry, Mid Level
$78K/yr - $82K/yr
2+ years expThe State of Arizona's Department of Education is committed to raising academic outcomes and empowering parents. The Data Quality Assurance Analyst works with various stakeholders to analyze and test data and reporting solutions, ensuring that programs function according to user requirements and established guidelines.
GamingGovernmentVideo Games
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
Qualification
Required
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
Knowledge in Quality Assurance and testing tools/processes
Knowledge in Database and reporting development (analysis, design, coding, testing, issue resolution, planning)
Knowledge in ETL workflow and data pipeline testing
Knowledge in Data validation, profiling, modeling, cleansing
Knowledge in Quality Assurance methodologies
Knowledge in 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
Knowledge in 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
Skills in Customer service
Skills in Excellent interpersonal, written and oral communication
Skills in Data quality assurance
Skills in Design end-to-end test cases for ETL and reporting workflows
Skills in Define validation criteria for business rules and data quality checks
Skills in Write SQL queries for data reconciliation and validation (joins, window functions and aggregations)
Skills in 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
Ability to Contribute to test data management strategies for efficiency and consistency
Ability to Identify systematic data issues, recurring defects, and trends, work proactively on prevention through upstream controls, mapping corrections, and validation of automation
Ability to Work collaboratively within teams and across organizational groups to foster strong communication and alignment
Ability to Ensure any code defects or issues are properly documented, escalated, and monitored
Ability to Work closely with development to support testing needs of assigned team
Ability to Balance and organize multiple project tasks and handle changing assignments and priorities
Ability to Learn new systems, technologies, tools, and work processes
Ability to Write queries to examine, analyze, and validate data
Ability to Verify BI/reporting outputs against source data for accuracy and consistency
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
Company
State of Arizona
As public servants, we deeply care about Arizona and are committed to facing the issues of our state head-on.
10001+ employees
H1B Sponsorship
State of Arizona has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (3)
2022 (1)
2021 (2)
2020 (6)
Funding
Current Stage
Late StageLeadership Team
Aletha Della Rocco
Human Resources Business Partner, Talent Acquisition
George McNeely MBA
Chief Human Resources Officer - Arizona Department of Administration - Shared Services
Recent News
Phoenix Business Journal
2025-01-11
The Arizona Republic
2024-01-27
Company data provided by crunchbase