Data Architect

No Relocation Assistance Offered Job Number #171047 - 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 an experienced Data Architect to lead the definition, design, and governance of data assets within the Supply Chain organization in Global IT. This pivotal role ensures data consistency, quality, security, and accessibility to support strategic business initiatives, collaborating with stakeholders, delivery leads, data engineers, data scientists, and enterprise architects. This position is based out of the Piscataway, NJ location. Work visa sponsorship is not available for this position. Roles & Responsibilities Architecture & Modeling: Create comprehensive conceptual, logical, and physical data models for Supply Chain. Translate business goals into a robust data architecture roadmap and define the dbt project structure, modeling standards (Kimball/Dimensional), and testing frameworks Data Governance & Product Ownership: Operationalize enterprise-wide standards, implementing data quality checks, privacy controls (PII masking), and managing metadata/lineage. Implement granular security (Row-Level Security, Dynamic Masking) and define/manage the domain’s "Data Products" (e.g., "Inventory Levels") for enterprise use Optimization & Cost Management (FinOps): Act as the "Design Authority". Proactively optimize pipeline performance and re-architect inefficient data flows to reduce Snowflake credit consumption and improve report performance. Ensure solutions are architected for long-term scalability and cost-efficiency Collaboration & Evaluation: Partner with the Data Delivery Lead to ensure architectural integrity. Assess new features (e.g., Iceberg tables) and tools to determine their fit for evolving domain needs Qualifications Education & Experience: Bachelor's or Master's degree in Computer Science or a related field, with 6+ years of experience in data architecture, modeling, and data management Technical Expertise: Data Modeling: Expert-level proficiency in dimensional data modeling (Star Schema, Snowflake Schema) Modern Data Stack: Deep hands-on experience with Snowflake or any cloud data warehouse (architecture, performance tuning, security). Experience with transformation tools like dbt or Coalesce Data Foundation: Knowledge of data warehousing/data lakes (e.g.,…