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 Architecture - Specialist / Sr. Specialist

Travel Required?:  Travel - up to 10% of time
Date:  May 16, 2023
Temporarily Remote

Relocation Assistance Offered Within Country
# 152633 - Mumbai, Maharashtra, India

About Colgate Company

Do you want to come to work with a smile and leave with one as well? In between those smiles, your day consists of working in a global organization, continually learning and collaborating, having 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 Experience


As a Data Architect you understand the business we support and will be responsible to provide direction to a team of engineers to ensure data needs to meet business demands in sales and marketing. This position will establish data architecture principles, build models of data that enable the implementation of the business architecture, generate diagrams displaying keydata entities, and produce an inventory of the data needed to realize the architecture vision. Our teams work on the latest data technologies in the Cloud space including BigQuery, Apache Airflow, Snowflake, Apache Spark and more. This position will be focused on building out and leading the vision for our external and internal data in our modern cloud data platform.


What you will do

  • Translate business needs into long-term architecture solutions in key data areas for syndicated, point of sale and indirect trade data
  • Project manage key data projects for priority business areas
  • Define, design, and build data models for use by the business
  • Evaluate reusability of current data for additional analyses
  • Review object and data models and the metadata repository to structure the data for better management and quicker access
  • Define how the data is stored, consumed, coordinated and led by different data entities and IT systems.
  • Engage with the data management team in best practices for data sourcing, key data elements, data quality management and metadata.
  • Engage with the data warehousing team in the migration to cloud warehousing
  • Provide data initiatives, evaluations, and mentorship with projects in accordance to our corporate guidelines.
  • Build expertise in diverse and emerging technologies and new architectural concepts and principles.
  • Design and build relational databases
  • Develop strategies for data acquisitions, archive recovery, and implementation of a database
  • Define, design, and build dimensional databases
  • Develop data warehousing blueprints, evaluate hardware and software platforms, and integrate systems
  • Performs other duties as assigned
  • Complies with all policies and standards


Required Qualifications

  • Bachelor's Degree Computer Science, Management Information Systems, or a related field.
  • At least 5 years professional experience as a data analyst, data architect, data engineer, or related role developing conceptual, logical, and preliminary physical models for an enterprise
  • Experience with programming languages like Python, Java, SQL or Cloud technologies


Preferred Qualifications

  • Database architecture and data warehousing experience
  • Data management experience


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: Data Architect, Developer, Database, Architecture, Computer Science, Data, Technology, Engineering