BI/Data Analyst Intern

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, passionate experts with deep knowledge of their destinations. They are what enables us to deliver remarkable experiences in over 120 countries worldwide, and across each of our businesses – Private Touring, Cruises, Villas, Yachts, Expeditions, Ultraluxe Land, Private Jets, and Air. To learn more about Kensington, visit kensingtontours.com. Are you a student passionate about data, problem-solving, and uncovering insights that make a difference? Join us for a BI/Data Analyst Internship where you'll gain hands-on experience applying your skills in a fast-paced, luxury travel environment. You'll work with tools like SQL, Python, Power BI, Microsoft Fabric, and Excel/PowerPoint to build dashboards, analyze performance, and support data-driven decision-making. This is your opportunity to work with real data and learn directly from a team that's transforming how insights drive client experiences. What You'll Learn - Extract and manipulate data using SQL and/or Python. - Build dashboards and KPIs in Power BI and Microsoft Fabric. - Translate business questions into meaningful data analysis. - Present insights that help shape strategic decisions. We're Looking For - Students with a passion for analytics and data storytelling. - Exposure to SQL, Power BI, or Python through coursework or projects. - Curious, collaborative individuals who are eager to learn. This internship is ideal for someone looking to develop critical thinking, hypothesis testing, stakeholder engagement, and data visualization skills. What You'll Do As a BI/Data Analyst Intern, you'll work with our Analytics team to uncover insights that drive business growth and optimize client experiences in the luxury travel space. You'll work with data using tools like SQL, Power BI, and Excel, and contribute directly to dashboards, KPIs, and business decision-making. Responsibilities include: - Extract and manipulate data using SQL and/or Python. - Build visualizations and interactive dashboards in Power BI Desktop and Microsoft Fabric. - Support performance tracking by developing KPIs and report automation. - Conduct ad hoc analyses to answer business questions and uncover trends. - Translate business needs into analytical solutions through critical thinking and hypothesis testing. - Work with stakeholders across departments to understand business goals and communicate insights. What You Bring - Interest in data analytics and solving real business problems. - Comfort working with SQL for data extraction and Excel for analysis. - Exposure to Power BI or other data visualization tools. Academic or personal projects are welcome. - Willingness to learn Python, data modeling, and Microsoft Fabric if not already familiar. - Strong attention to detail, a problem-solving mindset, and curiosity. - Excellent communication and collaboration skills. What You'll Gain - Hands-on experience with enterprise BI tools and real-world datasets. - Mentorship from experienced analysts in a fast-paced, supportive environment. - Understanding of how data drives decisions in a high-end service business. - Exposure to a data strategy function in a growing, client-first organization. - Development of business acumen, technical skills, and data storytelling capabilities. This is a great opportunity for students who are excited to roll up their sleeves, dive into data, and grow their analytics skill set in a unique and inspiring industry. Position Details: - This is a full-time, hybrid internship offering $20 per hour for 40 hours per week. 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 the hiring team. We thank all candidates for their interest, however, only those selected for an interview will be contacted.