Fonction professionnelle: Information Systems

Type de poste: Permanent

Type de contrat: Full - Time

Site: Montréal

Pays: Canada

Business Intelligence Analyst, ** Located in Montreal, Canada **

L'Oreal IT - Americas Zone

Who we are:

At L’Oréal, technology is at the heart of our inventions transforming the future of Beauty. Behind all of our innovations and technological advances are a great bunch of people working together to make sure we stay ahead of the game. We are a team of savvy tech experts to keep L’Oréal systems up and running making information easily accessible and customized to all 32 iconic brands worldwide.

What you'll do:

As a Business Intelligence analyst in the Business Intelligence (BI) Zone team, you will work on the support and implementation of the BI solution in Canada. You will be responsible for developing new features (reports, measures, dimensions, etc...) to the solution as well as maintain the entire solution, ensuring proper production (solving issues, answering users’ doubts, etc...).

You will be involved in planning the new BI solution for the zone (cloud + big data), with great opportunity to learn new technologies.

What you'll need:

-Bachelors Degree in Computer Science or related field
-Up to 5 years relevant experience

Technical Skills:

Must haves:

SQL Server

  • Create SP, view, tables...
  • Performance tuning


  • At least 2008 version
  • Create dimensions, cubes, calculated measures.
  • MDX
  • Administration
  • Multidimensional and tabular
  • Create reports on SSRS connected to cubes, tables, etc...
  • Experience on any ETL tool (Microsoft, Oracle, etc.)

 Nice to haves:

Power BI

  • Importing data from various data sources (PowerQuery)
  • Modeling
  • Create reports
  • SAP integration
  • File to SQL
  • SQL to SQL