Product Analytics Intern

We carry more than 100,000 products from thousands of suppliers.

The internship

This role is about accuracy first. A wrong number in a report is worse than a late one. You will intern remotely with our team in Newcastle upon Tyne. We have hosted remote interns from several countries before. Working hours overlap with UK business hours. We talk mostly in Slack and hop on quick calls when something needs discussing.

What you'll do

• Check numbers across sources and flag mismatches before reports go out
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Prepare the weekly MIS report and send it to the team lead every Monday
• Track marketing campaign results using Google Analytics 4 data
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Document metric definitions so everyone calculates churn and conversion the same way

What we're looking for

• Available 40 hours a week for the full internship
• Currently enrolled in a bachelor's or master's program, graduating between December 2027 and June 2028
• Available 20 to 40 hours a week, Monday to Friday
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in between December 2027 and June 2028
• 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

Preferred

• Prior project with real business data from a college club, family business or freelance client

What you'll learn

• Writing SQL against a real production warehouse
• How business metrics like CAC, churn and retention are actually calculated
• You will build at least one dashboard that managers use every week
• Top interns are considered for a junior analyst opening

Duration: 6 months

Start date: Jan 2027

Stipend: $29.50 to $34.00 per hour

Perks

• Paid company holidays
• Mentorship from a dedicated buddy and manager
• Paid sick time

Duration: 6 months. Start: Jan 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Ormond Supply Co..