Sr. Specialist

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: 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 #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