BI Developer & Data Analyst

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

Job summary

A leading travel experience company located in Toronto is looking for a BI Developer / Data Analyst to join their analytics team. This role involves developing SQL- and DAX-driven datasets, designing semantic data models, and building Power BI reports. Candidates should have 3–5 years of experience in BI development and data analytics, strong SQL and DAX skills, and a proven ability to manage multiple stakeholders and projects in a fast-paced, cross-functional environment. This position offers an opportunity to impact business decisions with data-driven insights.

Qualifications

• 3–5 years of experience in BI development and data analytics.
• Strong critical thinking and analytical skills.
• Ability to distinguish correlation from causation.

Responsibilities

• Develop and maintain SQL- and DAX-driven BI datasets.
• Design, enhance, and maintain semantic data models.
• Build, publish, and maintain Power BI reports and datasets.

Skills

SQL

DAX

Data analytics

Power BI

Critical thinking

Business acumen

Tools

Power Query

SSMS

Job description

Overview

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 multiple priorities and competing requests while maintaining data quality and delivery standards.
• Translate business questions into actionable BI solutions that drive outcomes.

What You Bring (Must Have)

• 3–5 years of experience in BI development and data analytics.
• Strong critical thinking and analytical skills, including ability to distinguish correlation from causation, perform root cause analysis, and apply basic statistical methods to support business decision-making
• Strong SQL and DAX skills, with the ability to build and troubleshoot complex logic
• Solid understanding of dimensional modeling fundamentals: Fact and dimension tables, Star schemas, Data grain and relationships
• Hands-on experience with:
• Power BI Desktop
• Publishing datasets and reports
• Managing and troubleshooting scheduled refreshes
• Power Query for data ingestion and transformation
• Ability to use SSMS (or other tools) to extract and validate data using SQL, and to automate recurring data refreshes that keep BI semantic models up to date
• Strong business acumen and ability to connect analytics to business decisions
• Proven ability to manage multiple stakeholders and priorities in a cross-functional, cross-BU environment.
• Clear communication skills and comfort working with both technical teams and senior leaders.

Nice to Have

• Experience building Power BI Apps with dynamic, executive-facing content.
• Familiarity with Microsoft Fabric / Lakehouse concepts.
• Exposure to Medallion architecture (Bronze / Silver / Gold).
• Experience supporting transitions from SQL Server–based models to Fabric.
• Marketing analytics experience, including working with data from tools such as Google Analytics, Google Ads, or other digital marketing platforms, and translating performance data into actionable insights.
• Experience working in governed or shared BI environments.

We are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. If you require accommodation due to a disability at any stage of our hiring process, please advise us when completing your application.

The Range Group may use artificial intelligence throughout the recruitment process to screen, assess or select applicants for this position. These tools assist our hiring team but do not replace human judgment. Final hiring decisions are ultimately made by humans.

We thank all candidates for their interest however only those selected for an interview will be contacted.