Analytics Intern

About us:

Most deposits come from local households and businesses, and most loans stay in the communities we serve.

The internship:

Remote internship for a student who likes spreadsheets and is not scared of messy data. The internship is fully remote. Interns join our Aberdeen team on daily calls and get a named mentor. Core hours are 10:00 AM to 4:00 PM UK time. Communication happens mostly in Slack and short video calls.

Day to day:

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Check numbers across sources and flag mismatches before reports go out.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

Requirements:

• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Available 40 hours a week for the full internship.
• 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.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Available 20 to 40 hours a week, Monday to Friday.

Nice to have:

• Google Data Analytics or Microsoft PL-300 certification.
• Experience with Google Analytics 4 or Mixpanel.

Duration: 10-12 weeks

Start date: Summer 2027

Stipend: $29.50 - $32.50/hr

Perks:

• Final presentation to leadership.
• Mentorship from a dedicated buddy and manager.
• Paid sick time.

Interview process: a phone call, a meeting with the hiring manager, and a final conversation with the team.

Duration: 10-12 weeks. Start: Summer 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Wessex Savings Bank.