Product Analytics Intern

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.

About the role:

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote, open to candidates across Canada. Standard office hours, Monday to Friday, with flexibility around them. We use Slack, Notion and Google Meet. Cameras on for team calls.

Day to day:

• Join a weekly call with the analytics lead to review your work
• Answer ad hoc data requests from sales and support within a day or two
• Maintain the data dictionary and keep dashboard filters up to date
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Create charts and short slide decks for the monthly review call
• Build and update dashboards in Power BI, Tableau or Looker Studio

What we're looking for:

• Available for the full internship period
• Based in Canada for the duration of the internship
• Laptop with Excel or Google Sheets and a stable internet connection
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026, 2027 or 2028
• Basic SQL, enough to write SELECT queries with joins and filters

What you get out of it:

• How business metrics like CAC, churn and retention are actually calculated
• Certificate, letter of recommendation and flexible hours
• Writing SQL against a real production warehouse

Duration: 6 months

Start date: Dec 2026

Stipend: $22.00 - $23.50 per hour

What we offer:

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

Duration: 6 months. Start: Dec 2026.

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