Hands-on Data Architect — Hybrid, Snowflake & Pipelines

Colgate-Palmolive; Piscataway Township (NJ); Hybrid; USD 106,000 - 155,000; Full time

Job summary

Colgate-Palmolive is hiring a Data Architect in Piscataway, NJ. You will bridge business strategy and data engineering, building high-performance data products and pipelines to keep our supply chain data flowing smoothly.

This hands-on role requires strong SQL/Python skills, ERD/DFD expertise, and Snowflake experience. Hybrid work in New Jersey, with up to 10% travel and no visa sponsorship.

Qualifications

• Bachelor’s degree in Computer Science, Industrial Engineering, Supply Chain, or a related quantitative field.
• 4+ years total in Data Engineering & Data Architecting
• Hands-on experience with Python, SQL, dbt, Airflow.
• Hands-on experience creating ERDs and DFDs.
• Data Warehouse experience (Snowflake preferred).

Responsibilities

• Serve as hands-on lead resolving blockers across Python, SQL, Snowflake, and dbt pipelines.
• Perform GitHub PR reviews to enforce testing, quality, and standards.
• Ensure all engineering aligns with cloud data warehousing and orchestration standards (Airflow/GKE).
• Deliver high-impact datasets for core metrics sourced from SAP, Kinaxis, and WMS/TMS tools.
• Manage sprint backlogs, timelines, and engineers/consultants across initiatives.

Skills

Python

SQL

dbt

Airflow

ERDs/DFDs

Education

Bachelor's degree in CS/IE/SC

Tools

Snowflake

Job description

Colgate-Palmolive is hiring a Data Architect in Piscataway, NJ. You will bridge business strategy and data engineering, building high-performance data products and pipelines to keep our supply chain data flowing smoothly.

This hands-on role requires strong SQL/Python skills, ERD/DFD expertise, and Snowflake experience. Hybrid work in New Jersey, with up to 10% travel and no visa sponsorship.