Expert / Sr. Expert, Data Architecture

Colgate-Palmolive

Mumbai

Hybrid

INR 3,000,000 - 5,200,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Colgate-Palmolive in Mumbai is seeking an Expert/Sr. Expert, Data Architecture to design and maintain scalable data architectures for AI-enabled supply chain analytics.

You will build robust data pipelines, data models, and lakehouse architectures, and collaborate across IT and business teams. The role requires hands-on experience with Snowflake, dbt, Airflow, Python, and CI/CD practices; familiarity with Generative AI, RAG workflows, and governance.

Qualifications

  • 5–7 years of experience as a data architect, data engineer, or similar role, with Agile experience.
  • Strong data modeling, relational and non-relational DB design, and ETL/processes.
  • Hands-on with Apache Airflow, dbt, Python, and Snowflake; CI/CD governance.
  • Experience integrating Generative AI, LLMs, and AI workflows into data systems.

Responsibilities

  • Design and develop data pipeline architectures for supply chain analytics.
  • Create and maintain data models, integration pipelines, and data warehouses/lakehouses.
  • Collaborate with cross-functional teams to translate requirements into scalable solutions.
  • Review CI/CD workflows, ensure code quality and security.
  • Maintain data quality, governance, and security across systems.
  • Document data architecture and data flows for compliance.

Skills

Data modeling
ETL
Airflow
dbt
Python
Snowflake
CI/CD
Generative AI
RAG
Data governance

Education

Master in Computer Science - Data Science

Tools

Snowflake
dbt
Airflow
Python
GitHub

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.

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Expert / Sr. Expert, Data Architecture (177130)
Expert / Sr. Expert, Data Architecture (177130)

Colgate-Palmolive • Mumbai

On-site
INR 3,500,000 - 6,000,000
Relocation assistance within country
Sr. Expert, Data Architecture
Sr. Expert, Data Architecture

Colgate-Palmolive • Mumbai

Hybrid
INR 2,800,000 - 4,200,000
Sr. Specialist
Sr. Specialist

Colgate-Palmolive • Mumbai

Hybrid
INR 4,000,000 - 6,500,000
Expert / Sr. Expert, Architecture & Engg
Expert / Sr. Expert, Architecture & Engg

Colgate-Palmolive • Mumbai

Hybrid
INR 1,500,000 - 2,300,000
Expert / Sr. Expert, Architecture & Engg (176315)
Expert / Sr. Expert, Architecture & Engg (176315)

Colgate Palmolive • Mumbai

Hybrid
INR 4,000,000 - 7,000,000
Relocation assistance within country
Hybrid work option
Sr. Technology Associate
Sr. Technology Associate

Colgate-Palmolive • Mumbai

Hybrid
INR 1,500,000 - 2,500,000
Specialist / Sr. Specialist, Data Visualization
Specialist / Sr. Specialist, Data Visualization

Colgate Palmolive • Mumbai

On-site
INR 1,200,000 - 2,000,000
Relocation assistance
Expert, Data Engineering
Expert, Data Engineering

Colgate-Palmolive • Mumbai

Hybrid
INR 2,500,000 - 5,500,000
Hybrid work model
Relocation assistance within country
Travel up to 10%
Sr. Technology Associate
Sr. Technology Associate

Colgate-Palmolive • Mumbai

Hybrid
INR 1,500,000 - 2,500,000
Sr. Specialist (177190)
Sr. Specialist (177190)

Colgate-Palmolive • Mumbai

Hybrid
INR 4,000,000 - 6,000,000
Travel - up to 10% of time
Relocation assistance within country