Data Analyst Placement Student (Remote)

The company underwrites workers' compensation for small and mid-sized employers. Employee benefits clients use us for group health, dental, vision and life plans.

Overview:

London Assurance needs a data analytics intern to build reports and dashboards for the Revenue Operations team. This role is fully remote within the UK. We keep meetings to a minimum and work mostly async.

Responsibilities:

• 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.
• Check numbers across sources and flag mismatches before reports go out.
• Answer ad hoc data requests from sales and support within a day or two.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Join a weekly call with the analytics lead to review your work.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Track marketing campaign results using Google Analytics 4 data.

Who can apply:

• Eligible to work in the UK.
• Based in the UK for the duration of the internship.
• Currently enrolled in a bachelor's or master's degree, graduating 2026 or 2027.
• Comfort with numbers and strong attention to detail.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Clear written English for reports and status updates.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026 or 2027.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Must be able to follow up on data requests without constant reminders.

Bonus points:

• Familiarity with DAX in Power BI.
• Python with pandas for data cleaning.

What you'll learn:

• Writing SQL against a real production warehouse.
• You will build at least one dashboard that managers use every week.
• Certificate, letter of recommendation and flexible hours.

Duration: 6 months

Start date: Dec 2026

Stipend: £1,700 - £1,900 a month

Perks:

• Access to online training.
• Reference on completion.
• Home working allowance.

Duration: 6 months. Start: Dec 2026.

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