About the role#
As a BI/Data Analyst Intern, you will work with our analytics team to uncover insights that drive business growth and optimize client experiences. You will use tools like SQL, Power BI, and Excel to contribute to dashboards, KPIs, and business decision-making in the luxury travel space.
What you'll do#
- Extract and manipulate data using SQL or Python.
- Build visualizations and interactive dashboards in Power BI Desktop and Microsoft Fabric.
- Develop KPIs and automate reports to support performance tracking.
- 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'll need#
- Current student pursuing a degree in Data Science, Statistics, or Computer Science.
- 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 through coursework or projects.
- Willingness to learn Python, data modeling, and Microsoft Fabric.
- Strong attention to detail, a problem-solving mindset, and curiosity.
- Excellent communication and collaboration skills.
Location & details#
- Location: Toronto, Ontario, Canada.
- Modality: Hybrid.
- Employment: Full-time internship.
- Term: Rolling.
- Compensation: Paid position.
About Kensington
Kensington provides personalized travel arrangements for clients across more than 120 countries. The company organizes tours, cruises, yacht charters, villa rentals, and private jet travel. It employs 736 people and maintains offices in Toronto and Wilmington. The organization is privately held.
How to get in at Kensington
Securing an internship at Kensington requires speed because early applicants often have their materials reviewed before the volume of candidates becomes unmanageable. Intern Insider sends an instant alert the moment a role matching your target is published anywhere, so you apply among the first and get seen before the pile grows. Reaching out to the right person is often more effective than submitting an application into a general queue. Intern Insider surfaces the recruiters behind the company roles so you can reach out directly to ask about the position or a referral, which materially improves response rates.
