Product Analytics Intern

Who we are

Public sector agencies, utilities and large health systems license our asset management platform under multi-year contracts. Founded in 2006, we now have 220 employees. On-call rotates weekly and pays a flat stipend whether or not the pager goes off.

The internship

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote position. Most of the team is in New York City, but nobody is required to come in. Standard office hours, Monday to Friday, with flexibility around them. We use Slack, Notion and Google Meet. Cameras on for team calls.

Day to day

• Build and update dashboards in Power BI, Tableau or Looker Studio
• Document metric definitions so everyone calculates churn and conversion the same way
• Analyse funnel drop-offs and summarise findings in a one-page note
• Prepare the weekly MIS report and send it to the team lead every Monday
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Maintain the data dictionary and keep dashboard filters up to date

What we're looking for

• Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028
• Based in the US for the duration of the internship
• Available 20 to 40 hours a week, Monday to Friday
• Must be able to follow up on data requests without constant reminders
• Basic SQL, enough to write SELECT queries with joins and filters
• Laptop with Excel or Google Sheets and a stable internet connection
• Comfort with numbers and strong attention to detail
• Some familiarity with Power BI or Tableau, even from a course or certification

Nice to have

• Google Data Analytics or Microsoft PL-300 certification

What you'll learn

• Presenting numbers in a way non-technical people can act on
• You will build at least one dashboard that managers use every week
• Certificate, letter of recommendation and flexible hours
• Top interns are considered for a junior analyst opening

Duration: 12 weeks

Start date: May 2027

Stipend: $35.00-$37.50 an hour

Perks

• Paid sick time
• Home office setup stipend
• Paid company holidays

Interview process: a phone call, a meeting with the hiring manager, and a final conversation with the team.

Duration: 12 weeks. Start: May 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Sumacbound Digital Inc..