Product Analytics Intern

About Atlantic Capital:

Atlantic Capital is a fee-only advisory practice with two advisors, a paraplanner and an office manager. Small business owners and physicians make up a large share of the client list.

About the role:

Atlantic Capital needs a data analytics intern to build reports and dashboards for the Business Intelligence team. Remote within Canada. The team meets in Halifax once a quarter, travel covered. Flexible hours with a daily team call in the morning. You get a company laptop and a headset before you start.

What you'll do:

• Join a weekly call with the analytics lead to review your work.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• 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.
• Create charts and short slide decks for the monthly review call.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.

Requirements:

• Eligible to work in Canada.
• Based in Canada for the duration of the internship.
• Available for the full internship period.
• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028.
• Must be able to follow up on data requests without constant reminders.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Basic SQL, enough to write SELECT queries with joins and filters.
• A sample dashboard or analysis project you can share.
• Clear written English for reports and status updates.
• Some familiarity with Power BI or Tableau, even from a course or certification.

Bonus points:

• Python with pandas for data cleaning.

What you'll learn:

• Certificate, letter of recommendation and flexible hours.
• Top interns are considered for a junior analyst opening.

Duration: 3 months

Start date: Mar 2027

Stipend: $23.00 - $24.00 an hour

What we offer:

• Mentorship from a dedicated buddy and manager.
• Paid sick time.
• Paid company holidays.
• Learning and development stipend.

This position requires a background check.

Duration: 3 months. Start: Mar 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Atlantic Capital, Inc..