SENIOR BUSINESS INTELLIGENCE & DATA ARCHITECT

Arizona Department of Administration • Phoenix, AZ

1d • $96,000 - $109,000 • Onsite

About The Position

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

The Architect integrates data from Arizona’s Grants Management System (AzGMS), the state accounting system (AZ360), legacy databases, and federal exports to create automated reporting pipelines. The role works with the Technical Integration team, SaaS vendor, ERP/AZ360 team, Security, and agency leads to provide agencies with custom reporting and executive compliance dashboards.

The position leads data mapping and migration strategy and creates technical Standard Operating Procedures to support long-term state self-sufficiency, data integrity, statewide audit readiness, and informed decision-making. The position is currently grant funded. It is located at 1700 West Washington Street, Phoenix, Arizona 85007, and the posting closes Friday, November 6, 2026.

Requirements

• At least 9 years of progressive, hands-on experience developing enterprise data architecture, Power BI dashboards and semantic models, and ETL/ELT pipelines.
• Strong SQL scripting skills, including stored procedures, indexes, and complex joins.
• Knowledge of relational data warehousing and SQL schema design.
• Knowledge of SQL Server dimensional modeling, including star schemas.
• Knowledge of Azure SQL Database and Microsoft technologies.
• Knowledge of ETL/ELT pipeline architecture.
• Power BI skills, including DAX and Power Query.
• Knowledge of JSON and REST API parsing.
• Knowledge of Azure Data Factory, Azure Data Lake Storage, Azure Key Vault, and Microsoft Fabric.
• Strong analytical problem-solving skills for complex financial reconciliations, and the ability to translate technical data structures into clear executive visuals and user-friendly documentation.
• Direct experience with state or federal grant data and administration, SEFA reporting, or subrecipient compliance monitoring.
• Knowledge of full-lifecycle grant financial flows.
• Experience supporting SaaS grants management platforms and integrating them with ERP systems.
• Possession of a current, valid state-issued driver’s license appropriate to the assignment and ability to retain it.
• Employees who drive on state business must maintain an acceptable driving record and complete required driver training; driver’s license record checks apply.

Nice To Haves

• A Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, Business Intelligence, or a related field.
• Microsoft Certified Power BI Data Analyst Associate, Azure Data Engineer Associate, or Enterprise Data Analyst Associate certification.

Responsibilities

• Manage Azure Data Factory orchestration, Azure Data Lake Storage Gen2, Azure SQL DB indexing, Azure Key Vault secrets management, and Entra ID Service Principals.
• Design and publish high-level, multi-page, interactive executive Power BI dashboards providing OSPB leadership with organization-wide visibility across state agencies.
• Develop and manage Agency Grant Profile and Compliance Dashboards that capture agency self-assessments, internal risk scores, active corrective action plans, and real-time compliance monitoring flags.
• Author Standard Operating Procedures and technical runbooks for report maintenance, dashboard configuration, and ETL pipeline management.
• Establish statewide metrics for federal grant seeking, application pipelines, award obligations, revenue and expenditure drawdowns, and program performance.
• Lead technical review and validation of Data Management and Migration Strategies, Data Inventory and Quality Assessments, and Data Mapping Workbooks.
• Ensure financial reconciliation, data mapping, cleansing, and duplicate management during agency onboarding from legacy systems.
• Incorporate interactive dashboard features such as global search slicers, split-screen operational views, granular drill-through capabilities, and deadline countdown visuals.
• Support records-retention, legal-hold, archival, and defensible-deletion requirements with State Legal and Compliance teams.
• Work with the vendor support team to provide agency data leads with technical support for custom report creation and complex filter queries.
• Maintain data governance documentation, data dictionaries, data-flow diagrams, data-quality metrics, and reconciliation procedures.
• Ensure backend data structures support statewide reporting, audit requirements, public records, and future analytics.
• Build, publish, and maintain custom tabular, summary, and matrix reports in the native Grants Management Report Builder.
• Develop and maintain automated reporting pipelines for mandatory annual federal filings such as SEFA, FFATA, and GFR.

Benefits

• Optional short-term disability insurance, deferred compensation plans, and supplemental life insurance.
• Life insurance and long-term disability insurance.
• Vacation and 10 paid holidays per year.
• Health and dental insurance.
• Retirement plan through the Arizona State Retirement System (ASRS); enrollment eligibility becomes effective after 27 weeks of employment.
• Sick leave.
• Paid Parental Leave program.

What This Job Offers

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