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

📌 Business Analyst Lead (Estado de México)
🏢 L'Oréal
📍 Estado de México