Product Analytics Intern

Our claims organization handles more than 400,000 claims a year, including catastrophe response after hurricanes and hail. We close at 3 p.m. on Fridays in the summer.

About the internship:

Canyoncraft Insurance is hiring a Product Analytics Intern for June 2027. This role is about accuracy first. A wrong number in a report is worse than a late one. Remote within the US. The team meets in Boston once a quarter, travel covered. Normal working hours, Monday to Friday.

What you'll do:

• Prepare the weekly MIS report and send it to the team lead every Monday.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.

What we're looking for:

• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Clear written English for reports and status updates.
• Must be able to follow up on data requests without constant reminders.

Preferred qualifications:

• Experience with Google Analytics 4 or Mixpanel.

What you get out of it:

• You will build at least one dashboard that managers use every week.
• 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.

Program dates: June 2027, 10 weeks.

Intern pay: $29.50 - $35.00 per hour

What we offer:

• Return offer opportunities.
• Home office setup stipend.
• Learning and development stipend.
• Intern events and speaker sessions (virtual)
• Paid sick time.

We are an equal opportunity employer. If you need an accommodation during the application process, let us know.

Duration: 10 weeks. Start: June 2027.

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