Business Intelligence Engineer

Toronto, ON
Hybrid
Posted Oct 9, 2026
1 position

$40–$46 / hour

Opens LinkedIn

Employment type: Contract
Experience level: Mid-level · 3+ years
Posting language: English
Working hours: 40 hours per week
Seniority: Mid-Senior level
Application method: Direct apply is available

Job summary

Design, develop, and deliver scalable, secure BI reporting and analytics solutions using the Enterprise Data Warehouse, Microsoft BI technologies, SQL Server, and Power BI. Support scheduled reporting and production operations, troubleshoot issues, and continuously improve reporting quality, performance, and maintainability in collaboration with technical teams and business stakeholders.

Job details

12 month contract Location: Toronto, ON Hybrid Pay Rate: $40-$46 per hour Job Description Insight Global is looking for a BI Engineer to join a leading bank in Toronto to join a top bank in Toronto on a contract basis. The purpose of this position is to design, develop, and deliver Business Intelligence (BI) reporting and analytics solutions to internal stakeholders using the Enterprise Data Warehouse and other enterprise applications. This role collaborates with cross‑functional technology teams, Information Management, and business stakeholders to translate reporting and analytics requirements into scalable, secure, and reliable solutions. This position has a strong Business‑as‑Usual (BAU) component and is expected to deliver regularly scheduled and/or orchestrated reporting outputs, provide production support, and drive continuous improvements in reporting quality, performance, and maintainability. The role leverages Microsoft BI technologies, SQL Server, and Power BI, to support both operational reporting and analytics needs. Required Skills & Experience -3+ years of experience as a BI Engineer driving continuous improvement in reporting performance, data quality, and BI platform capabilities -Advanced understanding of reporting and data analysis tools such as Microsoft SQL Server, SSRS, SSAS, Excel PowerPivot, Power BI, Power Query, etc -Familiarity working with Azure DevOps (or JIRA) and ITSM tools -Strong proficiency with SQL Server database objects (stored procedures, views, functions) and query optimization -Experience supporting business-as-usual reporting operations, including scheduled reporting cycles and production support -Experience performing data validation, troubleshooting reporting issues, and providing Tier II support -Strong written and verbal communication skills; able to work effectively with both technical and non-technical stakeholders Nice to Have Skills & Experience Microsoft Fabric experience GCP experience We may use artificial intelligence tools to assist with the screening, assessment, or selection of potential applicants for this position. Vacancy: This posting is for a currently vacant role, and the successful candidate will be hired into an existing open position.

What you’ll do

Requirements

Requires 3+ years of BI engineering experience, advanced knowledge of Microsoft reporting and data analysis tools, and strong SQL Server database and query optimization skills. Candidates should have experience with scheduled reporting, production support, data validation, troubleshooting, Tier II support, and communicating with technical and non-technical stakeholders; Azure DevOps or JIRA and ITSM familiarity are also expected.