Cargo: Information Systems

Tipo de posição: Permanent

Tipo de emprego: Full - Time

Local: Montréal

País: 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

SSAS

  • At least 2008 version
  • Create dimensions, cubes, calculated measures.
  • MDX
  • Administration
  • Multidimensional and tabular
SSRS
  • 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
Informatica
  • SAP integration
  • File to SQL
  • SQL to SQL

#}