Skip to main content
Colgate-Palmolive logo

Enterprise Data Architect

Colgate-Palmolive

Piscataway, NJJob$130–150K/yrSeen todayIn the employer's feed · checked in the last 2 days

See where you stand before you apply. No sign-up to start.

You apply on the posting's application page, with no Olive account needed.

Watch jobs like this.

Don't just apply. Show up ready.

Olive works from this exact posting.

At a glance

Compensation
$130–150K/yr
Location
Piscataway, NJ
Work Authorization
Not specified

Olive focuses on jobs in the United States, including remote roles you can work from there.

Requirements

Credentials this posting asks for.

Bachelor's degree, required

Job overview

Colgate-Palmolive seeks an Enterprise Data Architect in its Global Information Technology organization to maintain cross-domain data architecture and deliver scalable, AI-ready data solutions. The role partners with domain architects, data engineers, and platform teams to develop shared models, standards, and ontologies, and to guide architecture reviews, governance, and optimization across the enterprise.

Skills & qualifications

RequiredNice to have

Skills

Dimensional Data Modeling, requiredSemantic Modeling, requiredEnterprise Ontologies, requiredBusiness Process Mapping, requiredLucidchart, requiredSnowflake, requiredPerformance Tuning, requiredData Security, requiredDbt, requiredAirflow, requiredTerraform, requiredContainerization, requiredAI-Assisted Modeling, requiredAutomated Testing, requiredAgentic Development, requiredModel Context Protocol, requiredBig-Picture Thinking, nice to haveBusiness Communication, nice to haveStakeholder Communication, nice to haveGuiding Peers, nice to haveUpskilling Peers, nice to haveConsumer Packaged Goods, nice to haveNielsen Data, nice to havePoint-of-Sale Data, nice to haveERP Systems, nice to haveSAP, nice to haveDomo, nice to haveSigma, nice to haveIceberg, nice to have

Qualifications

Bachelor's in Computer Science or Related, required5+ Years Data Architecture and Engineering Experience, required

Benefits

Medical Insurance
Dental Insurance
Vision Insurance
Parental Leave
401(k) Match
Paid Time Off

Full job description

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 (https://docs.google.com/forms/d/e/1FAIpQLSdaxk\_eF4utznQoVHlxmL9jVFJbOkM4Oe5CAdKOg-h9EPdLfg/viewform) should you require accommodation.

For additional Colgate terms and conditions, please click here (https://www.colgatepalmolive.com/content/dam/cp-sites/corporate/corporate/en\_us/corp/locale-assets/pdf/colgate-terms-and-conditions-2023.pdf) .

#LI-Hybrid

How this job compares

Set against the 1,577 open Data Architect jobs on Olive Jobs, counted November 18, 2026.

Pay
  • This posting$130–150K/yr
  • New Jersey median$146–229K/yr46 salary ranges
  • US median$124–231K/yr1,312 salary ranges

This range's midpoint, $140K, is 26% below the New Jersey median midpoint ($189K) — in the lowest quarter of Data Architect salary ranges in New Jersey.

Openings
Olive Jobs lists 57 open Data Architect jobs in New Jersey and 1,577 across the US. 13% of them nationwide are listed as remote or flexible.
Hiring the most in New Jersey
Experience
This posting asks for at least 5 years of experience; Data Architect postings that state a minimum ask for 8 years at the median (1,411 postings).
Education
This posting asks for a bachelor's degree; 512 of the 1,577 open Data Architect jobs (32%) ask for a bachelor's degree or higher.

Counted across the open, public US postings on Olive Jobs on November 18, 2026. Figures based on too few postings are left out.

Prepare for this role

You've read the whole posting — now see how you match it.