The Common Cluster Solutions (CCS) Branch delivers enterprise Business Intelligence (BI), analytics, and KPI reporting services across ministries and internal business units. This role focuses on designing and delivering high-quality Power BI solutions that enable data-driven decision-making through performance reporting, analytics, and self-service BI tools.

The successful candidate will work on multiple priority initiatives, building scalable data models, dashboards, and reports while collaborating with stakeholders across technical and business domains.

Key Projects / Initiatives
The resource will contribute to the following approved projects:

Compliance Enforcement Reporting – Phase 1 (PSISB)

Compliance Enforcement Reporting – Phase 2 (PSISB)

Animal Welfare Services (AWS) – Operational Reporting

Modernized Use of Force Reporting

eRoster Reporting

Additional ongoing Power BI development initiatives within the branch

Key Responsibilities

Design, develop, and deploy Power BI reports, dashboards, and data models

Extract, transform, and load (ETL) data using Power Query

Analyze stakeholder requirements and translate them into BI solutions.

Ensure alignment with organizational IT standards and processes

Perform data profiling, cleansing, and transformation

Optimize report performance (measures, relationships, visuals)

Support system testing and User Acceptance Testing (UAT)

Collaborate with developers, testers, and program managers

Document solutions, processes, and deliverables

Participate in knowledge transfer sessions with internal teams

Deliver high-quality, user-friendly visualizations for executive and operational audiences

Overview
The Common Cluster Solutions (CCS) Branch delivers enterprise Business Intelligence (BI), analytics, and KPI reporting services across ministries and internal business units. This role focuses on designing and delivering high-quality Power BI solutions that enable data-driven decision-making through performance reporting, analytics, and self-service BI tools.

The successful candidate will work on multiple priority initiatives, building scalable data models, dashboards, and reports while collaborating with stakeholders across technical and business domains.

Key Projects / Initiatives
The resource will contribute to the following approved projects:

Compliance Enforcement Reporting – Phase 1 (PSISB)

Compliance Enforcement Reporting – Phase 2 (PSISB)





Animal Welfare Services (AWS) – Operational Reporting

Modernized Use of Force Reporting

Mental Health Programs Reporting Inventory

eRoster Reporting

Additional ongoing Power BI development initiatives within the branch

Key Responsibilities

Design, develop, and deploy Power BI reports, dashboards, and data models

Extract, transform, and load (ETL) data using Power Query

Analyze stakeholder requirements and translate them into BI solutions.

Ensure alignment with organizational IT standards and processes

Perform data profiling, cleansing, and transformation

Optimize report performance (measures, relationships, visuals)

Support system testing and User Acceptance Testing (UAT)

Collaborate with developers, testers, and program managers

Document solutions, processes, and deliverables

Participate in knowledge transfer sessions with internal teams

Deliver high-quality, user-friendly visualizations for executive and operational audiences

Requirements
Technical Skills & Requirements
Core Requirements

Minimum 5+ years of experience as a Power BI Developer / Report Developer

Strong expertise in:

Power BI (Desktop & Service)

DAX (Data Analysis Expressions)

Power Query (M language)

Experience with:

SQL Server and relational databases

Power BI datasets and data refresh strategies

Data modeling (star schema, snowflake schema)

Data visualization best practices

Experience with:

Microsoft Azure ecosystem

Azure Data Factory

Power Platform

Data & BI Capabilities

Data extraction from multiple sources (Import, DirectQuery, Hybrid)

Data profiling, cleansing, and transformation

Building scalable and maintainable data models

Performance tuning of reports and datasets

Understanding BI methodologies and implementation approaches

Strong knowledge of data analysis and data management

Mandatory Functional Skills

Design intuitive, high-performance Power BI data models

Create compelling, interactive dashboards and reports





Implement report navigation for diverse audiences

Connect reports to various enterprise data sources

Present insights in a clear, structured, and business-friendly manner

Soft Skills & Competencies

Strong stakeholder management and communication skills

Ability to work with both technical and non-technical audiences

Excellent documentation and presentation skills

Strong analytical and problem-solving abilities

Effective time management and prioritization skills

Ability to handle complex and competing business requirements

Cooperative team player with a track record of meeting deadlines

Documentation & Collaboration

Develop detailed technical and functional documentation

Collaborate with cross-functional teams (Developers, QA, PMs)

Create visual artifacts (diagrams, presentations, walkthroughs)

Analyze user feedback and continuously improve BI solutions

Facilitate discussions to align business and technical requirements

Evaluation Criteria
Criteria 1: Technical Skills (60 Points)

Power BI development experience

Expertise in DAX, M, Power Query

Azure and Power Platform knowledge

SQL Server and dataset experience

Data modeling and visualization skills

Performance tuning capabilities

Experience with data connectivity modes (Import, DirectQuery)

BI solution development based on business requirements

Criteria 2: Communication & Collaboration (40 Points)

Documentation quality and clarity

Stakeholder engagement and facilitation

Cross-team collaboration experience

Problem-solving and analytical thinking

Ability to simplify complex business problems

Communication, presentation, and interpersonal skills

Deliverables

Power BI reports and dashboards

Data models and datasets

Documentation and process artifacts

Source code and PBIX files

Knowledge transfer materials

Knowledge Transfer Requirements

Complete documentation of deliverables

Data models and Power BI files (PBIX)

Source code and development artifacts

Overview of development processes

Knowledge Transfer Methods

1:1 sessions

Team meetings

Ongoing collaboration throughout the project lifecycle

Additional Requirements

Must pass OPS Contractor Security Clearance

Security requirements may change during the contract.

Ability to work in a dynamic, fast-paced environment

Onsite requirement: 5 days/week

#J-18808-Ljbffr

📌 Senior Report Developer (Ontario)
🏢 Joblinxsapp
📍 Ontario