STAGE- EMEA Sourcing Transportation Data Analyst H/F

Luxottica; Créteil; Sur place; EUR 40 000 - 60 000; Plein temps

Résumé du poste

A leading global eyewear company based in Île-de-France is seeking a Sourcing Transportation Data Analyst. This role involves leading the data workstream for an international express tender project, focusing on data analysis, cost simulation, and dashboard creation. The ideal candidate will have expertise in Excel and experience with data manipulation using Python or SQL. This position offers an opportunity to work within a multicultural team and manage extensive transportation data across EMEA.

Qualifications

• Degree Bac+5/Bac+6 required in a relevant field.
• Experience in transportation and/or logistic sourcing is a plus.
• Strong analytical thinking and attention to detail.

Responsabilités

• Lead data workstream of an international express tender project.
• Analyze large volumes of transportation data for cost optimization.
• Build cost simulation models and interactive dashboards.

Connaissances

Excel Expertise

Python

SQL

Analytical Acumen

Attention to Detail

Data structuring

Formation

Degree in Data Science, Logistics, Business Analytics, Supply Chain Management, or related fields

Outils

Power Query

Power BI

Tableau

Description du poste

STAGE- EMEA Sourcing Transportation Data Analyst H/F

Desired starting date : Feb / march 2026

Desired duration : 6 month

Potential travels : Yes

JOB SCOPE AND MAIN RESPONSIBILITIES:

We are looking for a highly analytical and technically proficient Sourcing Transportation Data Analyst to lead the data workstream of a large-scale international express tender project. This role spans the full lifecycle of a complex RFQ process, from data acquisition and cleaning to cost simulation, scenario modeling, and dashboard development.

The ideal candidate will work closely with sourcing, logistics, and technical teams to manage and analyze large volumes of transportation data, optimize cost structures, and provide decision‑making support through insightful visualizations and modeling.

AREAS OF RESPONSIBILITIES AND RELATED ACTIVITIES:

• Define RFQ analysis objectives, catalogue and evaluate over 2,000 Excel sheets of rate cards, analyse 12 months of shipment and financial data for 600+ accounts.
• Clarify carrier‑specific terminology and map rate structure
• Clean inactive or irrelevant accounts and align them with shipment data
• Standardise data using Excel Power Query, SQL, or Python

Baseline Simulation

• Build cost simulation models that replicate real‑world carrier billing logic
• Process 2–3 rounds of RFQ responses and standardise rate structures.
• Build an interactive dashboard (Power BI/Tableau)

NETWORK OF INTERACTION:

INTERNAL : Logistics, Transportation, Supply Chain, Legal, Controling, External consultancy and IT

EXTERNAL : Transportation and logistic suppliers across EMEA

TECHNICAL SKILLS - PORTRAIT OF A PERFECT CANDIDATE

• Excel Expertise: Power Query, Power Pivot, advanced formulas, data structuring.
• Programming (Preferred): Python or SQL for larger‑scale data manipulation.
• Modeling: Experience in cost simulation and billing logic modeling
• Analytical Acumen: Ability to identify trends, outliers, and insights from complex datasets.
• Attention to Detail: Precision in handling millions of rows and hundreds of files across EMEA
• Previous experience in transportation and/or logistic sourcing is a plus

CANDIDATE PROFILE:

Responsible and autonomous, known for strong analytical thinking and attention to detail. Must be methodical and have a challenging mindset.

Preferred Qualifications:

Degree in Data Science, Logistics, Business Analytics, Supply Chain Management, or related fields.

Preferred Experience:

• Data Volume: Demonstrated experience handling datasets with 1,000+ files and 1M+ rows.
• Industry Background in transportation or logistics—preferably express (UPS, DHL, FedEx).
• Functional Expertise: Involvement in carrier tenders, invoicing audits, or pricing analysis.
• Familiarity with international express service pricing structures

Educational Background: Bac+5/Bac +6

LANGUAGES: fluent English but in a multicultural team, any others additional language is a plus.