Data Analyst Intern

Commercial lines, personal lines and specialty programs are run as separate business units. We're looking for a Data Analyst Intern. This role is about accuracy first. A wrong number in a report is worse than a late one. This is a remote internship. You will work with our team in Edmonton, and the stipend is paid monthly in USD. Core hours overlap with US Central time, 9:00 AM to 1:00 PM CT.

What you will do:

• Track marketing campaign results using Google Analytics 4 data.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Check numbers across sources and flag mismatches before reports go out.
• Maintain the data dictionary and keep dashboard filters up to date.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

About you:

• Based in Japan for the duration of the internship.
• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Must be able to follow up on data requests without constant reminders.
• Some familiarity with Power BI or Tableau, even from a course or certification.

5 months, starting Mar 2027. Stipend: $1,500 to $1,750 monthly.

Perks: Certificate of completion, Online learning budget, Possibility of a full-time offer.

Duration: 5 months. Start: Mar 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Orchardhaven Assurance.