SENIOR BUSINESS INTELLIGENCE & DATA ARCHITECT
Ali Aydi
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Benefits offered by this job
Job summary
Governor’s Office of Strategic Planning & Budgeting, Grants & Federal Resources seeks a Senior Business Intelligence & Data Architect to be the authoritative technical expert for the State’s enterprise grants BI ecosystem, spanning policy, cloud data engineering, and analytics.
The Architect will integrate data across AzGMS, AZ360, legacy systems, and federal exports to build automated reporting pipelines and executive dashboards, while authoring SOPs and leading data mapping, migration, and
Qualifications
- Proficiency in SQL scripting and data warehousing design.
- Experience with relational data models and star schemas.
- Strong skills in Power BI for executive dashboards.
Responsibilities
- Manage Azure data services and security tooling.
- Design and publish executive dashboards across state agencies.
- Develop SOPs and runbooks for reporting pipelines and ETL/ELT processes.
- Lead data mapping, migration strategies, and data quality initiatives.
- Ensure audit readiness and compliance through governance artifacts.
Skills
Education
Tools
Job description
Job Location:
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:
- 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)
SQL Scripting (Stored Procedures, Indexes, Complex Joins)
Relational Data Warehousing & SQL Schema Design
SQL ServerDimensional Modeling (Star Schema)
- 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):
- 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.
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
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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
