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

S I Systems; Calgary; On-site; CAD 120,000 - 160,000; Full time

Job summary

S I Systems in Calgary seeks a Senior Business Intelligence and Analytics Architect with 10+ years of experience to design KPI frameworks and analytics solutions using PowerBI, BusinessObjects, and Kimball Dimensional Modelling. This role focuses on dashboards, reporting, and measurement initiatives within a public service context.

You will join a Smart Cities and Emerging Technologies team, mentor staff, create automated analytics processes, and produce benefits-realization analyses to

Qualifications

• 5+ years in a BI and analytics role using PowerBI or BusinessObjects.
• 5+ years with Kimball Dimensional Modelling, data analysis, and requirements gathering.
• 5+ years applying Data Warehousing, BI, 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.

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.

Skills

PowerBI

BusinessObjects

Kimball Dimensional Modelling

Data Warehousing

Data Integration

Informatica

SQLServer

Semantic layer design

Mentoring

Tools

Informatica

Oracle

SQLServer

PowerBI

Job description

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

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.