Product Analytics Intern

Who we are

We support about 60 local businesses, most within 30 minutes of the office. Clients have the owner's cell number, and the owner still takes the occasional Saturday call. Lunch is usually whatever is closest to the client site.

Overview

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote within the US. The team meets in New York City once a quarter, travel covered. Flexible schedule. We have one team call a day, usually in the morning.

Responsibilities

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• 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.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Analyse funnel drop-offs and summarise findings in a one-page note.

Requirements

• Currently enrolled in a bachelor's or master's program, graduating 2028.
• Available 40 hours a week for the full internship.
• Available 20 to 40 hours a week, Monday to Friday.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.

Bonus points

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

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.
• Certificate, letter of recommendation and flexible hours.

Duration: 12 weeks

Start date: May 2027

Stipend: $26.50 - $34.50 per hour

What we offer

• Paid company holidays.
• Home office setup stipend.
• Flexible hours.
• Learning and development stipend.
• Return offer opportunities.
• Mentorship from a dedicated buddy and manager.

No recruitment agencies, please.

Duration: 12 weeks. Start: May 2027.

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