Data Analyst Intern

Who we are

Catastrophe teams deploy adjusters within days of a major storm. Talondesk Insurance is a property and casualty insurer writing policies in 30 states through independent agents. We started in 1975 and have grown to about 700 people. Most of the office has been here more than ten years.

The internship

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. We are headquartered in New York City and have been hiring remotely since 2020. The internship is fully remote. Interns join our New York City team on daily calls and get a named mentor. Core hours are 9:00 AM to 1:00 PM US Eastern. Most communication happens in Slack, with short video calls when needed.

What you'll do

• Analyse funnel drop-offs and summarise findings in a one-page note.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Track marketing campaign results using Google Analytics 4 data.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Maintain the data dictionary and keep dashboard filters up to date.

What we're looking for

• Currently enrolled in a bachelor's or master's degree, graduating 2026, 2027 or 2028.
• Eligible to work in Switzerland.
• Available for the full internship period.
• Based in Switzerland for the duration of the internship.
• Clear written English for reports and status updates.
• A sample dashboard or analysis project you can share.
• Basic SQL, enough to write SELECT queries with joins and filters.

Preferred

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

Duration: 5 months

Start date: Dec 2026

Stipend: CHF 3,500-CHF 4,700/month

Perks

• Flexible hours.
• Possibility of a full-time offer.
• Certificate of completion.
• Company laptop.

Duration: 5 months. Start: Dec 2026.

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