Business Intelligence Intern

Who we are:

We originate and service equipment loans for construction companies, farms and trucking fleets. Mortgage brokers in England send us loans to underwrite, close and fund. Still family owned, 71 years on. Compliance reviews outgoing client email, so expect to write carefully.

Overview:

This role is about accuracy first. A wrong number in a report is worse than a late one. Our team is spread across 17 countries. Headquarters is in Manchester. The internship is fully remote. Interns join our Manchester team on daily calls and get a named mentor. Core hours are 10:00 AM to 4:00 PM UK time. Day-to-day communication is in Slack and Google Meet.

Responsibilities:

• Create charts and short slide decks for the monthly review call
• Maintain the data dictionary and keep dashboard filters up to date
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Check numbers across sources and flag mismatches before reports go out
• Prepare the weekly MIS report and send it to the team lead every Monday
• Join a weekly call with the analytics lead to review your work

Who can apply:

• Based in the US for the duration of the internship
• 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 between December 2027 and June 2028
• Available 20 to 40 hours a week, Monday to Friday
• Clear written English for reports and status updates
• Must be able to follow up on data requests without constant reminders
• Basic SQL, enough to write SELECT queries with joins and filters
• A sample dashboard or analysis project you can share
• Laptop with Excel or Google Sheets and a stable internet connection

Nice to have:

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

Duration: 3 months

Start date: Mar 2027

Stipend: $33.00 - $35.50/hr

Perks:

• Company laptop
• Flexible hours
• Paid company holidays
• Home office setup stipend

Duration: 3 months. Start: Mar 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Manchester Investment Partners Ltd.