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:  Analytics Engineer, Digital Applications & Analytics

Travel Required?:  Travel - 25% of time
Date:  May 28, 2023

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

IT Analytics Engineer 


Do you want to be part of a team that is building a future to smile about? What about having the opportunity to connect with others across the world, full of stimulating discussions, and making impactful contributions? If this is how you see your career,

Colgate is the place to be!


Our dependable household brands, dedicated employees, and sustainability commitments make us a company passionate about building a future to smile about for our employees, consumers, and surrounding communities. The pride in our brand fuels a workplace that encourages creative thinking, champions experimentation, and promotes authenticity which has contributed to our enduring success.


If you want to work for a company that lives by their values, then give your career a reason to smile...every single day.


The Job:

Colgate has embarked on a journey to transform its business using exciting new technologies. We invite you to be a part of this journey and grow with us in the analytics space. As Analytics Engineer, you will be working closely with our data architects,

visualization engineers and data engineers to design robust data pipelines from various data sources. You will be working on exciting new technologies like cloud and open source tools among others, and be responsible for data cleansing, standardization and transforming data sets for our business teams and other IT functions to consume. As a self directed individual, you will be partnering with other IT teams and the business community to build an ecosystem of data sets and tools for driving growth.


What you will do

  • Work with SMEs to understand complex datasets and applications to be able to build next generation Data applications

  • Partner with other IT functions and business teams to gather requirements and convert them to data transformation specifications

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

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

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

  • Ensure high performance and reliability of data transformation processes

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

  • Comply with all policies and standards

  • Perform other duties as assigned


Required Qualifications/Experience:

  • Bachelor's Degree in a quantitative field

  • At least 3 years of professional experience as a data analyst, data engineer

  • Demonstrated proficiency in the use of SQL and/or 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

  • 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

  • Experience in developing Analytics Engineering pipelines using DBT

  • Demonstrated experience with Git/GitHub, dbt Core/Cloud, and Airflow

  • Experience working on Cloud data warehouses like Snowflake

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.

Are you interested in working for Colgate-Palmolive? You can apply online and attach all relevant documents such as a cover letter and resume or CV. Applications received by e-mail are not considered in the selection process. Become part of our team. We look forward to your application.

Colgate-Palmolive is a leading global consumer products company, tightly focused on Oral Care, Personal Care, Home Care and Pet Nutrition. Colgate sells its products in over 200 countries and territories around the world under such internationally recognized brand names as Colgate, Palmolive, elmex, Tom’s of Maine, Sorriso, Speed Stick, Lady Speed Stick, Softsoap, Irish Spring, Protex, Sanex, Elta MD, PCA Skin, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill’s Science Diet and Hill’s Prescription Diet. 

For more information about Colgate’s global business, visit the Company’s web site at To learn more about Colgate Bright Smiles, Bright Futures® oral health education program, please visit To learn more about Hill's and the Hill’s Food, Shelter & Love program please visit To learn more about Tom’s of Maine  please visit

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: Open Source, Application Engineering, Data Warehouse, Data Analyst, Engineer, Technology, Engineering, Data