Data Analyst Intern

Catastrophe teams deploy adjusters within days of a major storm. Our claims organisation handles more than 400,000 claims a year, including catastrophe response after hurricanes and hail.

About the internship

Kettlebrook is hiring a Data Analyst Intern for Sep 2027. This role is about accuracy first. A wrong number in a report is worse than a late one. The company is based in Birmingham, the UK. We are a distributed team spread across a few time zones. This is a remote internship. You will work with our team in Birmingham, and the stipend is paid monthly in USD. Working hours overlap with UK business hours. You will write a lot of updates, so clear written English is important.

Your projects

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Track marketing campaign results using Google Analytics 4 data.
• Answer ad hoc data requests from sales and support within a day or two.
• Create charts and short slide decks for the monthly review call.
• Check numbers across sources and flag mismatches before reports go out.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Analyse funnel drop-offs and summarise findings in a one-page note.

Who you are

• Based in Slovakia for the duration of the internship.
• Currently enrolled in a bachelor's or master's degree, graduating between December 2027 and June 2028.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Comfort with numbers and strong attention to detail.
• Clear written English for reports and status updates.

Nice to have

• Python with pandas for data cleaning.

What you get out of it

• Writing SQL against a real production warehouse.
• Certificate, letter of recommendation and flexible hours.

Program dates: Sep 2027, 6 months.

Compensation: $1,250-$1,400 monthly

Perks

• Company laptop.
• Flexible hours.
• Internet allowance.
• Possibility of a full-time offer.

We review applications as they come in.

Duration: 6 months. Start: Sep 2027.

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