Europe's oldest youth
mobility programme

Traineeship

Traineeship title: Data Analyst Intern

Reference: N152728/20/CATALUNYA
Hosting period start: 01/05/2026
Hosting period end: 30/10/2026
Region
Catalonia
Country
Spain
Traineeship start date:
01/06/2026
Traineeship end date:
30/10/2026
Traineeship Duration:
Approximately 5 months
Deadline
08/04/2026
Work Schedule
Work Schedule: From 09:00am to 05:00pm (1 hour of break)

Monday to Friday in hybrid mode.
Location
Passeig de Gràcia, 54, 08007, Barcelona
Traineeship Area:
IT and Telecommunications
Period and duration of the language course:
Group 1 - 2026:
- Hosting period: 1/5/2026 - 30/10/2026
- Linguistic course and cultural activities: 1/5/2026 - 31/5/2026 at:
https://xanascat.gencat.cat/ca/albergs/albergs/barcelona-xanascat
- Internship period: 1/6/2026 - 30/10/2026

Group 2 - 2026:
- Hosting period: 1/8/2026 - 31/12/2026
- Linguistic course and cultural activities: 1/8/2026 - 30/8/2026 at:
https://xanascat.gencat.cat/ca/albergs/albergs/barcelona-xanascat
- Internship period: 31/8/2026 - 31/12/2026
Practical Information
Xanascat Youth Hostel
How to get there:
By plane: From Barcelona-El Prat Airport, you can take the Aerobús (A1 or A2) towards ‘Plaça Catalunya’. From there, take bus 22 towards El Carmel to the stop Pg Mare de Déu del Coll – Cartago, right in front of the hostel.

By train: From Sants Estació, you can take the metro (green line; L3) to Vallcarca, exit via the elevator on Av. República Argentina. Then, take bus line 22 towards ‘El Carmel’ at stop 2800 Av. República Argentina-Vallcarca to stop 848 Pg Mare de Déu del Coll, in front of the hostel.

Other buses: After 22:50, bus 22 is replaced by the night bus N-5.
Rooms and meals At the hostel, you will share a room with other participants of the Eurodyssey program. You will have access to clean sheets and towels every week. Laundry for your personal clothes is not covered by the program.

During your stay at the hostel, breakfast (8:00 – 9:00), lunch (13:00 – 14:00), and dinner (19:00 – 20:30) are included. You must inform us before arrival if you require a special diet.
Includes Trips
No
Description of the tasks to be undertaken by the trainee(s):

Data Extraction & Querying: Utilize SQL to extract, manipulate, and analyze data from internal databases to support business decision-making.

Reporting & Visualization: Build, maintain, and automate dashboards using Google Sheets, ensuring data accuracy and clarity for cross-departmental stakeholders.

Statistical Analysis: Apply mathematical and statistical models to identify trends, patterns, and anomalies in sales and operational data.

Operational Support: Work closely with the Sales and Operations teams to translate business questions into technical data requirements.

Data Cleaning: Perform regular audits of data records to ensure the integrity and validity of information across all platforms.

Continuous Improvement: Propose new ways to optimize data collection and reporting workflows.

Profile of the Trainee

Qualifications

It is desirable to have or be pursuing studies in Mathematics, Statistics, Data Science, Computer Science, Economics, or a related quantitative field.

Personal and Social Skills

A fast learner who is curious and willing to become an important asset in the company, learning from our Managers in a data-driven role.

You are a passionate, hard-working, and methodical person who is excited to join a mission-driven team.

You communicate, summarize, and report complex data simply and clearly, feeling comfortable presenting to all types of profiles.

You like teamwork and are willing to help others, but you are also independent, self-sufficient, and disciplined with deadlines.

You are proactive and always look for the "why" behind the numbers.

Language Skills

English (Fluent).

Spanish would be an important plus.

Information Technology (IT) Skills

Google Spreadsheets Intermediate: Knowledge of pivot tables, able to craft complex formulas (VLOOKUP/INDEX-MATCH, QUERY, ARRAYFORMULA), and data visualization.

SQL (Intermediate-Junior): Solid understanding of relational databases. You should be comfortable writing queries to extract data (SELECT, FROM, WHERE), import/export datasets, and clean/filter information to make it usable. Knowledge of JOINs to cross-reference data from different tables is essential.

Google Environment: (Google Sheets, Drive, Calendar).

Database Management: Experience with SQL workbenches or cloud data warehouses (BigQuery, PostgreSQL, etc.) is highly valued.

Other Skills

Mathematical Foundation: Strong understanding of probability, statistics, and logical reasoning.

Other Skills

Language Competences
Understanding
Speaking
Language
Listening
Reading
Spoken Interaction
Spoken Production
Writing
English
C1
C1
C1
C1
C1
Spanish
B2
B2
B2
B2
B2