Who Are We

For 115 years, LOral, the worlds leading beauty player, has devoted itself to one thing only: fulfilling the beauty aspirations of consumers around the world.

For more than a century, LOral has devoted itself solely to one business: Beauty.Presentin 150 countries across five continents and with 42 billionconsolidatedsales, L''Oral is the global industry leader.With37 global beauty brandsacross four divisions,LOral offersbeauty for eachcoveringall beauty categories and cateringto all beauty desires.With the acquisition of the Australian brandAsopin 2023, the Group continues to expand its portfolio through targeted acquisitions as part of its drive tocreate the future of beauty.

Today, LOral includes more than2,000 tech professionalsand is constantly growing.Beauty Tech is changing the game and leading the shifttowardsnew consumer realities andadigitaldisruption.Championing Beauty Tech, we invent the beauty of the future while becoming the company of the future.

Beauty Tech is how we know our consumers intimately, augmenting their beauty journeys with unparalleled diverse and sustainable experiences. Beauty Tech equips the Group with the key assets it needs to conquer this new world, where Tech has become strategic. With this ambition, LOral continues to recruitdiverse,innovative,skilledandpassionateminds in different tech domains such asData, Digital, Cloud, Cyber Security, IT Architecture, DevOps,Applicationsand Infrastructure.

A Day in the Life of A Senior Analytics Engineer Data Analytics !

Data Transformation: Architect and build the "Transformation Layer" in BigQuery, turning raw data into high-quality, usable datasets for advanced analytics use cases.
Support Advanced Analytics: Collaborate with Data Scientists and Analysts to create specialized datasets for predictive modelling, optimization projects, and executive dashboards.
Ensure Data Trust: Implement testing and documentation within the transformation pipeline to ensure data accuracy and reliability across the SAPMENA region.

Strategic Bridge: Act as the technical translator between business-facing teams and the raw data infrastructure.

In this role, You will..

Translating Business Context into Code: Collaborate with business stakeholders across North Asia and SAPMENA to understand the "Why" behind data requests. You will be responsible for translating these business contexts into robust technical logic.
Building Advanced Analytics Datasets: Design and develop the logic that transforms raw BigQuery data into curated datasets. These datasets will power high-impact use cases, including machine learning models, optimization engines, and strategic dashboards.
Modeling for Performance: Apply best practices in data modelling to ensure that transformed datasets are not only accurate but also performant and cost-effective within the BigQuery environment.
Engineering Excellence: Move analytics beyond "just scripts" by applying software engineering principles. This includes using Git for version control, writing data tests to catch upstream changes, and documenting the lineage of datasets.
Collaborative Integration: Work closely with the Visualization team and Data Science teams to ensure the data marts you build are seamlessly integrated into their specific tools and semantic models.
Framework Adherence: Operate within the BTDP (Beauty Tech Data Platform) framework, ensuring all developments meet LOrals global standards for data security, access management, and architectural integrity.

What are we looking for

Must Have (Core Competencies):

Expert SQL :Mastery of SQL is essential. You must be able to write, debug, and optimize complex queries (CTEs, Window Functions, etc.) to handle large-scale datasets.
Data Modelling :Strong expertise in Dimensional Modelling, Star Schemas, and designing efficient data structures that balance performance with usability.
Modern Transformation Tools: Previous experience with dbt (data build tool) is critical for managing the transformation layer.
Cloud Ecosystem: Experience in developing high performant pipelines leveraging Google Cloud Platform (GCP) and BigQuery architecture.
Version Control (Git): Proficiency in Git and version control best practices to ensure collaborative and auditable code development

Good to Have (Advantageous):

Programming : Proficiency in Python for data manipulation and automating analytical workflows.
DevOps/Infra: Understanding of CI/CD pipelines (Cloud Build) and Infrastructure as Code (Terraform).
Downstream Context:Experience in how data is consumed forVisualisation(e.g., Power BI) orAdvanced Analytics(e.g. Data Science models/Optimization engines)

Business Translation:Previous experience in contextualizing requirements with business stakeholders and translating those needs into clean,

Whats In It for You

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 LOrals collective success.
L''Oreal is an Equal Opportunity Employer and takes pride in a diverse environment

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. Thats the beauty of LOral.

Senior Analytics Engineer - Data & Analytics

Job Description

No Referrers Available