Insight Analyst Intern

Agents, brokers and direct customers all buy through our platforms, with policy administration on Guidewire. Regional offices in Munich and five other cities support agents and policyholders.

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 Germany. Standard office hours, Monday to Friday, with flexibility around them. We ship you a laptop and accessories before your first day.

Responsibilities

• Track marketing campaign results using Google Analytics 4 data
• Join a weekly call with the analytics lead to review your work
• Document metric definitions so everyone calculates churn and conversion the same way
• Maintain the data dictionary and keep dashboard filters up to date
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Analyse funnel drop-offs and summarise findings in a one-page note
• Create charts and short slide decks for the monthly review call

What we're looking for

• Based in Germany for the duration of the internship
• Available for the full internship period
• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028
• Laptop with Excel or Google Sheets and a stable internet connection
• Some familiarity with Power BI or Tableau, even from a course or certification
• A sample dashboard or analysis project you can share

What you'll learn

• Top interns are considered for a junior analyst opening
• How business metrics like CAC, churn and retention are actually calculated

Duration: 12 months

Start date: Sep 2027

Stipend: €1,400 - €1,800 per month

What we offer

• Company laptop
• Flexible hours
• Paid public holidays
• Online learning budget

We are reviewing applications as they arrive, so apply early.

Duration: 12 months. Start: Sep 2027.

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