Stage- emea sourcing transportation data analyst h/f

Si vous avez déjà porté des lunettes, nous nous sommes déjà rencontrés.

Nous sommes un leader mondial dans la conception, la fabrication et la distribution de verres ophtalmiques, de montures et de lunettes de soleil. Nous offrons à nos partenaires de l’industrie dans plus de 150 pays l’accès à une plateforme mondiale de produits de soins de la vue de haute qualité (tels que la marque Essilor, avec Varilux, Crizal, Eyezen, Stellest et Transitions), des marques emblématiques que les consommateurs adorent (telles que Ray-Ban, Oakley, Persol, Oliver Peoples, Vogue Eyewear et Costa), ainsi qu’un réseau qui offre aux consommateurs des soins de la vue de haute qualité et des expériences d’achat de premier ordre (tels que Sunglass Hut, LensCrafters, Salmoiraghi & Viganò et le réseau GrandVision), et des plateformes de e-commerce de premier plan.

Rejoignez notre communauté mondiale de plus de 190 000 employés dévoués à travers le monde pour conduire la transformation de l’industrie des lunettes et des soins de la vue. Découvrez-en plus en nous suivant sur !

Votre #FutureInSight avec EssilorLuxottica

Êtes-vous prêt à explorer de nouveaux horizons, à favoriser l’inclusivité et la collaboration, l’agilité, à éveiller la passion et à avoir un impact positif sur le monde ?

Rejoignez-nous pour redéfinir les limites de ce qui est possible !

Job location : Créteil France

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:

Data Discovery, Acquisition & Understanding

1. 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.
2. Clarify carrier-specific terminology and map rate structure

Data Cleaning, Structuring & Standardization

3. Clean inactive or irrelevant accounts and align them with shipment data
4. Standardise data using Excel Power Query, SQL, or Python

Baseline Simulation

5. Build cost simulation models that replicate real-world carrier billing logic

RFQ Offer Analysis & Scenario Modeling

6. Process 2–3 rounds of RFQ responses and standardise rate structures.

Dashboard Development

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

8. Excel Expertise: Power Query, Power Pivot, advanced formulas, data structuring.
9. Data Visualization: Power BI, Tableau, or similar tools for dashboard creation.
10. Programming (Preferred): Python or SQL for larger-scale data manipulation.
11. Modeling: Experience in cost simulation and billing logic modeling
12. Analytical Acumen: Ability to identify trends, outliers, and insights from complex datasets.
13. Attention to Detail: Precision in handling millions of rows and hundreds of files across EMEA
14. 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:

15. Data Volume: Demonstrated experience handling datasets with 1,000+ files and 1M+ rows.
16. Industry Background in transportation or logistics—preferably express (UPS, DHL, FedEx).
17. Functional Expertise: Involvement in carrier tenders, invoicing audits, or pricing analysis.
18. 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.