Data Analyst Intern

Loan decisions are made locally, usually within a few days. Our branches handle everyday banking, while the loan centre in Lausanne underwrites farm, auto and home loans.

About the role

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote position. Most of the team is in Lausanne, but nobody is required to come in. Good written English matters here, since most updates are written.

Responsibilities

• 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.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Join a weekly call with the analytics lead to review your work.
• 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.
• Track marketing campaign results using Google Analytics 4 data.

What we're looking for

• Based in Switzerland for the duration of the internship.
• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028.
• Eligible to work in Switzerland.
• Must be able to follow up on data requests without constant reminders.
• Available 20 to 40 hours a week, Monday to Friday.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.

Preferred

• Experience with Google Analytics 4 or Mixpanel.
• Knowledge of basic statistics such as medians, percentiles and correlation.
• Prior project with real business data from a college club, family business or freelance client.

Duration: 6 months

Start date: Feb 2027

Stipend: CHF 2,400 - CHF 2,600/month

What we offer

• Paid public holidays.
• Online learning budget.
• Letter of recommendation.
• Possibility of a full-time offer.
• Internet allowance.

This posting may close early if we receive enough applications.

Duration: 6 months. Start: Feb 2027.

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