Sr. Specialist

Colgate-Palmolive

Mumbai

Hybrid

INR 4,000,000 - 6,500,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 is seeking a hands-on Data Architect to bridge business requirements and technical implementation, designing scalable AI-ready data solutions. You will collaborate with the Central Data Platform and multiple engineers to deliver governed data products using a modern stack.

Lead data modeling, governance, and cost-optimized pipelines while ensuring secure, scalable data delivery across the organization. Hybrid work model in Mumbai region.

Qualifications

  • Bachelor’s or Master’s degree in CS, IS, Data Engineering, or related field.
  • 6+ years data engineering/analytics; 3+ years as Data Architect/Principal Data Engineer.
  • Strong data modeling (Star/Snowflake) and semantic modeling for AI integration.
  • Proficiency in dbt project structure and Kimball dimensional modeling.
  • Hands-on with Snowflake and dbt; governance and security knowledge.

Responsibilities

  • Cross functional Data Delivery: deliver cross functional data products and translate requirements into robust AI-ready data architectures.
  • Business Logic Modeling: design and lifecycle of logical and physical data models for human analytics and AI consumption.
  • Resolving data delivery bottlenecks: collaborate with GIT teams to address data architecture challenges.
  • Governance Implementation: implement enterprise-wide data governance standards, data quality checks, privacy controls, metadata/ lineage, security policies.
  • Solution Optimization & Cost Management: act as Design Authority to optimize pipelines, monitor Snowflake usage, ensure scalability and cost-efficiency.
  • Optimize: review high-cost queries and data pipelines; re-architect to reduce Snowflake credits and improve performance.
  • Evaluate: assess new features and tools for evolving domain needs.

Skills

Data modeling
Snowflake
dbt
Airflow
Terraform
Security & compliance
Leadership

Education

Bachelor’s or Master’s degree in CS/IS/Data Engineering

Tools

Lucidchart
GitHub
Vault

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.

Travel Required?: Travel - up to 10% of time

Posting Start Date: 11/10/26

Hybrid

Relocation Assistance Offered Within Country

Job Number#177190 - 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.

Job Summary (purpose):

We are looking for a technical hands-on Data Architect to join our Data Engineering, Architecture and Delivery Organization. In this pivotal role, you will bridge the gap between complex business requirements and technical implementation,designing scalable, AI-ready data solutions that empower our stakeholders and AI agents to make data-driven decisions.

You will act as the Data Architect, working within a federated data ecosystem. You will partner with our Central Data Platform team (who manage Snowflake/Infrastructure) and various Data Architects and Data Engineers to deliver high-value, governed, and performant data products using our modern data stack.

Main Responsibilities:

Major position responsibilities include but are not limited to the following:

Cross functional Data Delivery: Work as part of a team to deliver cross functional data products. Deep collaboration with other GIT domain and division teams to understand the requirements, translate business goals into robust, forward-looking AI-ready data architectures, develop Entity Relationship Diagrams, Data Flow Diagrams and machine-readable semantic models . Develop data engineering pipelines to meet the requirements. You will ensure that our technical design directly solves critical business problems rather than just moving data.

Business Logic Modeling: Own the design and lifecycle of the logical and physical data models. You will ensure complex business rules are accurately codified, versioned, and optimized for both human analytics and LLM/AI consumption (such as semantic layers and enterprise ontologies).

Resolving data delivery bottlenecks: Collaborate with various GIT teams to understand their day-to-day data architecture challenges and work towards resolving them.

Governance Implementation: Operationalize enterprise-wide data governance standards, which includes implementing data quality checks, enforcing privacy controls (PII masking), managing metadata/lineage, and ensuring strict adherence to security policies.

Solution Optimization & Cost Management: Act as the "Design Authority" to proactively optimize pipeline performance, monitor Snowflake resource consumption, and ensure all data pipelines are architected for long-term scalability and cost-efficiency.

Optimize: Perform regular reviews of high-cost queries and data pipelines; re-architect inefficient flows to reduce Snowflake credit consumption and improve report performance.

Evaluate: Assess new features (e.g., AI/BI search, vector indexing, Iceberg tables) and tools to determine their fit for the domain’s evolving needs.

Required Qualifications:

Education: Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or a related quantitative field.

Experience: 6+ years of total data engineering/analytics experience, with at least 3+ years in a Data Architect or Principal Data Engineer role.

Data Modeling: Proficiency in dimensional data modeling (Star Schema, Snowflake Schema) as well as semantic modeling and enterprise ontologies for AI integration, and ability to map complex business processes to data structures. Experience with diagramming tools like Lucidchart.

Proficiency in Defining the dbt project structure, modeling standards (Kimball/Dimensional), and testing frameworks that the analytics engineers will build against.

Modern Data Stack: Deep hands-on experience with Snowflake (architecture, performance tuning, security) and dbt (project structure, macros, testing, documentation).

Orchestration & Infrastructure: Solid understanding of Airflow DAG design patterns and dependencies. Familiarity with Infrastructure-as-Code principles (Terraform) and Containerization concepts is a plus.

Analytics Integration: Understanding of how BI tools (Domo, Sigma) ingest and query data, with the ability to design models that ensure fast, interactive dashboard performance.

AI-Driven Data Tooling: Working knowledge of AI-assisted modeling features, automated testing frameworks, and agentic development patterns (such as Model Context Protocol or specialized agent skills).

Governance & Security: Strong understanding of data security, Row-Level Security, RBAC,Dynamic Masking, PII handling, GDPR/CCPA compliance, and observability frameworks.

Experience in performing regular reviews of high-cost queries and data pipelines; re-architect inefficient flows to reduce Snowflake credit consumption and improve report performance.

Leadership: Excellent communication skills with proven experience influencing technical and executive leadership.

Infrastructure Knowledge and hands on with Terraform, Containers, GitHub, Vault

Preferred Qualifications:

Thought Leadership: Ability to see the "big picture" and design systems that persist beyond the current sprint.

Communication: Excellent ability to translate technical concepts into business language for stakeholders and vice-versa.

#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

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
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 • Maharashtra

On-site
INR 1,500,000 - 2,100,000
Expert / Sr. Expert, Data Architecture
Expert / Sr. Expert, Data Architecture

Colgate-Palmolive • Mumbai

Hybrid
INR 3,000,000 - 5,200,000
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%
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
Expert / Sr. Expert, Architecture & Engg
Expert / Sr. Expert, Architecture & Engg

Colgate-Palmolive • Mumbai

Hybrid
INR 1,500,000 - 2,300,000
Sr. Specialist, Data Engineering
Sr. Specialist, Data Engineering

Colgate-Palmolive • Mumbai

On-site
INR 1,500,000 - 2,600,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
Assistant Manager, Global Data Science
Assistant Manager, Global Data Science

Colgate-Palmolive Company • Mumbai

Remote
INR 4,000,000 - 6,000,000
Relocation assistance (within country)