Product Analytics Intern

Every account manager handles a full book, from quotes to renewals to claims questions. Second-generation ownership: the founder's daughter runs the agency now. Most of the office has been here more than ten years.

Overview

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote position. Most of the team is in Colorado Springs, but nobody is required to come in. We do not have many meetings. Most updates happen in writing. Communication happens mostly in Slack and short video calls.

Responsibilities

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Prepare the weekly MIS report and send it to the team lead every Monday
• Analyse funnel drop-offs and summarise findings in a one-page note
• Check numbers across sources and flag mismatches before reports go out
• Join a weekly call with the analytics lead to review your work

What we're looking for

• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Based in the US for the duration of the internship
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Basic SQL, enough to write SELECT queries with joins and filters
• Must be able to follow up on data requests without constant reminders
• Laptop with Excel or Google Sheets and a stable internet connection

Duration: 10-12 weeks

Start date: June 2027

Stipend: $27.00 to $36.00 per hour

What we offer

• Company laptop
• Home office setup stipend
• Paid sick time

Duration: 10-12 weeks. Start: June 2027.

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