Product Analytics Intern

The product is a mobile app plus a React web dashboard, with a Python and PostgreSQL backend on AWS. We started in 2021 and have grown to about 70 people. Code review is required on every pull request, and nobody merges their own changes.

Overview:

This role is about accuracy first. A wrong number in a report is worse than a late one. You can work from home anywhere in the US. We have no office requirement. Weekday working hours, with room to shift your day when needed. You get a company laptop and a headset before you start.

What you'll do:

• Answer ad hoc data requests from sales and support within a day or two
• Maintain the data dictionary and keep dashboard filters up to date
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Create charts and short slide decks for the monthly review call
• Track marketing campaign results using Google Analytics 4 data
• 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 between December 2027 and June 2028
• Based in the US for the duration of the internship
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Must be able to follow up on data requests without constant reminders
• Laptop with Excel or Google Sheets and a stable internet connection
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in between December 2027 and June 2028
• Clear written English for reports and status updates

What you get out of it:

• Presenting numbers in a way non-technical people can act on
• Writing SQL against a real production warehouse
• How business metrics like CAC, churn and retention are actually calculated
• Top interns are considered for a junior analyst opening

Duration: 6 months

Start date: Feb 2027

Stipend: $31.50-$34.00 per hour

Perks:

• Paid sick time
• Paid company holidays
• Return offer opportunities

Duration: 6 months. Start: Feb 2027.

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