Data Architect

Colgate • Piscataway, NJ

16h • Hybrid

About The Position

As a key contributor to our digital data future, the Media Data Architect plays a strategic role in driving competitive advantage within the Global Digital Technology & Data organization. Reporting to a Digital Data Delivery lead, this role is crucial for supporting our high-growth E-commerce and Digital Marketing business functions. The core responsibility includes strategic innovation: designing, governing, scaling, and maintaining our modern, cloud-based data foundation. This foundation serves as the "single source of truth" for all global digital data initiatives. This position is based out of the Piscataway, NJ location. Work visa sponsorship is not available for this position.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related quantitative field.
• Professional experience in data architecture, data engineering, or similar technical roles, with a minimum of 2 years specifically designing and implementing cloud-based data solutions at enterprise scale.
• Demonstrated proficiency with at least one major cloud data platform (Snowflake, AWS, or Azure), with hands-on experience in DevOps and infrastructure operations including CI/CD pipelines, containerization (Docker/Kubernetes), infrastructure-as-code, and deployment automation.
• Must be able to articulate previous production implementations and architectural designs in detail.
• Advanced proficiency in SQL and Python, with the ability to design and optimize complex data models for enterprise environments, including relational, NoSQL, and dimensional schemas.
• Proven experience designing and implementing integrations across complex technology ecosystems.
• Demonstrated ability to lead technical architectural discussions, translate complex requirements into scalable solutions, and collaborate effectively with cross-functional stakeholders to align technical decisions with business priorities.

Nice To Haves

• Experience with platforms such as Salesforce Data Cloud, Segment, mParticle, GA4, Trade Desk, DV360, and data clean room solutions.
• Demonstrated understanding of data structures, architectural patterns required to make data AI ready.
• Knowledge of data quality standards, lineage tracking and other industry best practices.
• History of evaluating and adopting emerging data technologies (dbt, Dataform, Airflow, modern orchestration frameworks), implementing industry best practices, and driving organizational shifts from legacy to modern architectures.
• Evidence of proactive problem-solving and commitment to measurable outcomes.

Responsibilities

• Design and govern scalable data models and cloud infrastructure (e.g., Snowflake, GCP) that support high-velocity digital data streams while optimizing for performance, cost efficiency, and business flexibility.
• Own the technical roadmap that evolves our architecture to meet both current and future business demands.
• Own the integration strategy connecting our core Tech stack (CDPs, Google Analytics, CRM) with our enterprise data warehouse, creating digital data products and enabling seamless data flow across systems.
• Serve as the technical authority and strategic partner within GIT, translating complex business requirements into clear technical architectures, data products, and implementation roadmaps that drive measurable business outcomes.
• Ensure that pipelines are compliant with Colgate’s architectural vision and standards for ETL/ELT workflows, ensuring automated data pipelines are resilient, fully monitored, and optimized for both batch and real-time processing at enterprise scale.

Benefits

• medical
• dental
• vision
• basic life insurance
• paid parental leave
• disability coverage
• participation in the 401(k) retirement plan with company matching contributions subject to eligibility requirements
• a minimum of 15 vacation/PTO days
• 13 paid holidays
• Paid sick leave

What This Job Offers

• Job Type: Full-time
• Career Level: Senior