Analytics Intern

Every account manager handles a full book, from quotes to renewals to claims questions. We have been writing policies for the same farms and small businesses since 2005. We started in 2005 and have grown to about 43 people.

About the role

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote within the US. The team meets in Toledo once a quarter, travel covered. Normal working hours, Monday to Friday.

Responsibilities

• Prepare the weekly MIS report and send it to the team lead every Monday.
• Create charts and short slide decks for the monthly review call.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Check numbers across sources and flag mismatches before reports go out.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Maintain the data dictionary and keep dashboard filters up to date.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Document metric definitions so everyone calculates churn and conversion the same way.

Who can apply

• Available 40 hours a week for the full internship.
• 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 2028.
• Based in the US for the duration of the internship.
• Comfort with numbers and strong attention to detail.
• Must be able to follow up on data requests without constant reminders.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Clear written English for reports and status updates.

What you'll learn

• Presenting numbers in a way non-technical people can act on.
• How business metrics like CAC, churn and retention are actually calculated.

Duration: 10 weeks

Start date: Summer 2027

Stipend: $31.50 - $34.00/hr

What we offer

• Company laptop.
• Paid sick time.
• Paid company holidays.
• Home office setup stipend.
• Learning and development stipend.
• Return offer opportunities.

Duration: 10 weeks. Start: Summer 2027.

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