BI Developer / Data Analyst
Company: Kensington
Location: Toronto, Ontario
Type: Full-time
Level: mid
Posted: 2026-02-10
About this role
Kensington delivers the world’s most personal travel experiences. We bring to life each client’s desire to travel in a way that’s tailored specifically for them, in the company of local private guides who ensure that they enjoy the authentic best of their destination. The result is a unique journey rich in memories that last a lifetime.
We achieve this because of our extraordinary people, experts with deep knowledge of their destinations. For over 120 countries worldwide, and across each of our brands – Tours, Cruises, Villas, Yachts, Jets, and Air.
To learn more about Kensington, visit
kensingtontours.com
.
Are you passionate about
data and analytics that solve real business problems
?
Do you enjoy building BI solutions that leaders trust to make critical decisions?
We’re looking for a
BI Developer / Data Analyst
to join our analytics team and play a key role in maintaining, enhancing, and scaling our business intelligence environment. This is a
cross-functional, cross–business unit role
, requiring strong technical foundations, business acumen, and the ability to balance multiple stakeholders and priorities.
What You’ll Do
- Develop and maintain
SQL- and DAX-driven BI datasets
that support enterprise reporting.
- Design, enhance, and maintain
semantic data models
using best practices (fact/dimension tables, star schemas, relationships).
- Build, publish, and maintain
Power BI reports and datasets
using Power BI Desktop and Fabric workspaces.
- Create and optimize
DAX measures
aligned to business KPIs.
- Troubleshoot
scheduled refresh failures, native query issues, and data model errors
to ensure reporting stability.
- Ingest and transform data from multiple sources using
Power Query and SQL
.
- Improve data visualizations for clarity, storytelling, and executive decision-making.
- Operate in a
cross-functional, cross-BU environment
, partnering with stakeholders across teams.
- Balance
...