Data Analyst Intern

Most work comes in through ConnectWise tickets, with a dispatch board for onsite visits. Dell, HP and Lenovo hardware is sold and supported for schools and local governments, as it has been since 2016.

Overview:

This role is about accuracy first. A wrong number in a report is worse than a late one. This role is fully remote within the UK. Hours are flexible, with one short team call each morning.

What you'll do:

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Track marketing campaign results using Google Analytics 4 data.
• Join a weekly call with the analytics lead to review your work.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Create charts and short slide decks for the monthly review call.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.

Requirements:

• Based in the UK for the duration of the internship.
• Available for the full internship period.
• Eligible to work in the UK.
• Basic SQL, enough to write SELECT queries with joins and filters.
• A sample dashboard or analysis project you can share.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Laptop with Excel or Google Sheets and a stable internet connection.

What you'll learn:

• How business metrics like CAC, churn and retention are actually calculated.
• Certificate, letter of recommendation and flexible hours.

Duration: 5 months

Start date: Feb 2027

Stipend: £16.50 - £17.00 p/h

Perks:

• Graduate scheme fast-track interview.
• Flexible working hours.
• Mentoring from an experienced team member.
• Home working allowance.

We may close the vacancy early if we receive a high number of applications.

Duration: 5 months. Start: Feb 2027.

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