Insight Analyst Intern (Remote)

Who we are

Loan decisions are made locally, usually within a few days. Online and mobile banking run on the Jack Henry platform, with Zelle and mobile deposit. Most lenders have lived in the area for decades and know their borrowers.

Overview

Nottingham Trust Company needs a data analytics intern to build reports and dashboards for the Growth Analytics team. We are headquartered in Nottingham and have been hiring remotely since 2020. The internship is fully remote. Interns join our Nottingham team on daily calls and get a named mentor. Core hours are 10:00 AM to 4:00 PM UK time.

Responsibilities

• Maintain the data dictionary and keep dashboard filters up to date
• Document metric definitions so everyone calculates churn and conversion the same way
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Prepare the weekly MIS report and send it to the team lead every Monday
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Check numbers across sources and flag mismatches before reports go out
• 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

What we're looking for

• Based in Egypt for the duration of the internship
• Eligible to work in Egypt
• Available for the full internship period
• Must be able to follow up on data requests without constant reminders
• A sample dashboard or analysis project you can share
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Laptop with Excel or Google Sheets and a stable internet connection
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2028
• Available 20 to 40 hours a week, Monday to Friday

Nice to have

• Familiarity with DAX in Power BI
• Prior project with real business data from a college club, family business or freelance client

What you get out of it

• Writing SQL against a real production warehouse
• How business metrics like CAC, churn and retention are actually calculated
• Top interns are considered for a junior analyst opening
• Presenting numbers in a way non-technical people can act on

Duration: 6 months

Start date: Mar 2027

Stipend: EGP 16,000 to EGP 16,500/month

What we offer

• Company laptop
• Letter of recommendation
• Flexible hours
• Internet allowance
• Mentorship
• Paid public holidays

Duration: 6 months. Start: Mar 2027.

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