Job Description

Established in 1806 as a small soap and candle business in New York City, Colgate-Palmolive is now a truly global company with products sold in over 200 countries and territories under such internationally recognised brand names as Colgate, Palmolive, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, elmex, Tom's of Maine, Sanex, Ajax, Axion, Soupline, Haci Sakir, Suavitel, PCA SKIN, EltaMD, Filorga and Hello as well as Hill's Science Diet and Hill's Prescription Diet.

Colgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable, and programmes that enrich communities around the world.

Every day millions of people trust our products to care for themselves and the ones they love. Our goal is to use our technology to create products that will continue to improve the quality of life for our consumers wherever they live.

A career at Colgate-Palmolive is an excellent opportunity if you seek a global experience, constant challenge, and development opportunities in an environment that respects work/life effectiveness.
Information at a Glance
Apply now
Job Title:  Expert, Analytics Engineering
Travel Required?:  No Travel
Posting Start Date:  02/06/2026
Hybrid

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 representations and business insights to highlight trends and opportunities for stakeholders.

  • Overseeing the automated delivery of critical reports to executive leadership with a commitment to absolute accuracy and timeliness.

Business Partnership & Domain Expertise

  • Serving as a strategic partner to leaders in CD teams to uncover core business needs through discovery sessions.

  • Acting as a bridge between technical engineering constraints and business ambitions to ensure data-driven decision-making.

Technical Leadership & Mentorship

  • Establishing internal standards for optimized SQL, clean code, and effective dashboard design principles across the organization.

  • Performing rigorous peer reviews of code and visualizations to ensure performance optimization and consistency with brand standards.

Required  Qualifications:

  • Possessing a Bachelor’s degree in Computer Science, Data Analytics, Mathematics, or a closely related quantitative field.

  • Demonstrating 8+ years of extensive, hands-on experience in Data Engineering and Business Intelligence architectures.

  • Expert-level mastery of the technical stack, specifically Snowflake, SQL, and dbt, to drive data modeling and logic.

  • Proficiency in utilizing Python and Airflow for the orchestration of complex data workflows.

  • Proven business acumen with Customer Development and Retail data sets

  • Exceptional verbal and written communication skills, with a proven ability to translate and present complex data insights to executive leadership.

 

Preferred Qualifications:

  • Applying UI/UX principles to the creation of sophisticated and intuitive dashboard designs.

  • Demonstrating experience with AWS or GCP cloud ecosystem integrations to support data architectures.

  • Possessing a professional background within the Consumer Packaged Goods (CPG) or Retail sectors.


Our Commitment to Inclusion
Our journey begins with our people—developing strong talent with diverse backgrounds and perspectives  to best serve our consumers around the world and fostering an inclusive environment where everyone feels a true sense of belonging. We are dedicated to ensuring that each individual can be their authentic self, is treated with respect, and is empowered by leadership to contribute meaningfully to our business.

Equal Opportunity Employer
Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, colour, religion, gender, gender identity, sexual orientation, national origin, ethnicity, age, disability, marital status, veteran status (United States positions), or any other characteristic protected by law.

Reasonable accommodation during the application process is available for persons with disabilities. Please complete this request form should you require accommodation.

#LI-Hybrid
Apply now