Enterprise Data Architect

Colgate-Palmolive

Piscataway Township (NJ)

On-site

USD 130,000 - 150,000

Full time

1 hour 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

Benefits offered by this job

Medical benefits
401(k) retirement plan
Paid time off

Job summary

Colgate-Palmolive is seeking an Enterprise Data Architect to join the Global Information Technology team in Piscataway, NJ. You will bridge business requirements and technical implementation, designing scalable, AI-ready data solutions across a federated data ecosystem and collaborating with the Data Platform team and domain architects.

Responsibilities include modeling, governance, and leading architecture reviews to ensure standards, shared ontologies, and scalable pipelines.

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 and semantic modeling for AI integration.
  • Experience with Snowflake (architecture, performance tuning, security) and dbt.
  • Familiarity with Airflow DAG design patterns and Infrastructure-as-Code (Terraform).
  • Knowledge of AI-assisted modeling, automated testing, and agentic development patterns.

Responsibilities

  • Design and maintain conceptual, logical, and physical data models across core global domains and divisions.
  • Deliver cross-functional data products and AI-ready architectures that align with enterprise standards.
  • Evolve data domain hierarchy and ensure semantic layers and ontologies support analytics and AI consumption.
  • Lead data architecture review processes and ensure adherence to technical standards.
  • Facilitate Data Architects Community of Practice and share knowledge across teams.
  • Collaborate on governance, metadata, data quality, and data cataloging.

Skills

Dimensional modeling
Semantic modeling
Lucidchart
Snowflake
dbt
Airflow patterns
Terraform
Containerization
AI-assisted modeling

Education

Bachelor’s degree

Tools

Snowflake
dbt
Airflow
Terraform
Lucidchart

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 should you require accommodation.

For additional Colgate terms and conditions, please click here.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Architect
Data Architect

Colgate-Palmolive • Piscataway Township (NJ)

On-site
USD 106,000 - 155,000
Medical benefits
401(k) retirement plan with company匹配
Data Architect (175991)
Data Architect (175991)

Colgate-Palmolive • Piscataway Township (NJ)

Hybrid
USD 106,000 - 155,000
Data Architect - Global Technology
Data Architect - Global Technology

Colgate-Palmolive • Piscataway Township (NJ)

Hybrid
USD 86,000 - 121,000
Medical, dental, vision insurance
Basic life insurance
Paid parental leave
+5
Data Architect - Global Technology (177245)
Data Architect - Global Technology (177245)

Colgate-Palmolive • Piscataway Township (NJ)

Hybrid
USD 86,000 - 121,000
Data Architect - Global Technology
Data Architect - Global Technology

Colgate-Palmolive • Piscataway Township (NJ)

Hybrid
USD 86,000 - 121,000
Medical benefits
401(k) matching
Paid time off
Data Engineer
Data Engineer

Colgate-Palmolive • Piscataway Township (NJ)

On-site
USD 97,000 - 137,000
Medical insurance
Dental insurance
Vision insurance
+5
Sr. Data Engineer (173322)
Sr. Data Engineer (173322)

Colgate-Palmolive Company • Piscataway Township (NJ)

Hybrid
USD 115,000 - 174,000
Sr. Data Engineer
Sr. Data Engineer

Colgate-Palmolive Company • Piscataway Township (NJ)

Hybrid
USD 115,000 - 174,000
Data Engineer (176646)
Data Engineer (176646)

Colgate-Palmolive • Piscataway Township (NJ)

On-site
USD 110,000 - 150,000
Medical benefits
Dental benefits
Vision benefits
+5
Senior Manager: Data Delivery (Global Skin Health)
Senior Manager: Data Delivery (Global Skin Health)

Colgate-Palmolive • Piscataway Township (NJ)

Hybrid
USD 140,000 - 174,000
Medical, dental, vision
401(k) with company matching
Paid time off and holidays