State of Arizona

SENIOR BUSINESS INTELLIGENCE & DATA ARCHITECT

Full-timeSeniorWorldwideaziOther

Salariu estimat

$96,000 - $109,000

Aplică la angajator →

Te trimitem direct pe site-ul angajatorului. Gratuit, fără cont.Scanează-ți CV-ul gratuit cu Yago CV Lab

Rol remote international cu aplicare directa si echipa distribuita

Despre rol

ARIZONA GOVERNOR'S OFFICE

*GOVERNOR’S OFFICE OF STRATEGIC PLANNING & BUDGETING

GRANTS & FEDERAL RESOURCES*

SENIOR BUSINESS INTELLIGENCE & DATA ARCHITECT

**This position is currently grant funded with a salary range of $96,000-$109,000, dependent on experience.

A wide salary range is posted for this position and any job offer is based upon a salary analysis which considers relevant experience, education, certifications, and state seniority as compared to others doing substantially similar work. There is no guarantee an offer will be at the top of the posted range based on the salary analysis.Job Location:**

1700 West Washington Street

Phoenix, Arizona 85007

Posting Details:

Annual Salary Range: $96,000 - $109,000

This position will close on Friday November 6, 2026

Job Summary:

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.

The Architect will integrate data across Arizona's Grants Management System (AzGMS), the state accounting system (AZ360), legacy databases, and federal exports to build automated reporting pipelines. Working collaboratively with the Technical Integration team, SaaS vendor, ERP/AZ360 team, Security, and Agency Leads, this role empowers state agencies with custom reporting and executive compliance dashboards.

Additionally, the Architect leads the data mapping and migration strategy and authors technical Standard Operating Procedures (SOPs) to ensure long-term state self-sufficiency, data integrity, statewide audit readiness and informed decision-making.

Job Duties:

Key job responsibilities will include:

Manage Azure Data Factory (ADF) 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 executive, multi-page, interactive Power BI dashboards providing OSPB leadership with organization-wide visibility across all state agencies

Agency Grant Profile & Compliance Dashboards: Develop and manage detailed Agency Grant Profile dashboards capturing agency self-assessments, internal risk scores, active corrective action plans, and real-time compliance monitoring flags

Author comprehensive Standard Operating Procedures (SOPs) and technical runbooks detailing report maintenance, dashboard configuration, and ETL pipeline management

Establish statewide metrics tracking federal grant seeking, application pipelines, award obligations, revenue/expenditure drawdowns, and program performance measures

Lead the technical review and validation of Data Management and Migration Strategies, Data Inventory & Quality Assessments, and Data Mapping Workbooks

Ensure rigorous financial reconciliation, data mapping, cleansing, and duplicate management during agency data onboarding from legacy systems

Incorporate interactive 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 in coordination with State Legal and Compliance teams

Work with the vendor support team to provide technical support to agency data leads on 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 effectively 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 (e.g., SEFA, FFATA, GFR)

Knowledge, Skills & Abilities (KSAs):

Knowledge, Skills, and Abilities:

• Technology Stack

SQL Scripting (Stored Procedures, Indexes, Complex Joins)

Relational Data Warehousing & SQL Schema Design

SQL ServerDimensional 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

Public Sector & Grants Domain: 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

System Familiarity: Experience supporting SaaS grants management platforms and integrating with ERP systems

Selective Preference(s):

Education

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

**Pre-Employment Requirements:

Listat via Himalayas

CV-ul tău trece de ATS-ul lor?94% din cursanți primesc interviuri în 2 săptămâni.

Kit AI · €24 →

Challenge nou

Aplici și nu primești niciun răspuns?

Challenge-ul de 5 Zile îți arată exact ce te oprește — CV, LinkedIn, scrisoare de intenție și interviu, cu scoruri reale, nu păreri.

Vezi Challenge-ul de 5 Zile →