Hybrid Data Architect: Snowflake & Pipelines

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

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

401(k) Matching

Paid Parental Leave

Paid Vacation

Paid Holidays

Sick Leave

Job summary

Colgate-Palmolive Company, based in Piscataway, NJ, is seeking a Data Architect to bridge data engineering and business strategy. You will be the hands-on lead on Python, SQL, Snowflake and dbt pipelines, diving into code to unblock engineers and ensure data products meet delivery timelines.

You’ll manage sprint backlogs and collaborate with data delivery leads, engineers, and suppliers to deliver high-impact datasets for core metrics.

Qualifications

• Bachelor's degree in a quantitative field is required.
• 4+ years total in Data Engineering & Data Architecting.
• Hands-on experience with Python, SQL, dbt, Airflow.
• Experience creating ERDs and DFDs.
• Data Warehouse experience, Snowflake preferred.

Responsibilities

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

Skills

Python

SQL

dbt

Airflow

ERDs/DFDs

Education

Bachelor's degree in Computer Science, Industrial Engineering, Supply Chain, or related field

Tools

Snowflake

Lucid

Job description

Colgate-Palmolive Company, based in Piscataway, NJ, is seeking a Data Architect to bridge data engineering and business strategy. You will be the hands-on lead on Python, SQL, Snowflake and dbt pipelines, diving into code to unblock engineers and ensure data products meet delivery timelines.

You’ll manage sprint backlogs and collaborate with data delivery leads, engineers, and suppliers to deliver high-impact datasets for core metrics.