BI Developer / Data Analyst

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.

Requirements

• 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.

Benefits

• We are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act.