Business Intelligence Intern

About us

Agents, brokers and direct customers all buy through our platforms, with policy administration on Guidewire. We employ 400 people across underwriting, claims, actuarial, IT and customer service.

About the role

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote, open to candidates across Canada. Normal business hours, Monday to Friday, with some flexibility.

Responsibilities

Answer ad hoc data requests from sales and support within a day or two. Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery. Track marketing campaign results using Google Analytics 4 data. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables. Prepare the weekly MIS report and send it to the team lead every Monday. Analyse funnel drop-offs and summarise findings in a one-page note.

What we're looking for

Available for the full internship period. Eligible to work in Canada. Available 20 to 40 hours a week, Monday to Friday. 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 between December 2027 and June 2028. Some familiarity with Power BI or Tableau, even from a course or certification.

Bonus points

Python with pandas for data cleaning. Knowledge of basic statistics such as medians, percentiles and correlation.

What you'll learn

Certificate, letter of recommendation and flexible hours. How business metrics like CAC, churn and retention are actually calculated.

Duration: 12 weeks

Start date: May 2027

Stipend: $20.50 to $27.00 an hour

Perks

Mentorship from a dedicated buddy and manager. Paid sick time. Paid company holidays. Flexible hours.

Applicants must be legally entitled to work in Canada.

Duration: 12 weeks. Start: May 2027.

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