Product Analytics Intern

About us:

We specialize in commercial insurance for contractors, trucking companies and restaurants. Licensed producers and customer service reps work each account together in Applied Epic. Licensing (property and casualty, life and health) is paid for, with study time during work hours.

Overview:

This role is about accuracy first. A wrong number in a report is worse than a late one. Fully remote. You can work from anywhere in the US. Hours are flexible, with one short team call each morning. We send you a laptop and the accessories you need on day one.

What you'll do:

• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Track marketing campaign results using Google Analytics 4 data.
• 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.

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.
• Clear written English for reports and status updates.
• Available 20 to 40 hours a week, Monday to Friday.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Comfort with numbers and strong attention to detail.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Must be able to follow up on data requests without constant reminders.

Nice to have:

• Experience with Google Analytics 4 or Mixpanel.
• Google Data Analytics or Microsoft PL-300 certification.

Duration: 4 months

Start date: Dec 2026

Stipend: $30.50 - $42.50/hr

Perks:

• Final presentation to leadership.
• Intern events and speaker sessions (virtual)
• Return offer opportunities.
• Company laptop.
• Mentorship from a dedicated buddy and manager.
• Flexible hours.

Please include a short note on why this role interests you.

Duration: 4 months. Start: Dec 2026.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Keystone Mutual Insurance, LLC.