Indietro
Tempo Indeterminato
Mexico City
Estado de México
Tech
Full - Time
13-mag-2025

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: 

 

  • Design and maintain data structures that reflect business rules and workflows.
  • Ensure consistency and traceability between raw, curated, and semantic layers.
  • Translate business requirements into structured technical and logical models
  • Document relationships, transformation logic, and field definitions clearly.
  • Validate data across layers using rule-based tests and SQL checks.
  • Participate in defining granularities, hierarchies, and transformation points.
  • Support product and engineering teams with business knowledge and modeling expertise.
  • Evaluate and propose integration structures for new data sources.
  • Define and enforce logic for data unification, enrichment, and version control.
  • Ensure model scalability to support analytics, visualization, and automation.

 

What we are looking for:  

 

  • Solid SQL skills and understanding of relational and analytical data modeling.
  • Experience with data transformation tools (dbt, Power BI modeling, BigQuery).
  • Familiarity with process mapping and logic structuring tools.
  • Ability to translate functional logic into technical data designs.
  • Strong documentation skills and attention to logic clarity.
  • Problem-solving mindset, comfortable working with ambiguity and evolving logic.
  • Business-to-technical translation ability, communication across diverse technical teams.
  • Team player with good collaboration habits across business and tech roles.

 

Years of experience required:
4-6 years in data-related roles, ideally 2–3 in a modeling or validation-heavy position. 

 

Tools & Technologies: 

  • SQL (intermediate to advanced)
  • Power BI Data Model or LookML
  • BigQuery or another columnar data warehouse
  • Lucidchart / process mapping tools
  • Google Sheets / Excel (for logic validation)
  • Data documentation platforms (Confluence, dbt docs)

 

Technical knowledge / certifications: 

  • Basic understanding of ELT pipelines
  • Experience with logical modeling and traceability documentation
  • Familiarity with UAT/test case development for data pipelines
  • Solid understanding of business domain data structures

 

 

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. 

 

Candidati ora
  • You can apply to up to three jobs within a rolling 30-day window.
  • You cannot withdraw your application once you applied, so please make sure to choose a job that matches your dreams.
  • Please visit "Your Application Space" to see the jobs you have already applied to.
  • Please don’t create another account with a different email. If you do so, your account might be merged and your application record will be deleted.