SA
SENIOR BUSINESS INTELLIGENCE & DATA ARCHITECT
Contract type
Ongoing
Work mode
Remote
Experience
Senior · 9+ years
Job description
The Senior Business Intelligence & Data Architect serves as the authoritative technical expert for the State's enterprise grants business intelligence ecosystem, managing end-to-end data architecture and reporting strategy for the statewide grants management SaaS platform. The role integrates data across AzGMS, AZ360, legacy databases, and federal exports to build automated reporting pipelines and executive compliance dashboards.
At a glance
- Employment
- Full-time · Employee (employment agreement)
- Work mode
- Remote
- Pay
- USD 96,000 – 109,000 / year
- Apply before
- November 6, 2026
What you'll do
- 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
- 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)
What we're looking for
- 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
- 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
- Requires possession of and ability to retain a current, valid state-issued driver's license appropriate to the assignment
Your team
Governor's Office of Strategic Planning & Budgeting - Grants & Federal Resources
Benefits
Optional employee benefits include short-term disability insurance, deferred compensation plans, and supplemental life insurance
Positions in this classification participate in the Arizona State Retirement System (ASRS); enrollment eligibility will become effective after 27 weeks of employment
- Life insurance and long-term disability insurance
- Vacation plus 10 paid holidays per year
- Health and dental insurance
- Retirement plan
- Sick leave
- Paid Parental Leave program
Apply
About State of Arizona
Arizona Governor's Office, Governor's Office of Strategic Planning & Budgeting, Grants & Federal Resources.
Key facts
- Phoenix, Arizona
- Position is currently grant funded
- Participates in the Arizona State Retirement System (ASRS)