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: 

The Business Analyst role is essential for delivering a successful data product. Bridging IT and business needs, this role translates business requirements into technical specifications using data analysis and profiling, ensuring value delivery. 

. 

• Collaborate with cross-functional teams (marketing, supply chain, product, analytics engineering, architecture) to translate business needs into reusable, scalable data structures.
• Work with the product owner to understand KPIs and reverse engineer data mapping for the engineering team.

• Collaborate with the data architecture team to design optimized data schemas for data products.
• Lead data discovery, document findings, and advise on enhancing use cases with new datasets.
• Perform exploratory data analysis (EDA) to identify data trends, patterns, and anomalies.
• Analyze business rules and map data fields from various sources, ensuring accurate data transformation.
• Participate in data validation processes by proposing test cases from business logic.
• Establish a bridging role between the product owner and development team, abiding by Agile development principles
• Encourage effective communication and collaboration between the Development Team, Product Owner, and stakeholders to foster a collaborative and empowered team environment.

What we are looking for:  

• 4+ years of experience developing and implementing data applications in mid-size to large companies.
• Highly detail-oriented and organized with exceptional documentation skills.
• Proficient in SQL for data extraction and manipulation.
• Skilled in manipulating large datasets using tools like DBT.
• Expertise in data modeling and analysis techniques.
• Experience with data visualization tools like Tableau, Power BI, and Looker Studio.
• Experience with Google Cloud Platform (GCP) services, including BigQuery, Cloud Storage, and Cloud SQL.
• Experience working with Agile principles in a Scrum environment.
• Strong analytical and problem-solving skills.
• Ability to communicate effectively with both technical and non-technical stakeholders.

• Proactive, self-starter with an interest in development processes.

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.