Sr. Specialist

Colgate-Palmolive

Mumbai

Hybrid

INR 4,000,000 - 7,000,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Relocation assistance within country
Hybrid work model

Job summary

Colgate-Palmolive Company in Mumbai, India seeks a hands-on Data Architect to design scalable, AI-ready data solutions within a federated data ecosystem. You will partner with the Central Data Platform team and data engineers to deliver governed, high-performance data products on a modern stack.

You will model enterprise data, enable AI consumption, and drive governance, security and cost efficiency across Snowflake pipelines.

Qualifications

  • Design and govern AI-ready data architectures.
  • Model logical and physical data models for analytics and AI consumption.
  • Explain complex data designs to non-technical stakeholders.
  • Ensure data quality, lineage and privacy controls across systems.
  • Optimize Snowflake usage for performance and cost.

Responsibilities

  • Deliver cross-functional data products with governance.
  • Own the design and lifecycle of logical/physical data models.
  • Resolve data delivery bottlenecks with multiple teams.
  • Implement enterprise data governance standards and privacy controls.
  • Optimize pipelines for performance and cost; monitor Snowflake credits.
  • Evaluate new data tools and features for domain needs.

Skills

Data modeling
Snowflake
dbt
Airflow
Terraform
Governance & security
Leadership
Communication
AI/ML integration

Education

Bachelor’s or Master’s degree in Computer Science / Information Systems / Data Engineering

Tools

Lucidchart
Domo/Sigma
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:
  • 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.
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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Specialist
Sr. Specialist

Colgate-Palmolive • Mumbai

Hybrid
INR 4,000,000 - 6,500,000
Sr. Expert, Data Architecture
Sr. Expert, Data Architecture

Colgate-Palmolive • Mumbai

Hybrid
INR 2,800,000 - 4,200,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
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
Expert / Sr. Expert, Data Architecture

Colgate-Palmolive • Mumbai

Hybrid
INR 3,000,000 - 5,200,000
Expert / Sr. Expert, Data Architecture
Expert / Sr. Expert, Data Architecture

Colgate-Palmolive • Mumbai

Hybrid
INR 2,500,000 - 4,000,000
Sr. Specialist
Sr. Specialist

Colgate-Palmolive • Maharashtra

On-site
INR 1,500,000 - 2,100,000
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
Sr. Expert, Data Architecture
Sr. Expert, Data Architecture

Colgate-Palmolive • Mumbai

On-site
INR 4,000,000 - 7,000,000