Description A Note on Assignment Type:

This position is listed as Onsite, working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified.

Scope

- Provide planning, assessment, and development effort to meet workload demand of the BI reporting enablement activity, which support program areas within the Ministry of Attorney General.
- Work with a Project Manager and Business Areas to evaluate requirements, model/process data (I.e., Extract, Transform and Loading (ETL) & data warehousing) and develop reports/dashboards/data visualizations, utilizing Power BI Desktop, Power BI Report Builder (based on best fit to meet requirements).
- Work with project team to ensure reports/dashboards/data visualizations are properly reviewed for quality assurance and compliance with the Web Content Accessibility Guidelines 2.1 Level AA.
- Work with project team to complete all relevant and required documentation, such as knowledge transfer, and communication, to support the completion of the project

Assignment Deliverables

- Participate in requirements gathering sessions to understand the functional and non-functional needs
- Perform assessment, and define approach in collaboration with project team and stakeholder to successfully deliver effective BI Solutions
- Perform data modelling and develop data processing pipelines to supply data repositories and warehouses using Microsoft Azure Data Factory, and Data Bricks.
- Perform design and development activities to produce reports/dashboards/data visualizations within Power BI Desktop or Power BI Report Builder.
- Perform troubleshooting and apply corrective actions to resolve issues with BI Solutions discovered during pre-release testing
- Work with project team to provide relevant and required documentation to support migration activities and knowledge transfer
- Participate in knowledge transfer activities

Experience Requirements A Note on the VOR Master Service Agreement: The VOR Master Service Agreement expires on April 5, 2027, and includes a six (6)-month survival clause, allowing the Statement of Work (SOW) to continue, if operationally required, until October 5, 2027. Extension(s) are only allowed using unused days and/or funds remaining on the contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW.

JTS may exercise its option(s) to extend the SOW beyond April 5, 2027, in accordance with the survival clause.

The start date is subject to change based on security clearances and contract signing timelines.

Experience and Skillset 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.

Resumes Evaluation/Criteria: Criteria 1: Technical Knowledge – 50 Points

- Experience/ demonstrated ability writing Transact-SQL (T-SQL) queries (at least 4 years of experience)
- Experience/ demonstrated ability working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards (at least 2 years of experience)
- Experience / demonstrated ability writing DAX code, perform data modelling and implement functionality within Power BI reports and dashboards (at least 2 years of experience)
- Experience / demonstrated ability using ETL tools, such as Microsoft Azure Data Factory, and Data Bricks, as well as data modelling methodologies. [At least 2 years’ experience]

Criteria 2: Analytical and Problem-Solving Skills – 30 Points

- 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

Criteria 3: Communication Skills – 20 Points

- 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

Knowledge Transfer What needs to be KT

- All documentation relating to the technology designs and technology knowledge specific to the candidate’s assignment All information gathered while working with vendors and internal solutions to be shared Any best practices, work around, lessons learned must be documented
- Codes
- Scripts
- Power BI report and dashboard specifications (PBIX files)

To whom

- Project Manager / Team members

When

- 1:1 meetings / team meetings / documentation on SharePoint site, throughout the duration of the project life cycle etc.

Supplier Comments Closing Date/Time: 2026-08-28, 12:00 p.m. EST

Max submission: 1 (one)

5 days onsite

This is fully onsite – no hybrid/remote work. Candidates will be declined if they cannot come onsite.

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/ setting, 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 (Toronto)
🏢 Softline Technology
📍 Toronto