Back to jobs

BI/Data Analyst Intern

Pay
Pay not listed
Work setting
Not stated
Employment
Full-time — employment source
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.
Read the full posting

Before you apply

New graduates
For current studentsJob title: BI/Data Analyst Intern

What you’ll work on

Full posting
  • Extract and manipulate data using SQL and/or Python

  • Build visualizations and interactive dashboards in Power BI and Fabric

  • Develop KPIs and automate performance reports

  • Run ad hoc analyses to answer business questions and spot trends

  • Turn business needs into analysis using hypothesis testing

From the employer’s posting
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.

What you’ll bring

All qualifications

Core experience

  • Student with interest in data analytics
  • Comfort working with SQL for data extraction and Excel for analysis
  • Exposure to Power BI or other visualization tools, from coursework or projects
  • Strong attention to detail and problem-solving mindset
  • Excellent communication and collaboration skills
Qualification wording
Students with a passion for analytics and data storytelling.
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.
Strong attention to detail, a problem-solving mindset, and curiosity.
Excellent communication and collaboration skills.
Apply at Kensington

Posting record

Report an error

Actively hiringFirst seen by us 5 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 9, 20265 days ago
Recorded sightings
7
Last seen by us
Nov 15, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 5

Similar jobs usually come down between day 5 and day 43.

From 14,732 similar postings that came down. Coming down is not always a hire.

Kensington is hiring

4 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Excel
  • Power BI
Where the posting names them
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
What You'll Learn - Extract and manipulate data using SQL and/or Python. - Build dashboards and KPIs in Power BI and Microsoft Fabric.
- 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.
Responsibilities include: - Extract and manipulate data using SQL and/or Python. - Build visualizations and interactive dashboards in Power BI Desktop and Microsoft Fabric.
- 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.
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:
- 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.
- 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.
- 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.
- 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.

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Demand for Analyst roles

New Analyst postings at the employers we follow are up 23% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 2. The fewest in a week was 993, the most 1,515, and the latest week had 1,515.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Job description

View original posting ↗

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.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Toronto, ON, Canada

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.
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.