Senior Report Developer

Joblinxsapp; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

The Common Cluster Solutions in Toronto is seeking an experienced Power BI Developer to design and deliver high-quality BI solutions for ministries and internal units. You will build scalable data models, dashboards, and reports while collaborating with stakeholders across technical and business domains.

The role requires 5+ years of Power BI, strong DAX and Power Query skills, and fluency with SQL Server, Azure, and Power Platform.

Qualifications

• 5+ years of experience as a Power BI Developer/Report Developer.
• Strong expertise in Power BI Desktop & Service.
• Proficient in DAX.
• Proficient in Power Query (M).
• Experience with SQL Server and relational databases.
• Data modeling (star/snowflake).
• Best practices in data visualization.
• Experience with Azure ecosystem (Azure Data Factory, Power Platform).

Responsibilities

• Design, develop, and deploy Power BI reports, dashboards, and data models.
• ETL data using Power Query.
• Analyze stakeholder requirements and translate into BI solutions.
• Ensure alignment with IT standards and processes.
• Perform data profiling, cleansing, and transformation.
• Optimize report performance (measures, relationships, visuals).
• Support system testing and UAT.
• Collaborate with developers, testers, and program managers.
• Document solutions, processes, and deliverables.
• Participate in knowledge transfer sessions.
• Deliver high-quality, user-friendly visualizations for executive and operational audiences.

Skills

Power BI

DAX

Power Query

SQL Server

Azure

Azure Data Factory

Power Platform

Data Modeling

Data Visualization

Tools

Azure Data Factory

Power BI Service

Job description

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