Data Warehouse Developer Intern (M / F)

  • Jaeger LeCoultre
  • The Path, VD
  • 24/12/2021
Full time Data Science Data Analytics Statistics Data Warehouse

Job Description

Reference code: 48765

Data Warehouse Developer Intern (M / F)

Le Sentier, VD, CHTrainee/Intern

Since its creation, Jaeger-LeCoultre has made precision an art in its own right, finding the perfect balance between cutting-edge know-how and artistic sense, sophistication and aesthetic finesse. Faithful to the spirit of invention initiated in 1833 by its founder Antoine LeCoultre, the craftsmen of the Manufacture create collections at the cutting edge of Haute Horlogerie: Reverso, Master, Jaeger-LeCoultre Polaris, Rendez Vous and Atmos - this rich heritage built by the Grande Maison over the centuries is a constant source of inspiration that never ceases to push the limits through unprecedented timepieces.

THE INTERNSHIP

For our Manufacture located in Le Sentier (Vallée de Joux - Canton of Vaud), within the Operations Department and directly attached to the Information System & Organization department, you will be in charge of the study and development of processes aimed at integrating new data into a Data Warehouse. These will then make it possible to set up new performance indicators (KPIs) in connection with supplier quality. To do this, you will be in continuous dialogue with a business expert who will be able to both describe their own needs and assist you in developing these new indicators.

The key stages of the project:

  • User needs study
  • Study of the existing Data Warehouse, the model used and its operation
  • Design of the planned solution and new KPIs
  • Development of the chosen solution with the Talend tool
  • Integration of new data and development of indicators on a BI tool

Skills developed during the internship:

  • Analytical capacity and technological watch
  • Data Warehouse Development
  • Relational capacity: listening, dialogue and autonomy
  • Critical sense and strength of proposal

Tools and concepts covered:

  • Datawarehouse et de Data Lake
  • ETL (Talend, Informatica)
  • Databases (SQL Server, IBM AS400)
  • BI tools (PowerBI, Data Studio, Looker)
  • Modélisation Data Warehouse (Inmon, Kambell, Data Vault)
  • Languages: SQL and Java

YOUR PROFILE

During your Bachelor or Master course, communication and teamwork are your strengths. The ability to analyze and take a step back are also desirable qualities. A mastery of the Office package is necessary, in particular Excel.