[Hiring] Senior Business Intelligence & Data Architect @Arizona Department of Administration

Role Description

The State seeks a Senior Business Intelligence & Data Architect to serve as the authoritative technical expert for the State’s enterprise grants business intelligence (BI) ecosystem. Operating at the intersection of state grant policy, cloud database engineering, and interactive analytics, this role manages the end-to-end data architecture and reporting strategy for the statewide grants management SaaS platform.

• Integrate data across Arizona's Grants Management System (AzGMS), the state accounting system (AZ360), legacy databases, and federal exports to build automated reporting pipelines.
• Work collaboratively with the Technical Integration team, SaaS vendor, ERP/AZ360 team, Security, and Agency Leads to empower state agencies with custom reporting and executive compliance dashboards.
• Lead the data mapping and migration strategy and author technical Standard Operating Procedures (SOPs) to ensure long-term state self-sufficiency, data integrity, statewide audit readiness, and informed decision-making.

Qualifications

• Technology Stack:
• SQL Scripting (Stored Procedures, Indexes, Complex Joins)
• Relational Data Warehousing & SQL Schema Design
• SQL Server Dimensional Modeling (Star Schema)
• Azure SQL Database & Microsoft
• ETL / ELT Pipeline Architecture
• Power BI (DAX, Power Query)
• JSON / REST API Parsing
• Azure Data Factory (ADF)
• Azure Data Lake Storage
• Azure Key Vault
• Microsoft Fabric
• Strong analytical problem-solving skills for complex financial reconciliations, combined with the ability to translate technical data structures into clear executive visuals and user-friendly documentation.
• Direct experience working with state/federal grant data and administration, SEFA reporting, or subrecipient compliance monitoring. Knowledge of full-lifecycle grant financial flows.
• Certifications: Microsoft Certified - Power BI Data Analyst Associate, Azure Data Engineer Associate, or Enterprise Data Analyst Associate.
• Experience supporting SaaS grants management platforms and integrating with ERP systems.

Requirements

• A Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, Business Intelligence, or a related field with 9+ years of progressive hands-on experience developing enterprise data architecture, Power BI dashboards and semantic models, and ETL/ELT pipelines.
• Employees who drive on state business are subject to driver’s license record checks, must maintain acceptable driving records and must complete any required driver training.
• Requires possession of and ability to retain a current, valid state-issued driver’s license appropriate to the assignment.

Benefits

• Optional employee benefits include short-term disability insurance, deferred compensation plans, and supplemental life insurance.
• Life insurance and long-term disability insurance.
• Vacation plus 10 paid holidays per year.
• Health and dental insurance.
• Retirement plan.
• Sick leave.