Director, Data Architecture

Colgate-Palmolive; Piscataway Township (NJ); On-site; USD 195,000 - 225,000; Full time

Job summary

Colgate-Palmolive is seeking a seasoned Data Architect to lead architectural strategy for Finance, Supply Chain, and R&D data domains. You will own data models, product definitions, and governance, driving scalable, secure data solutions across the enterprise.

You will collaborate with data delivery teams, implement dbt standards, and optimize cloud data warehouse performance to support analytics and BI reporting.

Qualifications

• 10+ years in data architecture, data modeling, and data management.
• Experience leading senior architects and engineers across multiple domains.
• Strong SQL skills and modeling on Snowflake, BigQuery, and analytical warehouses.

Responsibilities

• Lead architectural direction across Finance, Supply Chain, R&D, and Master Data domains.
• Define data products and ensure enterprise data assets are well-documented and interoperable.
• Govern data quality, privacy controls, metadata/lineage, and security policy adherence.
• Optimize pipeline performance and Snowflake credit consumption for long-term scalability.

Skills

Data modeling

Snowflake

dbt

SQL

Airflow

Kubernetes

GitHub Actions

Education

Bachelor's or Master's in CS/IS/Data Science

Tools

Snowflake

dbt

Terraform

Airflow

GitHub Actions

Kubernetes

Databricks

Job description

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.

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 architecture (raw → staging → intermediate → marts). Ability to map complex business processes to data structures. Experience with data modeling & diagramming tools.
• Modern Data Stack: Deep hands‑on experience with Snowflake or any cloud data warehouse (architecture, performance tuning, security, multi-account / federated patterns, data sharing) and dbt or similar SQL-based data transformation tools (project structure, macros, testing, documentation).
• Orchestration & Infrastructure: Solid understanding of Airflow (on Kubernetes / GKE) DAG design patterns and dependencies. Hands‑on experience with Infrastructure-as-Code (Terraform) for provisioning Snowflake and cloud resources, GitHub‑based CI/CD (e.g., GitHub Actions), and secret management (e.g., HashiCorp Vault).
• Analytics Integration: Understanding of how BI tools (Domo, Sigma, Retool, or similar) ingest and query data, with the ability to design models that ensure fast, interactive dashboard performance.
• Ingestion: Familiarity with managed replication tools (HVR, Fivetran, Qlik Replicate) for landing ERP and operational data into a cloud warehouse, and the architectural implications of CDC vs. snapshot patterns.

Professional Skills:

• Strategic Thinking: Ability to see the "big picture" and design systems that persist beyond the current sprint.
• Communication: Excellent ability to translate technical concepts into business language for stakeholders and vice‑versa.
• Leadership: Proven experience leading and mentoring senior architects and engineers across multiple concurrent domains, with a track record of setting technical direction, coaching individual contributors, and raising engineering standards.

Qualifications

• Education: Bachelor's or Master's degree in Computer Science, Information Systems, Data Science, or a related field.
• Experience: 10+ years of experience in data architecture, data modeling, and data management, including a demonstrable track record of leading senior architects and engineers across multiple concurrent domains or workstreams.
• Technical Knowledge:
• Knowledge of data warehousing/data lakes (e.g., Snowflake, Databricks, GCP BigQuery, and open table formats like Iceberg or Delta Lake).
• Experience with transformation tools like dbt or Coalesce.
• Hands‑on experience architecting on at least one major cloud platform (GCP preferred; AWS or Azure acceptable).
• Deep understanding of modeling methodologies (relational, dimensional, NoSQL).
• Strong grasp of integration patterns (ETL, ELT, API integrations).
• Strong SQL skills and experience modeling on both transactional source systems (e.g., PostgreSQL, MySQL, SQL Server) and analytical cloud data warehouses (Snowflake, BigQuery, Databricks).
• Governance: Familiarity with data governance principles, data quality management tools, and practices.

Preferred Qualifications

• Cross-Domain Leadership: Experience designing data solutions across multiple enterprise business domains (e.g., Finance, Supply Chain, R&D, Sustainability, or Master Data) and leading distributed data teams is a plus
• Industry Experience: Experience in Retail or CPG domains.
• Certifications: Relevant certifications such as Certified Data Management Professional (CDMP) or cloud-specific data certifications (eg., Snowpro Advanced Architect, dbt Analytics Engineer, or GCP Professional Cloud Architect / Professional Data Engineer)
• Skills: Excellent communication, presentation, interpersonal, and problem-solving skills.

Compensation And Benefits

Salary Range $195,000.00 - $225,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.