Insight Analyst Intern - Remote

Our commercial banking group lends to manufacturers, health systems and real estate developers.

The internship

Remote internship for a student who likes spreadsheets and is not scared of messy data. Fully remote. You can work from anywhere in the UK. Normal business hours, Monday to Friday, with some flexibility.

What you'll do

• Analyse funnel drop-offs and summarise findings in a one-page note
• Prepare the weekly MIS report and send it to the team lead every Monday
• Create charts and short slide decks for the monthly review call
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Answer ad hoc data requests from sales and support within a day or two

Requirements

• Based in the UK for the duration of the internship
• Eligible to work in the UK
• Available for the full internship period
• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028
• Available 20 to 40 hours a week, Monday to Friday
• A sample dashboard or analysis project you can share
• Laptop with Excel or Google Sheets and a stable internet connection
• Must be able to follow up on data requests without constant reminders
• Basic SQL, enough to write SELECT queries with joins and filters
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts

Nice to have

• Prior project with real business data from a college club, family business or freelance client
• Google Data Analytics or Microsoft PL-300 certification
• Familiarity with DAX in Power BI

What you get out of it

• Top interns are considered for a junior analyst opening
• Certificate, letter of recommendation and flexible hours
• Presenting numbers in a way non-technical people can act on
• How business metrics like CAC, churn and retention are actually calculated

Duration: 5 months

Start date: Feb 2027

Stipend: £1,600 - £2,000 pcm

Perks

• Mentoring from an experienced team member
• Graduate scheme fast-track interview
• Flexible working hours
• Laptop provided
• Home working allowance
• Access to online training

We may close the vacancy early if we receive a high number of applications.

Duration: 5 months. Start: Feb 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Peak Bank & Trust Ltd.