Hello, we’re L’Oréal, We're not just building brands, we're shaping how the world experiences beauty (and it takes a lot of cool jobs to do it). Intrigued? Keep reading, this might be the opportunity you've been searching for.

Internship - Data Analyst, One Data Team

A Day in the Life

Within our central One Data team in Montreal and reporting directly to a team expert, you will play a key role in transforming our data into strategic decisions. Your mission will be to build an end-to-end Power BI dashboard to analyze and visualize the market performance (sell-out) of our brands.

• Data Modeling: You will define and create robust data models (star/snowflake schema) to ensure the performance and relevance of the analyses.
• Power BI Development: You will leverage your mastery of Power BI (DAX, Power Query) to transform raw data into clear and actionable key performance indicators.
• Visualization and Storytelling: You will design aesthetic and user-friendly dashboards that provide a simple and intuitive understanding of business results.
• Business Partnership: You will work in close collaboration with various business teams to understand their needs, ensure the dashboard perfectly meets their requirements, and effectively communicate your analyses.

We Are Looking For

We are looking for a student with a passion for data who wants to make a real impact. You are the ideal candidate if you combine analytical rigor with creativity to turn complex challenges into simple, visual solutions. Your profile includes:

• Business Intelligence Mastery: Advanced proficiency in Power BI (DAX, Power Query) is essential, complemented by strong knowledge of SQL. Experience with Python is a plus.
• Data Modeling: You have solid experience in creating data models and structuring information for analytical purposes.
• Data Visualization: You have a strong UX/UI sensibility to create reports that tell a clear and compelling story.
• Analytical Mindset: You excel at analyzing complex data to extract meaningful business insights.
• Stakeholder Management: You possess excellent communication and collaboration skills.

What’s In It For You

• A place for you to leave your comfort zone and grow beyond your potential (here, you’ll be encouraged to try new things and take risks!)
• Real responsibility from day 1, there’s no sitting on the sidelines at L’Oréal
• An environment where people of every ethnicity, social background, age, religion, gender and sexual orientation as well as people with disabilities are accepted, can speak up, will thrive and are celebrated!
• A place where you can contribute to something bigger! Many of our brands have societal /environmental causes to make concrete difference

Who We Are

Join us at L’Oréal, the world's #1 beauty company present in over 150 markets. For over a century, we have been transforming; fueled by data, tech, innovation, and science. Together, we tackle big challenges while making sure we stay committed to making the world a more inclusive and a better place for everyone & our planet.

Today, L’Oréal includes over 9k experts in beauty tech, digital, data and e-comm and is constantly growing. Championing Beauty Tech, we invent the beauty of the future while becoming the company of the future. To achieve this ambition, L’Oréal continues to recruit diverse, innovative, skilled, and passionate minds in different tech domains such as Data, Digital, Cloud, Cyber Security, IT Architecture, DevOps, Applications, and Infrastructure.

We’re committed to guaranteeing inclusive recruitment processes and to advocating for hiring and promoting each candidate in an ethical and equitable way. The Group strictly prohibits discrimination against any applicant for employment because of the individual’s gender identity or expression, sexual orientation, visible and/or invisible disabilities, socio-economic and/or multicultural origins, health conditions, age, religion, or any other characteristics protected by law.

Want to discover more about L’Oréal Careers? Get the insider tips from L’Oréal recruiters on TikTok @LorealGroupe!