Share this Job

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 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, Hill's Prescription Diet and Hill's Ideal Balance.

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 Architect Lead

Travel Required?:  Travel - up to 10% of time
Date:  Apr 7, 2021
Remote working option during the current situation

No Relocation Assistance Offered
# 97700 - Piscataway, New Jersey, United States



We are excited to invite applications to join our Digital Data, Dashboards & Measurement team. As a Data Architect lead, this role will enable you to understand the business we support and will be responsible to lead a team of engineers to ensure data needs to meet business demands in digital marketing and e-commerce
The teams work on the latest data technologies in the Cloud space including BigQuery, Apache Airflow, Snowflake, Apache Spark and more.


This position will be passionate about building out and leading the vision for our data warehouse, data integration, or machine learning automation projects in various cloud environments for digital marketing and e-commerce.



Key Responsibilities:



  • Define the conceptual, logical and physical data models to achieve success for the digital marketing and e-commerce teams
  • Be the main liaison between business teams and the engineering team to drive data integration requirements to help realize our marketing e-commerce data platform and rollout initiatives.
  • Define and build the ETL/ELT and data pipelines to enable faster, better, data-informed decision-making within the business
  • Implement solutions to enable a stable architecture for collecting robust data sets
  • Responsible for the maintenance, improvement, cleaning, and manipulation of data in the data platform and analytics databases
  • Build reports / analysis on existing consumer and e-commerce data across a number of enterprise applications
  • Work with data analytics teams, data scientists, and software engineers in order to understand and aid in the implementation of database requirements, analyze performance, and solve any issues
  • Develop and present solutions and recommendations to business and GIT teams
  • Sharing knowledge with other GIT members, education and training to resolve issues and remove project barriers
  • Act as an agent of change to help drive data standard methodologies and driving the concept of data as an asset
  • Support the rollout of an enterprise wide data governance framework with a focus on the improvement of data quality and the protection of critical data



Basic requirements:



  • Bachelor’s degree in mathematics, computer science, computer engineering, information management, or statistics or a related field or equivalent relevant experience
  • Good knowledge of programming languages, software tools and analytical methods
  • Experience with SQL or equivalent database querying language
  • Good interpersonal and communication skills
  • Critical problem solver who can successfully identify, fix and solve problems



Preferred requirements:



  • Experience identifying, quantifying, and effectively raising business risks associated with data quality or non-compliance
  • Experience in data architecture, system development, business analysis or a related IT field
  • Exposure to tools used to support data management including data profiling and data quality




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.

Nearest Major Market: New Jersey

Job Segment: Data Architect, Database, Architecture, Engineer, Warehouse, Data, Technology, Engineering, Manufacturing