Senior Business Intelligence and Analytics Architect (10+ years) to design KPI frameworks and analytics solutions using PowerBI, BusinessObjects, and Kimball Dimensional Modelling (561). Our public sector client is seeking a

Senior Business Intelligence and Analytics Architect (10+ years) to design KPI frameworks and analytics solutions using PowerBI, BusinessObjects, and Kimball Dimensional Modelling (561).

Join a Smart Cities and Emerging Technologies team focused on evaluating and scaling cutting-edge technologies within a public service environment. This role supports analytics, reporting, and measurement initiatives that help demonstrate program outcomes, organizational readiness, and service impact through dashboards, reporting, and benefits-realization analysis. The team operates at the intersection of technology, experimentation, and strategy, supporting modernization initiatives through evidence-based decision making.

Must Haves

5+ years in a

Business Intelligence and analytics analyst role using

PowerBI or BusinessObjects

5+ years with

Kimball Dimensional Modelling , data analysis, and requirements gathering

5+ years applying

Data Warehousing , Business Intelligence, Analytics, and Data Integration principles

5+ years with

Informatica , semantic layer design, database structures, scripting, Oracle, and SQLServer

3+ years mentoring technical and functional resources on

BI&A; solutions

Nice to Have

Previous experience within the public sector or large organizations

Verbal and written communication skills supporting internal and external stakeholders at multiple levels





Responsibilities

Design KPI frameworks to measure outcomes, impact, learning, and organizational readiness

Create automated measurement processes for program analytics and reporting

Develop performance dashboards and executive reports

Produce benefits-realization analyses and annual outcome reporting

Gather and document requirements including source-to-target mappings for development teams

Analyze program data to communicate performance, outcomes, and value

Support evaluation and understanding of emerging technologies through analytics and reporting

Contract, Calgary, Working Hours: MST

Our public sector client is seeking a

Senior Business Intelligence and Analytics Architect (10+ years) to design KPI frameworks and analytics solutions using PowerBI, BusinessObjects, and Kimball Dimensional Modelling (561).

Join a Smart Cities and Emerging Technologies team focused on evaluating and scaling innovative technologies within a public service environment. This role supports analytics, reporting, and measurement initiatives that help demonstrate program outcomes, organizational readiness, and service impact through dashboards, reporting, and benefits-realization analysis.



The team operates at the intersection of technology, experimentation, and strategy, supporting modernization initiatives through evidence-based decision making.

Must Haves

5+ years in a

Business Intelligence and analytics analyst role using

PowerBI or BusinessObjects

5+ years with

Kimball Dimensional Modelling , data analysis, and requirements gathering

5+ years applying

Data Warehousing , Business Intelligence, Analytics, and Data Integration principles

5+ years with

Informatica , semantic layer design, database structures, scripting, Oracle, and SQLServer

3+ years mentoring technical and functional resources on

BI&A; solutions

Nice to Have

Previous experience within the public sector or large organizations

Verbal and written communication skills supporting internal and external stakeholders at multiple levels

Responsibilities

Design KPI frameworks to measure outcomes, impact, learning, and organizational readiness

Create automated measurement processes for program analytics and reporting

Develop performance dashboards and executive reports

Produce benefits-realization analyses and annual outcome reporting

Gather and document requirements including source-to-target mappings for development teams

Analyze program data to communicate performance, outcomes, and value

Support evaluation and understanding of emerging technologies through analytics and reporting

Disclaimer

AI may be used in evaluating candidates.

This posting is for an existing vacancy.

📌 Senior Business Intelligence and Analytics Architect (10+ years) to design KPI frameworks and analyt (Calgary)
🏢 S.i. Systems
📍 Calgary