BI Developer & Data Analyst

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

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.

Are you passionate about data and analytics that solvereal businessproblems ?

Do you enjoy building BI solutions that leaders trust to make critical decisions?

We’relooking for a BI Developer / Data Analyst to join our analytics team and play a key role inmaintaining, 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 andmaintain 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 whilemaintainingdata 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 developmentanddata 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,Datagrainand 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 othertools) to extract andvalidatedata 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, andtranslating 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.