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 recognized 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 programs 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
Job Title:  Expert / Sr. Expert, Data Architecture
Travel Required?:  No Travel
Posting Start Date:  11/10/26
Hybrid

Relocation Assistance Offered Within Country
Job Number #177130 - Mumbai, Maharashtra, India

Who We Are

Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specializing 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 :

 

  • The Data Architect for Supply Chain Analytics at Colgate-Palmolive is responsible for designing, developing, and maintaining robust data architectures to support advanced AI enabled analytics and reporting in supply chain operations. govern our modern data and AI infrastructure. The ideal candidate will bridge the gap between traditional data engineering and advanced artificial intelligence by architecting scalable data pipelines, AI/ML workflows, and cutting-edge Generative and Agentic AI solutions. The Data Architect will define strict guardrails across our core stack, enforce CI/CD best practices, leverage intelligent AI development tools, and drive project success using Agile methodologies to build and optimize data models and pipelines that drive supply chain insights, process efficiencies, and business value, while adhering to best practices in data governance and security.

 

Responsibilities :

 

  • Design and develop robust data pipeline architecture to support supply chain analytics initiatives.

  • Create and maintain data models, integration pipelines, and data warehouses & Lakehouse architectures for supply chain data.

  • Collaborate with cross-functional teams to gather requirements and translate them into scalable data solutions.

  • Act as a CI/CD workflow reviewer and approver, ensuring code quality, security, and smooth deployments.

  • Ensure data quality, consistency, and integrity across various systems and sources.

  • Implement and enforce data governance, security standards, and best practices.

  • Optimize data structures and processes for performance, scalability, and reliability.

  • Integrate new data sources and technologies to enhance analytics capabilities.

  • Troubleshoot and resolve data-related technical issues promptly.

  • Document data architecture, standards, and data flows for reference and compliance.

  • Review program codes and suggest correction in case of any errors

  • Conduct performance tuning to improve system performance over multiple business processes

  • Provide technical guidance and thought leadership in supply chain data management and analytics.

  • Maintain production systems reliability through correct utilization of IT standards and governance processes

  • Collaborate with business / functional team, develop detailed plans and accurate estimates for completion of build, system testing and implementation of project

 

Required  Qualifications and skills :

 

  • Proven 5 to 7 years of experience as a data architect, data engineer, or in a similar data-focused role with exposure to Safe Agile environment, preferably within supply chain or manufacturing industries. Strong background in executing and managing projects using Agile methodologies, with high proficiency in tools such as GitHub Projects and Jira. Experience working with Visualisation tools (e.g., Sigma, DOMO).

  • Strong proficiency in data modeling, database design (relational and non-relational), and ETL processes along with Data orchestration tools. In-depth knowledge and extensive hands-on experience working with Apache Airflow, dbt, Python, and Snowflake. Extensive integration experience with all types of data file formats, specifically modern formats including Apache Iceberg, Parquet, and JSON. 

  • AI, ML & Advanced Artificial Intelligence:

    • Strong hands-on expertise in designing data architectures that support scalable AI/ML models and pipelines.

    • Proven experience architecting and integrating Generative AI solutions (e.g., LLMs, RAG architectures, prompt engineering pipelines) into enterprise data systems.

    • Experience designing frameworks for Agentic AI, enabling autonomous AI agents to interact with databases, execute workflows, and make data-driven decisions.

  • Experience with modern data warehousing solutions e.g., Snowflake and Data Transformation platform - DBT. Demonstrated ability to architect scalable solutions and define strict development/operational guardrails within the Airflow, dbt, Python, and Snowflake ecosystems. Proven experience designing and creating robust data pipelines across Data Lakes, Cloud Databases, and AI-enabled applications. Hands-on experience designing, developing, and deploying data solutions using next-generation intelligent IDEs (specifically Devin, Antigravity, and Cursor).

  • Proficiency in data integration tools and programming languages such as SQL, Python and Version Management tools - Github. Proven experience acting as a CI/CD workflow reviewer and approver, ensuring code quality, security, and smooth deployments. Hands-on experience in AI/ML routine integration and applications is desirable.

 

Preferred Qualifications and skills :

 

  • Master in Computer Science with Specialisation in Data Science is preferable.

  • Solid understanding of data governance, data security, Metadata management and data quality best practices.

  • Familiarity with supply chain processes, analytics, and key performance indicators (KPIs) is highly desirable.

  • Excellent presentation, problem-solving skills, strong communication and collaboration skills to work effectively with IT and business stakeholders.

#LI-RS1


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, color, 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