Sr. Specialist (177190)

Colgate-Palmolive

Mumbai

Hybrid

INR 4,000,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

Travel - up to 10% of time
Relocation assistance within country

Job summary

Colgate-Palmolive Company in Mumbai, Maharashtra, India is seeking a hands-on Data Architect to bridge business requirements with scalable, AI-ready data solutions. You will collaborate with Central Data Platform and other data architects to deliver governed data products using Snowflake and dbt in a federated environment.

The role emphasizes data governance, privacy controls, and cost-efficient pipeline design, with leadership responsibilities and cross-functional teamwork.

Qualifications

  • Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or a related field.
  • 6+ years of data engineering/analytics, with 3+ years as Data Architect or Principal Data Engineer.
  • Proficient in dimensional data modeling (Star/Snowflake) and semantic modeling for AI.
  • Deep Snowflake and dbt experience; familiar with Lucidchart for diagrams.
  • Strong governance, privacy (PII), and GDPR/CCPA awareness.

Responsibilities

  • Deliver cross-functional data products; translate business goals into scalable AI-ready data architectures.
  • Design and maintain logical/physical data models, including semantic layers and ontologies.
  • Resolve data bottlenecks with various GIT teams; optimize data pipelines for performance and cost.
  • Implement enterprise-wide data governance, data quality checks and metadata/lineage management.
  • Evaluate new features (AI/BI search, vector indexing) for fit to evolving needs; monitor Snowflake
  • Act as Design Authority to optimize pipeline performance and report speed; lead with strong communication.

Skills

Data modeling
Snowflake
dbt
Airflow
Terraform
Security governance
PII handling
AI tooling
Leadership
Lucidchart

Education

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

Tools

Snowflake
dbt
Lucidchart
Terraform
Airflow
Domo/Sigma

Job description

Requisition ID177190-Posted11/10/2026-Information Technology-India-Maharashtra-Mumbai-Colgate-Palmolive-Travel - up to 10% of time-Hybrid

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

Who We AreColgate-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 InclusionOur 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 EmployerColgate 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
Sr. Specialist

Colgate-Palmolive • Mumbai

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

Colgate-Palmolive • Maharashtra

On-site
INR 1,500,000 - 2,100,000
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, 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, 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
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%
Asst Manager/Manager, Digital Data Delivery
Asst Manager/Manager, Digital Data Delivery

Mployee.me • Mumbai

On-site
INR 3,000,000 - 4,500,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