Sr. Specialist

Colgate-Palmolive

Maharashtra

On-site

INR 1,500,000 - 2,100,000

Full time

4 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

Job summary

Colgate-Palmolive Mumbai is seeking a hands-on Data Architect to bridge business requirements and technical implementation. You will design scalable, AI-ready data solutions within a federated data ecosystem, collaborating with the Central Data Platform and other Data Architects to deliver governed data products using modern data stack.

Main responsibilities include data delivery, modeling, governance, and cost optimization, with emphasis on secure, scalable pipelines and AI-enabled analytics

Qualifications

  • Bachelor’s or Master’s degree in CS/IS/Data Engineering or related field.
  • 6+ years of data engineering/analytics experience; 3+ years in a Data Architect/Principal role.
  • Proficiency in dimensional modeling (Star/Snowflake) and semantic modeling for AI integration.
  • Experience with dbt project structure, modeling standards, and testing frameworks.
  • Deep hands-on Snowflake experience (architecture, performance, security) and dbt.
  • Solid understanding of Airflow DAGs and IaC (Terraform); containerization is a plus.
  • Analytics tools integration (Domo, Sigma) for fast dashboards.
  • AI-assisted modeling, automated testing, and agentic development concepts.

Responsibilities

  • Deliver cross-functional data products with multiple teams.
  • Model logical/physical data structures for AI consumption.
  • Resolve data delivery bottlenecks across domains.
  • Operationalize data governance with quality checks and privacy controls.
  • Optimize pipelines to reduce Snowflake credits and improve performance.
  • Evaluate new features like Iceberg, vector indexing, and AI tooling.

Skills

Data Modeling
Snowflake
dbt
Airflow
Terraform
Security & Privacy
Leadership & Communication
AI/ML data tooling
Data Governance
SQL & Analytics

Education

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

Tools

Lucidchart
GitHub
Vault
Domo
Sigma

Job description

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. \ v v 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:

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.
  • BI/Analytics: Domo, Sigma
  • Emerging Tech: Iceberg
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 (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. Specialist
Sr. Specialist

Colgate-Palmolive • Mumbai

Hybrid
INR 4,000,000 - 6,500,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
Sr. Specialist, Data Engineering
Sr. Specialist, Data Engineering

Colgate-Palmolive • Mumbai

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

Colgate-Palmolive • Mumbai

Hybrid
INR 3,000,000 - 5,200,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. Expert, Data Architecture
Sr. Expert, Data Architecture

Colgate-Palmolive • Mumbai

Hybrid
INR 2,800,000 - 4,200,000
Sr. Analyst, Business Analytics
Sr. Analyst, Business Analytics

Colgate Palmolive • Maharashtra

On-site
INR 1,200,000 - 1,800,000