Data Engineer

Overview As a Data Engineer on Colgate’s Digital Tech & Data team, you will build and maintain robust data pipelines that feed the company’s digital ecosystem. You’ll treat pipelines and infrastructure as production-grade software, collaborating closely with digital business stakeholders. You will design Airflow-based ingestion, develop modular dbt models, and manage Snowflake objects and cloud infra with Terraform. You’ll also ensure data quality, observability, and cost-aware performance while aligning with platform standards. This role offers the chance to influence data-driven decisions at scale within a global consumer products leader. Compensation / Benefitsmedical coveragedental coveragevision coveragepaid parental leave401(k) with company matchingvacation/PTO days ResponsibilitiesDesign, build, and maintain production-grade data pipelines in Airflow from digital touchpoints into SnowflakeDevelop modular, tested dbt models transforming raw data into business-ready datasetsProvision and manage cloud data infrastructure (Snowflake, Airflow, GCP resources) via Terraform with version control and peer reviewImplement data quality, observability, and testing standards across pipelinesTune Snowflake performance and manage warehouse cost (clustering, profiling, resource monitors)Enforce pipeline standards (branching, CI/CD for dbt and Airflow, code review, documentation, naming) Key requirements2–3 years of hands-on data engineering or analytics engineering experience in digital or e-commerce environmentsApache AirflowSnowflakedbt (data build tool)TerraformPythonSQL