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: 

• Define, evolve and manage scalable, reusable data models across domains.
• Translate complex business rules into structured data models and logic.
• Design data flows and layer structures that enable end-to-end traceability.
• Ensure that data models align with GCP platform standards and business logic.
• Lead modeling practices for key datasets across domains like sales, supply, and marketing.
• Design optimal structures for key datasets aligned to business use cases.
• Document the full data lifecycle, including transformations, hierarchies, and table relationships.
• Establish modeling principles for partitioning, naming conventions, and update strategies.

• Collaborate with engineers and product owners to co-create efficient data structures.
• Audit data assets to identify improvement opportunities in logic, scalability, or usability.
• Participate in data validation processes by proposing test cases from business logic.

What we are looking for:  

• Strong expertise in data modeling (star schema, snowflake, normalized).
• Proficiency in SQL for validation, profiling, and building complex logic.
• Experience with modeling tools like dbt.
• Knowledge of cloud architecture, preferably GCP.
• Deep understanding of business processes and how they translate into data design.
• Ability to think in systems and abstract complex rules into scalable data logic.
• Strategic mindset with the ability to guide and mentor analysts and engineers.
• Strong communication skills to align business, product, and technical teams.
• Attention to detail and a structured, logical approach to information design.

Years of experience required:
6-9 years total, with at least 4–5 years in data modeling, business logic integration, or enterprise information architecture. 

Tools & Technologies: 

• SQL (advanced)
• dbt, Dataform, or equivalent modeling tools
• BigQuery (data structure level)

• Lucidchart, ER/Studio, or UML tools
• Confluence, Jira for documentation
• Metadata tools (e.g., Data Catalog, Alation)

Technical knowledge / certifications: 

• Strong understanding of star/snowflake schema
• Experience with enterprise data models and domain-driven design
• Knowledge of data architecture and GCP pipelines
• Familiarity with business rules translation into data logic

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.