For more than a century, L’Oréal has devoted its energy, innovation, and scientific excellence solely to one business: Beauty. Our goal is to offer every person around the world the best of beauty in terms of quality, efficacy, safety, sincerity and responsibility to satisfy all beauty needs and desires in their infinite diversity.  

At L'Oréal, our IT teams design and build solutions to ensure high performance for all our business sectors by imagining new ways of doing things, from designing websites to building algorithms and predicting new trends. They can be found leading teams towards a more connected and digitalized future in IT retail, e-commerce, CRM, data, AI, cybersecurity, Cloud and E-Marketing. You never stop learning at L'Oréal IT because things change at the speed of light! Come join our dynamic team! 

What you will do: 

• Create and maintain interactive BI dashboards, reports, and visualizations to present complex data in an accessible format. 
• Design and implement effective data visualizations, ensuring clarity and user-friendliness. 
• Work closely with business users and analysts to understand their needs and translate them into technical requirements. 
• Focus on creating intuitive and engaging user interfaces for BI applications through User Experience (UX) & User Interface (UI) design. 

What we are looking for:  

• 4+ years of experience in BI development 
• Proficiency in creating Power BI reports, dashboards, and visualizations. This includes data modeling, DAX (Data Analysis Expressions) for calculations, creating calculated measures, columns, and tables with a focus on report performance.

• Strong understanding of relational data models and dimensional modeling concepts. Ability to design efficient and effective data models for BI reports.
• Understanding of various data sources and how to connect to them (databases, APIs, cloud services, flat files, etc.).
• Excellent knowledge of SQL for querying and preparing data. 
• Experience with Google Cloud Platform (GCP), and relevant services such as BigQuery, Cloud SQL.
• Understanding of data warehousing principles and how they relate to BI development. 
• Familiarity with ETL tools and processes. 
• Experience with web development frameworks like React, Angular, JavaScript a plus

Business Intelligence and Domain Expertise: 

• Background in CPG/Retail or eCommerce background with an understanding of the industry's key performance indicators (KPIs), such as sales growth, market share, customer lifetime value, etc.
• Experience working with business stakeholders to gather requirements and translate them into clear technical specifications for BI solutions.
• Contributing to the development of BI strategies and roadmaps within the organization and helping to shape the direction of BI development

Don’t meet every single requirement? At L'Oréal, we are dedicated to building a diverse, inclusive, and innovative workplace. If you’re excited about this role but your past experience doesn’t align perfectly with the qualifications listed in the job description, we encourage you to apply anyways! You may just be the right candidate for this or other roles! 

We are an Equal Opportunity Employer and take pride in a diverse environment. We would love to find out more about you as a candidate and do not discriminate in recruitment, hiring, training, promotion, or other employment practices for reasons of race, color, religion, gender, sexual orientation, national origin, age, marital or veteran status, medical condition or disability, or any other legally protected status.