Semantic Modeler – Data & AI

About the Position

Unleash Your Potential at L'Oréal's Beauty Tech!

For 115 years, L’Oréal, the world’s leading beauty player, has devoted itself to one thing only: fulfilling the beauty aspirations of consumers around the world. Today, L’Oréal includes more than 2,000 tech professionals and is constantly growing. Beauty Tech is changing the game and leading the shift towards new consumer realities and a digital disruption. Championing Beauty Tech, we invent the beauty of the future while becoming the company of the future.

We are currently seeking a Semantic Modeler – Data & AI to join our team in Hyderabad, Telangana.

Responsibilities

• Architect and own the Universal Semantic Layer, ensuring it serves as the single source of truth for all reports, self-service, and AI/ML initiatives.
• Enable AI Agency: Build the metadata "map" that allows AI Agents and LLMs to understand, browse, and analyze enterprise data with high precision and trust.
• Democratize Data Access: Design a self-service environment where non-technical business users can explore data using business terms rather than complex SQL.
• Ensure Cross-Project Consistency: Align the semantic definitions used in traditional BI reporting with the features used in AI/ML model training to prevent "metric drift".
• Standardize Semantic Governance: Define the workflows for how new metrics are proposed, validated, and deployed into the enterprise semantic layer.

Requirements

• 10+ years of experience in Data Architecture, Software Engineering, or Information Management, with a specialized focus on building scalable semantic layers and metric stores.
• Extensive experience with Semantic Layer Technologies: Proficiency in tools like Looker (LookML)/dbt Semantic Layer/Cube/AtScale/Power BI (Tabular/DAX).
• Deep understanding of Data Modeling methodologies: Expert knowledge of Data Vault 2.0, Star Schema (Kimball), and Knowledge Graph/Ontology modeling.
• GCP Ecosystem Mastery: Proven experience architecting solutions on GCP, leveraging BigQuery, Dataform, Analytics Hub, and Dataplex.
• AI/Agent-Ready Modeling: Practical experience in structuring metadata for LLM consumption (RAG), ensuring that AI Agents can accurately navigate & query enterprise data without "hallucinating" business logic.
• Architectural Pattern Expertise: Understanding of Data Mesh and Data Fabric principles and how to implement “Headless BI" architecture.
• API & Integration Skills: Experience exposing semantic models via GraphQL, SQL, or REST APIs for consumption.
• Advanced Data Governance: Deep knowledge of metadata management, data lineage, and the ability to implement row-level and column-level security within the semantic layer.
• Excellent Communication: Ability to reconcile business definitions across departments and codify them into a single technical logic.

Nice to Have

• Bachelor’s degree in computer science OR related technical degree OR equivalent experience

We Offer

• Working with cutting-edge technology, empowering employees with new age learning, global exposure, and opportunities to build future-ready careers.
• A flexible and modern workplace, enabling teams to perform at their best through a smart hybrid model that supports balance and autonomy. A 3 Day in Office, 2 Day Work from Home setup.
• Employee support at every life stage, with inclusive and progressive parental policies that help individuals and families thrive.
• Holistic wellbeing offerings - personalized health benefits and strong mental wellness support to ensure employees feel their best.
• Reward and Recognition opportunities, long-term incentives, and opportunities to share in L’Oréal’s collective success.
• L'Oréal is an Equal Opportunity Employer and takes pride in a diverse environment.

About the Company

For more than a century, L’Oréal has devoted itself solely to one business: Beauty. Present in 150 countries across five continents and with €42 billion consolidated sales, L'Oréal is the global industry leader. With 37 global beauty brands across four divisions, L’Oréal offers beauty for each covering all beauty categories and catering to all beauty desires. With the acquisition of the Australian brand Aēsop in 2023, the Group continues to expand its portfolio through targeted acquisitions as part of its drive to create the future of beauty.

Good to Know: The Recruitment Process

1. Interview with HR
2. Technical Interview
3. Interview with the hiring manager

We would love to find out more about you as a candidate and we do not discriminate in recruitment, hiring, training, promotion, or other employment practices. The beauty we find in our differences gives us the freedom to go beyond. That’s the beauty of L’Oréal.