Business Analyst Intern

Who we are

Second-generation ownership: the founder's daughter runs the agency now. Clients drop by to pay premiums, ask about a claim or just say hello. We started in 1996 and have grown to about 39 people.

About the role

This role is about accuracy first. A wrong number in a report is worse than a late one. You can work from home anywhere in Canada. We have no office requirement. You need a reliable internet connection and somewhere quiet to work.

Responsibilities

• Track marketing campaign results using Google Analytics 4 data
• Answer ad hoc data requests from sales and support within a day or two
• Document metric definitions so everyone calculates churn and conversion the same way
• 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
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Check numbers across sources and flag mismatches before reports go out

Requirements

• Available for the full internship period
• Based in Canada for the duration of the internship
• Currently enrolled in a bachelor's or master's degree, graduating between December 2027 and June 2028
• Eligible to work in Canada
• Available 20 to 40 hours a week, Monday to Friday
• Basic SQL, enough to write SELECT queries with joins and filters
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in between December 2027 and June 2028

Nice to have

• Experience with Google Analytics 4 or Mixpanel

What you get out of it

• Top interns are considered for a junior analyst opening
• How business metrics like CAC, churn and retention are actually calculated

Duration: 10-12 weeks

Start date: Summer 2027

Stipend: $23.50 - $25.00/hr

Perks

• Home office setup stipend
• Learning and development stipend
• Return offer opportunities
• Company laptop
• Flexible hours

Accommodations are available on request for candidates taking part in all aspects of the selection process.

Duration: 10-12 weeks. Start: Summer 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Anderson Insurance Agency.