Insight 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.

Overview

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Fully remote. You can work from anywhere in Switzerland. Normal business hours, Monday to Friday, with some flexibility. Please make sure you have a quiet place to work and a solid internet connection.

What you'll do

• Maintain the data dictionary and keep dashboard filters up to date.
• 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.
• Document metric definitions so everyone calculates churn and conversion the same way.
• 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.
• 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

• Available for the full internship period.
• Currently enrolled in a bachelor's or master's degree, graduating 2028.
• 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.
• Available 20 to 40 hours a week, Monday to Friday.
• Clear written English for reports and status updates.
• Laptop with Excel or Google Sheets and a stable internet connection.

Preferred

• Experience with Google Analytics 4 or Mixpanel.
• Google Data Analytics or Microsoft PL-300 certification.
• Python with pandas for data cleaning.

What you get out of it

• You will build at least one dashboard that managers use every week.
• How business metrics like CAC, churn and retention are actually calculated.

Duration: 3 months

Start date: Mar 2027

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

What we offer

• Mentorship.
• Flexible hours.
• Paid public holidays.
• Online learning budget.
• Possibility of a full-time offer.

Duration: 3 months. Start: Mar 2027.

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