Job objectives:
- 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.

Role & responsibilities

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 cooperative 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 for Visualisation (e.g., Power BI) or Advanced Analytics (e.g. Data Science models/Optimization engines)
- Business Translation: Previous experience in contextualizing requirements with business stakeholders and translating those needs into clean, technical code.

Job description:
- Translat

📌 LOreal is Hiring For GCP Data Engineer with Gen Ai (Hyderabad)
🏢 Loreal India
📍 Hyderabad