Lead Data Engineer

Colgate-Palmolive is seeking a Lead Data Engineer to join the Global Digital Applications Team. In this hybrid role based in Piscataway, NJ, you will partner with Digital Marketing and CRM stakeholders to design and deliver customer and marketing data solutions spanning Salesforce, GCP, SAP, and Adobe capabilities.

Role Overview

This position focuses on end-to-end customer experience and marketing solutions, including data architecture, platform integration, and first-party data analysis. You will act as a technical lead for data modeling, governance, and marketing automation enablement to support audience targeting and engagement across consumer and professional environments.

Responsibilities

• Serve as the expert and lead Data Cloud architect for customer experience and marketing solutions, establishing best practices and ensuring adherence by technical and business teams.
• Own technical implementation of the global consumer and professional data models, including implementation, expansion, and ongoing changes.
• Partner with the Global Digital team to define standards and secure approvals, ensuring consistency, scalability, and governance across all markets.
• Drive business outcomes by leveraging key platforms including Salesforce, GCP, SAP CDC, and Adobe Experience Manager across consumer and professional environments.
• Develop fully linked marketing automation capabilities to support user adoption, engagement, and success, including defining KPIs.
• Conduct data analysis and data modeling, and ingest relevant first-party data to develop and identify new audience targets.

Requirements

• Bachelor's degree.
• 6+ years of IT experience, with at least 4 years focused on implementation and support, including Salesforce Marketing Cloud and Salesforce Marketing Automation and Salesforce Data Cloud/Data 360 experience.
• 4+ years of data integration development experience.

Technology Stack

• Salesforce; Salesforce Marketing Cloud; Salesforce Data Cloud; Salesforce Data 360
• GCP; Google Cloud Platform; BigQuery
• SAP CDC; SAP Customer Data Cloud (Gigya)
• Adobe Experience Manager
• Google Analytics 4
• Apache Airflow; Cloud Functions; Apigee/API gateway
• Middleware development; integration services; CDP ecosystem platforms
• Data modeling
• Agile methodology

Preferred Qualifications

• Experience on Google Cloud Platform including BigQuery, Apache Airflow, Cloud Functions, Apigee/API gateway, and middleware development.
• Hands-on platform experience with Salesforce Data Cloud and/or other CDP ecosystem platforms.
• Experience leveraging and implementing additional marketing technology including Google Analytics 4 and SAP Customer Data Cloud (Gigya).
• Experience leading large full-lifecycle implementations and/or integrated solutions involving SFMC ecosystem technologies, cloud-based marketing solutions, integration services, and data modeling.
• Excellent verbal and written communication skills, including customer relationship building.
• Strong organization skills to manage complex projects with many stakeholders.
• Ability to apply agile methodology and sprint development to manage project implementations and backlogs.

Compensation and Location

• Location: Piscataway, NJ (hybrid)
• Salary: USD 110,000 - 150,000 per year
• Experience Level: Minimum 6 years

Benefits

• Medical, dental, vision
• Basic life insurance
• Paid parental leave
• Disability coverage
• 401(k) retirement plan participation with company matching contributions (subject to eligibility requirements)
• Minimum of 15 vacation/PTO days (hourly employees receive a minimum of 120 hours)
• 13 paid holidays
• Paid sick leave adjusted based on role and location in accordance with local laws