Business Analyst Intern

About Albion Insurance

The company underwrites workers' compensation for small and mid-sized employers. Licensed producers and customer service reps work each account together in Applied Epic. Licensing (property and casualty, life and health) is paid for, with study time during work hours.

Overview

Albion Insurance needs a data analytics intern to build reports and dashboards for the Growth Analytics team. The internship is fully remote. Interns join our Bristol team on daily calls and get a named mentor. You will need to be available during UK office hours, at least until 3:00 PM GMT. You will write a lot of updates, so clear written English is important.

Responsibilities

• Build and update dashboards in Power BI, Tableau or Looker Studio
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Maintain the data dictionary and keep dashboard filters up to date
• Check numbers across sources and flag mismatches before reports go out
• Join a weekly call with the analytics lead to review your work

What we're looking for

• Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2027 batch)
• Are available for a full-time work from home internship for the entire duration
• Women starting or restarting their careers are encouraged to apply
• Have a working laptop and a stable internet connection
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Clear written English for reports and status updates
• A sample dashboard or analysis project you can share

Preferred

• Python with pandas for data cleaning
• Knowledge of basic statistics such as medians, percentiles and correlation

Duration: 3 months

Start date: Within 2 weeks

Stipend: $450 to $550/month

What we offer

• Internet allowance
• Free access to paid learning courses
• Laptop provided for the internship
• Performance bonus

Duration: 3 months. Start: Within 2 weeks.

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