Data Analyst Intern

ABOUT US:

Call centers in Toronto and two other locations handle customer service. Public utility commissions regulate rates and service standards.

OVERVIEW:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. The company is based in Toronto, Canada. The team is spread across multiple countries. The internship is fully remote. Interns join our Toronto team on daily calls and get a named mentor. Core hours are 9:00 AM to 1:00 PM US Eastern. Communication happens mostly in Slack and short video calls.

DAY TO DAY:

• Join a weekly call with the analytics lead to review your work.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Create charts and short slide decks for the monthly review call.
• Track marketing campaign results using Google Analytics 4 data.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Maintain the data dictionary and keep dashboard filters up to date.

WHO CAN APPLY:

• Available 40 hours a week for the full internship.
• Based in the US for the duration of the internship.
• Currently enrolled in a bachelor's or master's program, graduating 2028.
• Must be able to follow up on data requests without constant reminders.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2028.
• Comfort with numbers and strong attention to detail.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Available 20 to 40 hours a week, Monday to Friday.

PREFERRED:

• Python with pandas for data cleaning.

Duration: 12 weeks

Start date: Jan 2027

Stipend: $27.50 - $37.00 per hour

WHAT WE OFFER:

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

Duration: 12 weeks. Start: Jan 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Coastal Electric Cooperative.