Business Intelligence Intern

About Schmidt & Sons Electrical Contractors

Apprentices train through a four-year program with classroom nights and on-the-job hours. Building automation and controls teams support hundreds of commercial clients. We started in 1994 and have grown to about 390 people. Tools are provided, though most techs bring their own hand tools.

Overview

Schmidt & Sons Electrical Contractors needs a data analytics intern to build reports and dashboards for the Business Intelligence team. You will intern remotely with our team in Ontario. We have hosted remote interns from several countries before. You will need at least 3 hours of overlap with US Pacific time. Clear written English is a must, as the team works across time zones.

Responsibilities

• Prepare the weekly MIS report and send it to the team lead every Monday.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• 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.
• Document metric definitions so everyone calculates churn and conversion the same way.

Who can apply

• Based in Canada for the duration of the internship.
• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028.
• Eligible to work in Canada.
• Available 20 to 40 hours a week, Monday to Friday.
• Must be able to follow up on data requests without constant reminders.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Some familiarity with Power BI or Tableau, even from a course or certification.

Preferred

• Google Data Analytics or Microsoft PL-300 certification.

Duration: 6 months

Start date: Feb 2027

Stipend: $27.00 - $36.50/hr

What we offer

• Mentorship from a dedicated buddy and manager.
• Intern events and speaker sessions (virtual)
• Flexible hours.
• Paid company holidays.
• Learning and development stipend.

We are not working with agencies on this role.

Duration: 6 months. Start: Feb 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Schmidt & Sons Electrical Contractors.