BI Engineer

Insight Global; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

Insight Global is seeking a BI Engineer to join a leading bank in Toronto on a contract basis. You will design, develop, and deliver BI reporting and analytics using the Enterprise Data Warehouse and Power BI, collaborating with cross-functional teams and stakeholders to translate requirements into scalable solutions.

The role emphasizes BAU reporting, production support, and continuous improvements in reporting quality and performance, leveraging Microsoft BI technologies, SQL Server, and Power

Qualifications

• 3+ years of experience as a BI Engineer driving reporting performance and data quality.

Responsibilities

• Design, develop, and deliver BI reporting and analytics solutions for internal stakeholders.
• Provide production support and drive continuous improvements in reporting quality and performance.

Skills

SQL proficiency

BI reporting

Stakeholder comms

Tools

Power BI

SSRS/SSAS

Azure DevOps

SQL Server

GCP

Job description

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.

Skills and Requirements

• 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
• Microsoft Fabric experience
• GCP experience

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].