Data Analyst Intern

We handle millions of shipments a year across truck, rail, ocean and air.

Internship overview

Wrenstack Logistics is hiring a Data Analyst Intern for Sep 2027. Wrenstack Logistics needs a data analytics intern to build reports and dashboards for the Analytics team. Our headquarters is in Zürich, and about a third of the team works remotely from other countries. You will intern remotely with our team in Zürich. We have hosted remote interns from several countries before. Core hours are 10:00 to 15:00 CET.

Responsibilities

• Answer ad hoc data requests from sales and support within a day or two
• Create charts and short slide decks for the monthly review call
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Track marketing campaign results using Google Analytics 4 data
• Build and update dashboards in Power BI, Tableau or Looker Studio
• 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 you are

• Currently enrolled in a bachelor's or master's degree, graduating between December 2027 and June 2028
• Eligible to work in Israel
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in between December 2027 and June 2028
• Clear written English for reports and status updates
• Basic SQL, enough to write SELECT queries with joins and filters
• A sample dashboard or analysis project you can share

Preferred qualifications

• Familiarity with DAX in Power BI
• Knowledge of basic statistics such as medians, percentiles and correlation

What you get out of it

• Presenting numbers in a way non-technical people can act on
• You will build at least one dashboard that managers use every week
• How business metrics like CAC, churn and retention are actually calculated

Program dates: Sep 2027, 10-12 weeks.

Pay: ₪14,000 - ₪19,000/month

What we offer

• Company laptop
• Paid public holidays
• Online learning budget
• Mentorship

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

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Wrenstack Logistics GmbH.