Director, Data Architecture

Colgate-Palmolive; Piscataway Township (NJ); Híbrido; USD 140 000 - 190 000; Tempo integral

Resumo da oferta

Colgate-Palmolive is seeking a highly experienced Data Architect Lead to define and govern data assets across Enterprise Data Applications. You will lead architects and engineers across Finance, Supply Chain, Global Technology (R&D), Sustainability, and Master Data domains, shaping data models and integration strategies.

You will partner with business stakeholders to build scalable data architecture, drive dbt Snowflake standards, ensure data quality, privacy controls, and cost efficiency while

Qualificações

• Extensive experience leading data architecture in enterprise environments.
• Strong proficiency with Snowflake and dbt.
• Track record in governance, security, and cost management.

Responsabilidades

• Design conceptual, logical, and physical data models across domains.
• Lead architecture decisions and mentor engineers.
• Improve data quality, security, and metadata governance.
• Collaborate with Data Delivery Leads and central platform team.
• Optimize Snowflake performance and costs.

Conhecimentos

Data Architecture

Data Modeling

Data Governance

Leadership

Stakeholder Collaboration

Ferramentas

Snowflake

dbt

Descrição da oferta de emprego

Established in 1806 as a small soap and candle business in New York City, Colgate-Palmolive is now a truly global company with products sold in over 200 countries and territories under such internationally recognized brand names as Colgate, Palmolive, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, elmex, Tom's of Maine, Sanex, Ajax, Axion, Soupline, Haci Sakir, Suavitel, PCA SKIN, EltaMD, Filorga and Hello as well as Hill's Science Diet and Hill's Prescription Diet.
Colgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable, and programs that enrich communities around the world.
Every day millions of people trust our products to care for themselves and the ones they love. Our goal is to use our technology to create products that will continue to improve the quality of life for our consumers wherever they live.
A career at Colgate-Palmolive is an excellent opportunity if you seek a global experience, constant challenge, and development opportunities in an environment that respects work/life effectiveness.

Travel Required?: Travel - up to 10% of time

Posting Start Date: 11/3/26

Hybrid

No Relocation Assistance Offered
Job Number#176923 - 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.

We are seeking a highly experienced Data Architect Lead to spearhead the definition, design, and governance of data assets across the Enterprise Data Applications organization within Global IT. In this senior leadership role, you will lead and mentor the Architects and Engineers responsible for our Finance, Supply Chain, Global Technology (R&D), Sustainability, and Master Data domains—setting architectural direction, raising the bar for engineering quality, and ensuring our data remains consistent, high-quality, secure, and accessible to support strategic business initiatives across the enterprise. You will partner closely with senior business stakeholders, delivery leads, data engineers, data scientists, and enterprise architects to build robust data models and integration strategies, and you will develop the talent and standards that scale our data organization.

What You Own (Strategic Accountability)

Team & Architecture Leadership:Lead, mentor, and grow the Architects and Engineers who own our Finance, Supply Chain, Global Technology (R&D), Sustainability, and Master Data domains. Set architectural direction, uphold engineering standards, and cultivate a strong, cohesive data organization.

Enterprise Data Strategy:Translate business goals across Finance, Supply Chain, Global Technology (R&D), Sustainability, and Master Data into a robust, forward‑looking data architecture roadmap. 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 logical and physical data models across the domains you lead. You will ensure complex business rules are accurately codified, versioned, and optimized for analytics consumption in BI reporting tools.

Data Product Ownership:Define and manage "Data Products" across the domains you lead. You will ensure that datasets exposed to the wider enterprise are well‑documented, reliable, standardized, and interoperable across Finance, Supply Chain, R&D, Sustainability, and Master Data.

Governance Implementation:Operationalize the enterprise‑wide standards and the broader governance framework across the domains you lead. This includes implementing data quality checks, enforcing privacy controls (data masking), managing metadata/lineage, and ensuring strict adherence to security policies.

Solution Optimization & Cost Management:Act as the "Design Authority" across the domains you lead. You will proactively optimize pipeline performance, monitor Snowflake resource consumption (FinOps), and ensure all solutions are architected for long‑term scalability and cost‑efficiency.

Day-to-Day Activities

Design & Architect:Create comprehensive conceptual, logical, and physical data models across the domains you lead, utilizing Snowflake best practices (clustering, micro‑partitions) to ensure performance.

Apply & Extend Standards:Adopt and operationalize the enterprise dbt project structure, modeling conventions and testing frameworks across all owned domains. Identify and propose domain‑specific extensions back through the central team's review process where domain needs warrant.

Collaborate:Partner with the Data Delivery Leads to ensure architectural integrity during sprint execution, and work with the Central Data Platform Team to request and configure necessary infrastructure resources.

Approve:Serve as final approver on architecturally significant PRs — new sources, new dbt project structures, model contracts, cross‑domain dependencies. Day‑to‑day pipeline PRs are owned by the Data Delivery Lead.

Govern:Implement granular security policies (Row-Level Security, Dynamic Masking) and ensure all data assets are cataloged with clear lineage and metadata.

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., Iceberg tables) and tools to determine their fit for the domains’ evolving needs.

What You Bring to the Table

Technical Expertise:

Data Modeling:Expert‑level proficiency in dimensional data modeling (Star Schema, Snowflake Schema, fact/dimension design) and the dbt‑style layered