Analytics Intern, Summer 2027

Consultants are staffed across industries early on, then specialize after a few years. Engagement teams range from three people to more than 200 on multi-year transformation programs. Training starts with a two-week bootcamp, then continues on the job.

Overview

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. This role is fully remote within Canada. Few meetings, lots of written updates.

What you'll do

• Track marketing campaign results using Google Analytics 4 data.
• Join a weekly call with the analytics lead to review your work.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Build and update dashboards in Power BI, Tableau or Looker Studio.

Requirements

• Eligible to work in Canada.
• Currently enrolled in a bachelor's or master's degree, graduating between December 2027 and June 2028.
• Available for the full internship period.
• Based in Canada for the duration of the internship.
• Must be able to follow up on data requests without constant reminders.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Available 20 to 40 hours a week, Monday to Friday.
• Comfort with numbers and strong attention to detail.

Preferred

• Experience with Google Analytics 4 or Mixpanel.

What you'll learn

• Writing SQL against a real production warehouse.
• You will build at least one dashboard that managers use every week.

Duration: 10 weeks

Start date: Summer 2027

Stipend: $23.50-$24.50/hr

What we offer

• Learning and development stipend.
• Company laptop.
• Mentorship from a dedicated buddy and manager.
• Return offer opportunities.

Duration: 10 weeks. Start: Summer 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at JF Advisors.