Expert / Sr. Expert, Data Architecture (177130)

Colgate-Palmolive

Mumbai

On-site

INR 3,500,000 - 6,000,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Relocation assistance within country

Job summary

Colgate-Palmolive Company seeks a Data Architect for Supply Chain Analytics in Mumbai. You will design robust data architectures, build scalable pipelines, and implement AI/ML workflows to enable advanced analytics across supply chain operations.

Collaboration with IT, data governance, and business teams is essential to deliver reliable, secure data solutions. The role requires hands-on experience with Snowflake, Airflow, dbt, and Python, and a strong background in data modeling, ETL, and CI/CD

Qualifications

  • 5+ years as a data architect/engineer in data-intensive environments
  • Experience with Agile methodologies and modern data stacks
  • Hands-on expertise with AI/ML data pipelines and governance

Responsibilities

  • Design and implement robust data pipeline architectures for supply chain analytics.
  • Build and maintain data models, data warehouses and lakehouse architectures.
  • Collaborate with cross-functional teams to translate requirements into scalable data solutions.
  • Review CI/CD workflows to ensure secure, high-quality deployments.
  • Ensure data quality, governance and security across systems.
  • Provide guidance on data architecture best practices and performance tuning.

Skills

Data architecture
Data modeling
ETL
Python
SQL
Apache Airflow
dbt
Snowflake
CI/CD
Generative AI
LLMs
RAG architectures

Education

Master in Computer Science or related field

Tools

Snowflake
dbt
Airflow
Python

Job description

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
Expert / Sr. Expert, Data Architecture

Colgate-Palmolive • Mumbai

Hybrid
INR 3,000,000 - 5,200,000
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

On-site
INR 3,500,000 - 5,200,000
Relocation assistance
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
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. Specialist, Data Engineering
Sr. Specialist, Data Engineering

Colgate-Palmolive • Mumbai

On-site
INR 1,500,000 - 2,600,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 / Sr. Expert, Architecture & Engg
Expert / Sr. Expert, Architecture & Engg

Colgate-Palmolive • Mumbai

Hybrid
INR 1,500,000 - 2,300,000
Sr. Technology Associate
Sr. Technology Associate

Colgate-Palmolive • Mumbai

Hybrid
INR 1,500,000 - 2,500,000