Job Overview

This role focuses on delivering Business Intelligence (BI) reporting solutions to support program areas within the Ministry of the Attorney General. The candidate will work closely with project teams to design, develop, and maintain data-driven dashboards and reports using Microsoft BI technologies.

Key Responsibilities

- Collaborate with stakeholders to gather and analyze business requirements
- Design and develop Power BI reports, dashboards, and visualizations
- Perform data modelling, ETL processes, and data warehousing
- Utilize tools such as Power BI Desktop, Power BI Report Builder, Azure Data Factory, and Databricks
- Ensure compliance with WCAG 2.1 Level AA accessibility standards
- Conduct testing, troubleshooting, and issue resolution for BI solutions
- Prepare and maintain technical documentation and knowledge transfer materials

Assignment Deliverables

- Requirements gathering and solution design
- Development of data pipelines and BI solutions
- Creation of dashboards and reports in Power BI
- Troubleshooting and performance optimization

- Documentation and knowledge transfer
- Participation in team meetings and project updates

Evaluation/Criteria Analytical and Problem-Solving Skills

- Experience/ demonstrated ability to perform technical troubleshooting, specifically within a business intelligence setting/team or against reports, dashboards, and database queries such as Transact SQL (T-SQL)
- Experience / demonstrated ability to analyze data to resolve data quality issues and perform report validation




- Demonstrated experience working within a team environment to troubleshoot and resolve technical problems

Communication Skills

- Oral and written communication skills, Interpersonal and consultative skills, Facilitation skills
- Demonstrated experience working in a team environment, contributing to team meetings on work progress, communicating risks and issues, providing results from work assessments, and explaining technical tasks to non-technical team members

- Experience preparing documentation

Requirements

Mandatory Requirements

Demonstrated working knowledge of Power BI Desktop, and Power BI Paginated Report Builder [At least 2 years of experience]

Demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) [At least 4 years of experience]

Demonstrated working knowledge of DAX programming [At least 2 years of experience]

Demonstrated work knowledge of ETL tools, such as Microsoft Azure Data Factory, and Data Bricks, as well as data modelling methodologies. [At least 2 years' experience]

Nice-to-Have Skills and Experience

Experience/ demonstrated ability to perform technical troubleshooting, specifically within a business intelligence environment/team or against reports, dashboards,



and database queries such as Transact SQL (T-SQL)

Experience / demonstrated ability to analyze data to resolve data quality issues and perform report validation

Demonstrated experience working within a team environment to troubleshoot and resolve technical problems

Oral and written communication skills, Interpersonal and consultative skills, Facilitation skills

Demonstrated experience working in a team environment, contributing to team meetings on work progress, communicating risks and issues, providing results from work assessments, and explaining technical tasks to non-technical team members

Experience preparing documentation

Desired Skills and Experience

Experience working in a business intelligence team/ environment, developing and delivering business intelligence and/or analytical reports and dashboards

Experience working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards and work with team members to explore options to redesign outdated reports

Experience writing and working with Microsoft Power BI DAX code to implement business logic within Power BI reports

Experience performing troubleshooting of SQL queries, business intelligence and analytical reports, as well as performing data analysis to complete data validation and ensure report accuracy.

Knowledge of Microsoft SQL Server, and Oracle databases

Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT, IBM InfoSphere DataStage, etc.

📌 Report Developer - Senior (Toronto)
🏢 Joblinxsapp
📍 Toronto