Business Intelligence Intern

About us:

Agents, brokers and direct customers all buy through our platforms, with policy administration on Guidewire. Founded as a farmers' mutual in 1973, the company is now one of the larger mutual insurers in the UK.

The internship:

Remote internship for a student who likes spreadsheets and is not scared of messy data. You will intern remotely with our team in London. We have hosted remote interns from several countries before. You will need to be available during UK office hours, at least until 3:00 PM GMT. We talk mostly in Slack and hop on quick calls when something needs discussing.

Responsibilities:

• 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
• Check numbers across sources and flag mismatches before reports go out
• Analyse funnel drop-offs and summarise findings in a one-page note
• Create charts and short slide decks for the monthly review call

Requirements:

• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Currently enrolled in a bachelor's or master's program, graduating 2028
• Available 40 hours a week for the full internship
• A sample dashboard or analysis project you can share
• Clear written English for reports and status updates
• Laptop with Excel or Google Sheets and a stable internet connection
• Available 20 to 40 hours a week, Monday to Friday
• Must be able to follow up on data requests without constant reminders
• Some familiarity with Power BI or Tableau, even from a course or certification

Nice to have:

• Google Data Analytics or Microsoft PL-300 certification

Duration: 4 months

Start date: Jan 2027

Stipend: $29.50 to $38.00 per hour

What we offer:

• Paid sick time
• Paid company holidays
• Flexible hours
• Intern events and speaker sessions (virtual)
• Mentorship from a dedicated buddy and manager
• Final presentation to leadership

Duration: 4 months. Start: Jan 2027.

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