Colgate logo
Colgate5 months ago

Data Architect

$106,400–$155,000 year

On-site · Piscataway, New Jersey, United States

Type
Full Time
Level
Mid Level
Education
Masters Degree
Company size
Enterprise

Job Summary

Lead definition, design, and governance of data assets within the Supply Chain IT domain; build data models (conceptual, logical, and physical), define the dbt project structure and modeling standards, implement data quality and privacy controls (PII masking, row-level security, dynamic masking), and manage metadata/lineage. Optimize data pipelines to reduce Snowflake credit consumption and improve report performance while ensuring long-term scalability and cost-efficiency. Collaborate with data engineers, data scientists, enterprise architects, and delivery leads to evaluate new features and tools. Education and experience require a Bachelor's or Master's degree in Computer Science or related field with 6+ years in data architecture, modeling, and data management. Proficiency in dimensional data modeling, Snowflake or cloud data warehouses, dbt/Coalesce, data warehousing/lakes (Databricks, BigQuery, Hadoop), orchestration (Airflow), and BI tools; strong governance and privacy knowledge (GDPR/CCPA). Preferred qualifications include domain experience in Supply Chain or Retail/CPG and relevant certifications.

Required Qualifications

  • Bachelor's or Master's degree in Computer Science or a related field
  • 6+ years of experience in data architecture, modeling, and data management
  • Experience with Snowflake or cloud data warehouses
  • Experience with dbt or Coalesce
  • Strong data governance and security experience (PII masking, Row-Level Security, Dynamic Masking)
  • Experience with data modeling (dimensional modeling, star/snowflake schemas)
  • Knowledge of ETL/ELT patterns and data integration
  • Familiarity with data fabrics/lakes (Databricks, BigQuery, Hadoop)
  • Experience with orchestration tools (Airflow)
  • Understanding of BI tools and data visualization
  • Strong communication and collaboration skills
  • Knowledge of privacy regulations (GDPR, CCPA)
  • Relevant certifications (CDMP, Snowpro Advanced Architect, DBT Architect)
  • Experience in Retail or/and Supply Chain domains
Sorce

Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.

Hiring someone like this?

Get your role in front of qualified candidates on Sorce.

Get started

$106k – $155k / yr

Data Architect · Colgate

Apply on Sorce