Travel Required?:
Travel - up to 10% of time
Posting Start Date
11/17/26
Hybrid
No Relocation Assistance Offered
Job Number #177479 - Piscataway, New Jersey, United States
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.
Role Summary
We are looking for an Enterprise Data Architect to join our Data Engineering, Architecture and Delivery Organization within Global Information Technology (GIT). In this role, you will bridge the gap between complex business requirements and technical implementation, designing scalable, AI-ready data solutions that empower stakeholders and AI agents to make data-driven decisions. Working within a federated data ecosystem, while Domain Data Architects focus on specific verticals (such as Customer Development, Supply Chain, Finance, and R&D), you will focus on the horizontal, cross-domain layer—maintaining the enterprise data architecture framework and ensuring shared models, standards, and ontologies work seamlessly across teams.
You will partner with our Data Platform team (who manage Snowflake and infrastructure), domain data architects, and data engineers to deliver high-value, performant data products using our modern data stack.
Responsibilities
Enterprise Data Strategy & Modeling: Collaborate with Global IT domain and division data architects to design and maintain conceptual, logical, and physical data models across core global domains (including Supply Chain, Finance, etc.,) and divisions (North America, LATAM, EMEA, etc.), ensuring alignment between business capability maps and technical implementation.
Cross-Functional Data & Architecture Delivery: Work as part of a team to deliver cross-functional data products while maintaining alignment with the enterprise data architecture framework. Collaborate with Global IT domain and division teams to translate business goals into robust, AI-ready architectures, develop Entity Relationship Diagrams, Data Flow Diagrams, and machine-readable semantic models, and build data engineering pipelines that solve critical business problems rather than just moving data.
Domain Hierarchy & Business Logic Modeling: Maintain and evolve the established data domain hierarchy to avoid data duplication, advance "Data as a Product" principles, and own the design and lifecycle of logical and physical data models—ensuring business rules are accurately codified, versioned, and optimized for both human analytics and LLM/AI consumption (such as semantic layers and enterprise ontologies).
Architecture Review Leadership: Drive and manage the data architecture review process for all initiatives. Establish architecture review workflows, oversee structured project onboarding, and ensure that all new data initiatives strictly adhere to technical standards and enterprise guidelines.
Community of Practice Facilitation: Actively run and lead the Data Architects Community of Practice. Act as the central technical point of contact for all data architects across the enterprise, foster cross-domain synergy, share knowledge, curate training resources, and upskill data and analytics engineers on domain-driven design and shared technical standards.
Governance, Security & Data Quality: Collaborate with Data Governance and Data Platforms teams to operationalize enterprise-wide data standards, metadata management, data quality standards and data cataloging.
Solution Optimization & Cost Management: Proactively optimize pipeline performance, monitor Snowflake resource consumption, track data usage KPIs, and ensure all data pipelines are architected for long-term scalability and cost-efficiency.
Required Qualifications
Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.
5–8 years of experience in data architecture and data engineering.
Proficiency in dimensional data modeling (Star Schema, Snowflake Schema) as well as semantic modeling and enterprise ontologies for AI integration, with the ability to map complex business processes to data structures. Experience with diagramming tools like Lucidchart.
Proven practical experience with Snowflake (architecture, performance tuning, security) and dbt (project structure, macros, testing, documentation).
Solid understanding of Airflow DAG design patterns and dependencies, along with familiarity with Infrastructure-as-Code principles (Terraform) and containerization concepts.
Working knowledge of AI-assisted modeling features, automated testing frameworks, and agentic development patterns (such as Model Context Protocol or specialized agent skills).
Preferred Qualifications
- Ability to see the "big picture," connect day-to-day designs to the enterprise domain hierarchy, and design systems that persist beyond the current sprint.
- Excellent ability to translate technical concepts into business language for stakeholders and vice-versa, while effectively guiding and upskilling architects and engineering peers on shared standards.
- Consumer Packaged Goods (CPG) experience involving external datasets like Nielsen, Point-of-Sale (POS) and internal data like ERP/SAP systems.
- Understanding of how BI tools (Domo, Sigma) ingest and query data, with the ability to design models that ensure fast, interactive dashboard performance.
- Working knowledge of Iceberg
Compensation and Benefits
Salary Range $130,000.00 - $150,000.00 USD
Pay is determined based on experience, qualifications, and location. Salaried employees may also be eligible for discretionary bonuses, profit-sharing, and long-term incentives for Executive-level roles.
Benefits: Salaried employees enjoy a comprehensive benefits package, including medical, dental, vision, basic life insurance, paid parental leave, disability coverage, and participation in the 401(k) retirement plan with company matching contributions subject to eligibility requirements. Additional benefits include a minimum of 15 vacation/PTO days (hourly employees receive a minimum of 120 hours) and 13 paid holidays (vacation days are prorated based on the employee's hire date within the calendar year).
Paid sick leave is adjusted based on role and location in accordance with local laws. Detailed information regarding paid sick leave entitlements will be provided to employees upon hiring and may be subject to adjustments based on changes in legislation or company policies.
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.
For additional Colgate terms and conditions, please click here.
#LI-Hybrid
Job description provided by Colgate-Palmolive.
View the original posting