Enterprise Data Architect

Colgate•Piscataway, NJ
•Hybrid

About The Position

Colgate-Palmolive is seeking an Enterprise Data Architect for its Data Engineering, Architecture and Delivery Organization within Global Information Technology. The role bridges business requirements and technical implementation by designing scalable, AI-ready data solutions that support data-driven decisions. Within a federated data ecosystem, the architect focuses on the horizontal, cross-domain layer, maintaining the enterprise data architecture framework and ensuring shared models, standards, and ontologies work across teams. The role partners with the Data Platform team, domain data architects, and data engineers to deliver performant data products using the modern data stack.

Requirements

  • 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, including Star Schema and Snowflake Schema, as well as semantic modeling and enterprise ontologies for AI integration.
  • Ability to map complex business processes to data structures.
  • Experience with diagramming tools such as Lucidchart.
  • Practical experience with Snowflake architecture, performance tuning, and security.
  • Experience with dbt project structure, macros, testing, and documentation.
  • Solid understanding of Airflow DAG design patterns and dependencies.
  • Familiarity with Infrastructure-as-Code principles such as Terraform and with 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.

Nice To Haves

  • Ability to connect day-to-day designs to the enterprise domain hierarchy and design systems that persist beyond the current sprint.
  • Ability to explain technical concepts in business language and translate business needs into technical concepts, while guiding and upskilling architects and engineering peers on shared standards.
  • Consumer Packaged Goods experience involving external datasets such as Nielsen and Point-of-Sale data, and internal data such as ERP/SAP systems.
  • Understanding of how BI tools such as Domo and Sigma ingest and query data, and ability to design models for fast, interactive dashboard performance.
  • Working knowledge of Iceberg.

Responsibilities

  • Collaborate with Global IT domain and division data architects to design and maintain conceptual, logical, and physical data models across global domains and divisions, aligning business capability maps with technical implementation.
  • Work with teams to deliver cross-functional data products aligned with the enterprise data architecture framework.
  • 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 address business problems.
  • Maintain and evolve the data domain hierarchy to reduce duplication and advance Data as a Product principles.
  • Own the design and lifecycle of logical and physical data models, ensuring business rules are accurately codified, versioned, and optimized for analytics and LLM/AI consumption.
  • Drive and manage data architecture reviews, establish review workflows, oversee project onboarding, and ensure initiatives follow technical standards and enterprise guidelines.
  • Lead the Data Architects Community of Practice, serve as a central technical contact, foster cross-domain collaboration, share knowledge, curate training resources, and upskill data and analytics engineers.
  • Partner with Data Governance and Data Platforms teams to operationalize enterprise data standards, metadata management, data quality standards, and data cataloging.
  • Optimize pipeline performance, monitor Snowflake resource consumption, track data usage KPIs, and ensure pipelines are scalable and cost-efficient.

Benefits

  • Comprehensive benefits package for salaried employees, including medical, dental, vision, basic life insurance, paid parental leave, disability coverage, and participation in the 401(k) retirement plan with company matching, subject to eligibility requirements.
  • Minimum of 15 vacation/PTO days.
  • 13 paid holidays.
  • Paid sick leave adjusted based on role and location in accordance with local laws.
  • Salaried employees may be eligible for discretionary bonuses, profit-sharing, and long-term incentives for Executive-level roles.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service