Expert, Analytics Engineering

Relocation Assistance Offered Within Country Job Number #173512 - Mumbai, Maharashtra, India Who We Are Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specialising in Oral Care, Personal Care, Home Care, Skin Care, and Pet Nutrition. Our products are trusted in more households than any other brand in the world, making us a household name! Join Colgate-Palmolive, a caring, innovative growth company reimagining a healthier future for people, their pets, and our planet. Guided by our core values—Caring, Inclusive, and Courageous—we foster a culture that inspires our people to achieve common goals. Together, let's build a brighter, healthier future for all. Brief introduction - Role Summary/Purpose: Designing, building, and maintaining robust and scalable data pipelines to architect and manage data flow; developing and optimizing cloud data warehousing solutions; and translating complex data into clear, actionable visual representations and business insights for stakeholders.  Leading the design and implementation of scalable ELT processes; maintaining data integrity within Snowflake; creating high-fidelity visualizations; and serving as a strategic partner to Business teams  to ensure data infrastructure supports business objectives and data-driven decision-making. Responsibilities: End-to-End Data Engineering Architecting, constructing, and overseeing scalable data pipelines to manage data flow from diverse sources into Snowflake layers. Utilizing dbt for the implementation of sophisticated business logic, ensuring high standards for data quality, lineage, and modularity. Orchestrating complex workflows through Airflow and managing version control via GitHub while adhering to CI/CD best practices. AI Foundation and Modernization Architectural Leadership: Design and implement a Semantic Layer to bridge the gap between complex data schemas and Natural Language interfaces for executive reporting. AI Integration: Build and optimize NL2SQL pipelines that allow non-technical stakeholders to perform self-service analytics via LLM-powered interfaces. Data Reliability: Implement AI-driven observability frameworks to ensure high-fidelity data feeds for automated reporting, minimizing model hallucination and "silent failures." Strategic Automation: Evolve the reporting function from reactive dashboards to proactive decision intelligence, utilizing AI agents to surface automated insights and narrative summaries. Prompt Engineering DBT Semantic Layer (MetricFlow) - Natural Language Query LangChain / LlamaIndex - Agentic AI GCP - Deployment Snowflake Cortex / Pinecone - Managing Unstructured data / Vector data AI Governance / Security / Observability Visualization & Storytelling Creating high-fidelity, intuitive, and visually engaging dashboards using platforms such as Sigma & Domo Translating complex data into clear, actionable visual…