Analytics Intern

Consultants are staffed across industries early on, then specialize after a few years. We're looking for an Analytics Intern. This role is about accuracy first. A wrong number in a report is worse than a late one. Remote position. Most of the team is in Toronto, but nobody is required to come in. Normal working hours, Monday to Friday. Most communication happens in Slack, with short video calls when needed.

The work

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Document metric definitions so everyone calculates churn and conversion the same way
• Check numbers across sources and flag mismatches before reports go out
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Create charts and short slide decks for the monthly review call

Requirements

• Based in Canada for the duration of the internship
• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028
• Some familiarity with Power BI or Tableau, even from a course or certification
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027 or 2028
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts

6 months, starting Jan 2027. Stipend: $22.00 - $24.00 per hour.

Perks: Learning and development stipend, Home office setup stipend, Company laptop, Intern events and speaker sessions (virtual).

Duration: 6 months. Start: Jan 2027.

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