Strategic BI Developer & Data Analytics Lead

Kensington Tours; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading travel company in Toronto is looking for a BI Developer / Data Analyst to join its analytics team. This role involves developing and maintaining SQL and DAX-driven BI datasets, along with building and publishing Power BI reports. The ideal candidate will have 3-5 years of experience in BI development, strong SQL and DAX skills, and a demonstrated ability to manage multiple stakeholders. This position offers an exciting opportunity to work in a cross-functional environment and contribute to key business decisions.

Qualifications

• 3–5 years of experience in BI development and data analytics.
• Strong SQL and DAX skills with the ability to build and troubleshoot complex logic.
• Ability to balance multiple stakeholders and priorities in a cross-functional environment.

Responsibilities

• Develop and maintain SQL- and DAX-driven BI datasets for enterprise reporting.
• Design and enhance semantic data models using best practices.
• Build, publish, and maintain Power BI reports and datasets.

Skills

BI development

data analytics

SQL

DAX

data visualization

critical thinking

data transformation

business acumen

cross-functional collaboration

Tools

Power BI

Power Query

SSMS

Job description

A leading travel company in Toronto is looking for a BI Developer / Data Analyst to join its analytics team. This role involves developing and maintaining SQL and DAX-driven BI datasets, along with building and publishing Power BI reports. The ideal candidate will have 3-5 years of experience in BI development, strong SQL and DAX skills, and a demonstrated ability to manage multiple stakeholders. This position offers an exciting opportunity to work in a cross-functional environment and contribute to key business decisions.