Business Intelligence Intern - Remote

Who we are:

Dentists, insurance agents and law offices make up most of the client list. Started by a former school district network admin in 2017, the business has grown almost entirely through referrals. After-hours on-call comes around every fourth week.

Overview:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote, open to candidates across Canada. Flexible hours with a daily team call in the morning. You need a reliable internet connection and somewhere quiet to work.

What you'll do:

• Track marketing campaign results using Google Analytics 4 data.
• Create charts and short slide decks for the monthly review call.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• 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.

Who can apply:

• 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.
• Available 20 to 40 hours a week, Monday to Friday.
• 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.
• Must be able to follow up on data requests without constant reminders.
• A sample dashboard or analysis project you can share.

What you'll learn:

• Presenting numbers in a way non-technical people can act on.
• How business metrics like CAC, churn and retention are actually calculated.
• Top interns are considered for a junior analyst opening.
• Certificate, letter of recommendation and flexible hours.

Duration: 12 weeks

Start date: June 2027

Stipend: $22.00-$25.00 per hour

What we offer:

• Mentorship from a dedicated buddy and manager.
• Learning and development stipend.
• Paid company holidays.
• Flexible hours.

Duration: 12 weeks. Start: June 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Ottawa Technology Group.