Senior Business Intelligence & Data Architect

Responsibilities

• 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

Languages