Site upgrade in progress. You will not be able to apply at this time. Please be patient and check back with us later.

Established in 1806 as a small soap and candle business in New York City, Colgate-Palmolive is now a truly global company with products sold in over 200 countries and territories under such internationally recognized brand names as Colgate, Palmolive, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, elmex, Tom's of Maine, Sanex, Ajax, Axion, Soupline, Haci Sakir, Suavitel, PCA SKIN, EltaMD, Filorga and Hello as well as Hill's Science Diet and Hill's Prescription Diet.

Colgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable, and programs that enrich communities around the world.

Every day millions of people trust our products to care for themselves and the ones they love. Our goal is to use our technology to create products that will continue to improve the quality of life for our consumers wherever they live.

A career at Colgate-Palmolive is an excellent opportunity if you seek a global experience, constant challenge, and development opportunities in an environment that respects work/life effectiveness.

Job Title:  Data Engineer

Travel Required?:  Travel - 25% of time
Date:  Jul 20, 2024

No Relocation Assistance Offered
# 161145 - Dublin, Dublin, Ireland

Who We Are
Colgate-Palmolive Company is a caring, innovative growth company that is reimagining a healthier future for all people, their pets and our planet. Focused on Oral Care, Personal Care, Home Care and Pet Nutrition, we sell our products in more than 200 countries and territories under brands such as Colgate, Palmolive, elmex, hello, meridol, Sorriso, Tom’s of Maine, EltaMD, Filorga, Irish Spring, PCA SKIN, Protex, Sanex, Softsoap, Speed Stick, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill’s Pet Nutrition.

We are recognized for our leadership and innovation in promoting sustainability and community wellbeing, including our achievements in decreasing plastic waste and promoting recyclability, saving water, conserving natural resources and improving children’s oral health.

If you want to work for a company that lives by their values, then give your career a reason to smile and join our global team!


Data Engineer, Data & Analytics Team


Specifically, this position will have the responsibility to:


  • Design and develop reliable, scalable and maintainable data pipelines to support business functions

  • Work with business teams and subject matter experts to understand complex datasets and gather requirements to create and manage data models

  • Develop scalable and sustainable data transformations that curate, clean and store data efficiently

  • Ensure high performance and reliability of data pipelines

  • Perform data profiling, harmonize a wide variety of data sets

  • Keep up to date with technologies and use advanced cloud data warehouse techniques to build innovative solutions

  • Perform bug fixes, apply enhancements to the data models/pipelines as when the need arises

  • Manage Small to Medium Data and Analytics projects

  • Comply with all policies and standards

  • Perform other duties as assigned


 Required Qualifications/Experience:


  • Bachelor's Degree in a quantitative field

  • At least 5 years of professional experience as a data engineer or data analyst

  • Demonstrated proficiency in the use of SQL and Python to wrangle, clean, and integrate data from a variety of sources

  • Demonstrated understanding of modern data warehouse design principles and data engineering best practices

  • Previous experience in building ETL pipelines

  • An astute individual, with the ability to build strong cross-functional relationships. 

  • Excited at the prospect of developing and implementing new tools and processes that add organizational value & improve decision making capabilities

  • A bright, ambitious person, with strategic capabilities, able to lead change, influence and collaborate both internally and externally, and with a clear commitment to delivering business results in a timely manner.


 Preferred Qualifications/Experience:

  • Master's Degree in a quantitative field

  • Professional experience in developing data engineering pipelines for high-volume data.

  • Demonstrated experience with Airflow, dbt, Terraform and Git

  • Familiarity with CI/CD and containerisation technologies like Docker and Kubernetes

  • Experience working on Cloud data warehouses like Snowflake

  • Experience managing small to medium analytics projects would be an advantage

  • Experience coaching/mentoring junior team member would be an advantage


Our Commitment to Sustainability
With the Colgate brand in more homes than any other, we are presented with great opportunities and new challenges as we work to integrate sustainability into all aspects of our business and create positive social impact. We are determined to position ourselves for further growth as we act on our 2025 Sustainability & Social Impact Strategy.

Our Commitment to Diversity, Equity & Inclusion
Achieving our purpose starts with our people — ensuring our workforce represents the people and communities we serve —and creating an environment where our people feel they belong; where we can be our authentic selves, feel treated with respect and have the support of leadership to impact the business in a meaningful way.

Equal Opportunity Employer
Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, ethnicity, age, disability, marital status, veteran status (United States positions), or any other characteristic protected by law.

Reasonable accommodation during the application process is available for persons with disabilities. Please contact with the subject "Accommodation Request" should you require accommodation.


Job Segment: Data Warehouse, Data Analyst, Warehouse, SQL, Database, Technology, Data, Manufacturing