STAGE- EMEA Sourcing Transportation Data Analyst H/F

Stage
Créteil
Salaire : Non spécifié
Expérience : < 6 mois
Éducation : Bac +5 / Master
Postuler

EssilorLuxottica France
EssilorLuxottica France

Cette offre vous tente ?

Postuler
Questions et réponses sur l'offre

Le poste

Descriptif du poste

 

 

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

  • 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

 

 Data Cleaning, Structuring & Standardization

  • 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

 

 RFQ Offer Analysis & Scenario Modeling

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

 

 Dashboard Development

  • 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

 

 


Profil recherché

Description du profil :

 

TECHNICAL SKILLS - PORTRAIT OF A PERFECT CANDIDATE

   

  • Excel Expertise: Power Query, Power Pivot, advanced formulas, data structuring.
  • Data Visualization: Power BI, Tableau, or similar tools for dashboard creation.
  • 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.

Envie d’en savoir plus ?

D’autres offres vous correspondent !

Ces entreprises recrutent aussi au poste de “Données/Business Intelligence”.

Voir toutes les offres
Postuler