SENIOR BUSINESS INTELLIGENCE & DATA ARCHITECT

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

• 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 (see Arizona Administrative Code R2-10-207.12.)

• Requires possession of and ability to retain a current, valid state-issued driver’s license appropriate to the assignment

If this position requires driving or the use of a vehicle as an essential function of the job to conduct State business, then the following requirements apply: Driver’s License Requirements.

Benefits:

The State of Arizona offers a comprehensive benefits package to include:

• 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

Learn more about the Paid Parental Leave program here. For a complete list of benefits provided by The State of Arizona , please visit our benefits page

Retirement:

• Positions in this classification participate in the Arizona State Retirement System (ASRS)

• Note that enrollment eligibility will become effective after 27 weeks of employment

Contact Us:

• If you have any questions please feel free to contact Ariel Gonzalez at for assistance

Originally posted on Himalayas

• Data Architect
• Business Intelligence Architect
• Business Intelligence Developer
• Data Engineer

Source: Himalayas