> Markdown version of [/jobs/ext/4320875-dir-cloud-data-engineering-ai-tech-lead](https://www.wearedevelopers.com/jobs/ext/4320875-dir-cloud-data-engineering-ai-tech-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Dir - Cloud Data Engineering & AI Tech Lead - **Company:** Loreal - **Location:** New York, NY, United States (Remote available) - **Experience:** Expert - **Salary:** $138,500 - $200,800 - **Contract:** Permanent contract - **Skills:** AI Evaluation, Application Programming Interfaces (APIs), Agile Methodology, Artificial Intelligence, Airflow, Data Analysis, Business Logic, Business Intelligence Development, BigQuery, Cloud Database, Cluster Analysis, Code Review, Continuous Integration, Data Architecture, Information Engineering, Extract Transform Load (ETL), Data Security, Data Structures, Data Systems, Data Flow Control, Python (Programming Language), Metadata, Performance Tuning, Scrum Methodology, Query Optimization, Power BI, Cloudera, SQL Databases, Data Streaming, Tableau (Software), Unstructured Data, Web Applications, Enterprise Data Management, Google Cloud, Google Data Studio, ReactJS, Retrieval-Augmented Generation, Large Language Models, Multi-Agent Systems, Prompt Engineering, Generative AI, Agentic-AI, Data Layers, Containerization, Kubernetes, Google Cloud Functions, Star Schema, Data Management, Restful APIs, Semantic Modeling, Terraform, Looker Analytics, Data Pipelines, Docker - **Published:** October 23, 2026 - **Apply:** https://diversityjobs.com/career/18715768/Dir-Cloud-Data-Engineering-Ai-Tech-Lead-New-York-New-York ## About the Role * 7+ yearsof experience in data engineering, data architecture, analytics engineering, or related technical roles. * 4+ years of hands-on GCP experience, designing and implementing production-grade data solutions. * Strong hands-on expertise in: + BigQuery + SQL + Python + Dataflow and/or Dataproc + Pub/Sub + Cloud Composer + Cloud Run and/or Cloud Functions + Terraform and CI/CD toolchains * Strong experience designing and optimizing enterprise data models, ETL/ELT pipelines, and data platforms for structured, semi-structured, and unstructured data. * Proven experience with BigQuery performance tuning, partitioning, clustering, cost optimization, and secure data-access controls. * Strong proficiency in Looker semantic modeling, including governed metrics, explores, reusable dimensions, and consistent business definitions. * Demonstrated hands-on experience implementing AI-enabled data solutions, such as RAG, AI agents, Text-to-SQL, LLM-powered analytics, or conversational data experiences. * Experience developing secure and scalable APIs or services using Python and containerization technologies such as Docker and Kubernetes. * Experience working in Agile delivery environments and translating business needs into actionable technical requirements. * Strong communication, collaboration, and technical problem-solving skills. * Work authorization on a continuous, ongoing basis. Sponsorship is not offered for this role. Preferred Qualifications: * Strongly preferred:Experience working with Commerce data domains, including related data structures, metrics, reporting, and operational processes. * Experience with Power BI, DAX, Tableau, Looker Studio, or other enterprise BI and visualization platforms. * Experience with AI evaluation, prompt engineering, LLM observability, model safety controls, or responsible AI data-governance patterns. * Google Cloud Professional Data Engineer certification. * Exposure to ReactJS or development of lightweight internal web applications., If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability. You can request reasonable accommodations by contactingUSApplicationAccommodation@support.lorealusa.com. If you need assistance to accommodate a disability, you may request an accommodation at any time. ## Description L'Oreal is driving a massive Beauty Tech Transformation roadmap, designing and implementing next-generation Data Products to accelerate business growth across Commerce and Supply Chain. As a Tech lead, you will design, build, and optimize scalable, secure, and reusable data products on Google Cloud Platform. You will combine strong hands-on data engineering expertise with practical AI engineering experience to make governed enterprise data available for analytics, reporting, and natural-language insight experiences. You will work closely with Data Architects, BI Developers, Data Scientists, Product teams, and business stakeholders to build reliable data foundations, standardize metric definitions, and enable trusted data access. This role requires strong technical ownership, a hands-on delivery mindset, and the ability to mentor engineers while driving engineering standards. What You Will Do * Design, build, and maintain scalable, reusable, and cost-efficient data pipelines and data products on Google Cloud Platform. * Develop resilient ETL/ELT pipelines supporting batch, near-real-time, and streaming data workloads across a modern Medallion architecture. * Build and optimize enterprise data models, including dimensional models and Star/Snowflake schemas. * Design and implement solutions using BigQuery, Dataflow, Dataproc, Pub/Sub, Cloud Composer, Cloud Functions, Cloud Run, Workflows, and Terraform. * Optimize BigQuery performance, cost, reliability, and governance, including partitioning, clustering, query optimization, row-level security, and column-level security. * Build reusable APIs, services, and engineering utilities using Python, Docker, Kubernetes, Cloud Run, and CI/CD pipelines. * Partner with Data Architects, BI Developers, Data Scientists, and business stakeholders to translate business requirements into scalable, maintainable technical solutions. * Support the development and optimization of governed semantic layers and standardized business metrics in Looker and other reporting environments. * Establish and promote best practices for data quality, testing, observability, documentation, metadata, lineage, deployment, and operational support. AI-Enabled Data Engineering * Turn governed data into clear, natural-language answers that enable teams to explore insights safely and efficiently. * Design, build, and optimize Skills, AI Agents, and conversational workflows that translate business queries into accurate and understandable insights. * Develop and operationalize AI-enabled patterns such as Retrieval-Augmented Generation (RAG), Text-to-SQL, agentic workflows, and tool-based AI orchestration. * Connect governed BigQuery datasets and the Looker semantic layer to AI-enabled solutions, ensuring consistent metric definitions and trusted business logic. * Build robust tools, workflows, guardrails, monitoring, and evaluation frameworks to reduce hallucinations, improve answer quality, and help prevent unauthorized data exposure. * Partner with Data Science and AI teams to productionize AI and machine learning use cases by building reliable, governed, and scalable data foundations. Agile Delivery & Technical Leadership * Translate broad business epics into clear, developer-ready technical stories, tasks, and acceptance criteria. * Participate actively in Agile ceremonies, backlog refinement, sprint planning, design reviews, and iterative delivery. * Provide technical leadership through architecture reviews, engineering standards, code reviews, and delivery guidance. * Mentor Data Engineers and partner teams, supporting their technical growth and consistent adoption of engineering best practices.