Share this Job

Data Architect on Cloud (AWS) - Sr. Technical Analyst / Data Architect

Date: Aug 7, 2019

Location: Mumbai, MH, IN

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, Speed Stick, Lady Speed Stick, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, elmex, Tom’s of Maine, Sanex, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill’s Science Diet, Hill’s Prescription Diet and Hill’s Ideal Balance.

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

Location: Mumbai, Maharashtra, India
Relocation Assistance Offered Within Country
# 74090




We are excited to invite applications for the position of Data Engineer / Architect within our Colgate Connect team. Operating within the world’s leading Oral Care Company, Colgate Connect is a small, dedicated group of people inspired by the possibility of leveraging new technology to make everyday life healthier.  We debuted our E1 toothbrush in 2018 exclusively through Apple -  it’s a true breakthrough and only the beginning.


We have a number of exciting projects in the works and we are looking for a Data Architect to join our team to help realize our vision. The ideal candidate has experience designing and building pipelines for big data and is adept at using large data sets to generate insights and using models to test the effectiveness of different courses of action. They must have strong experience using a variety of data mining/data analysis methods, using a variety of data tools, building and implementing models, using/creating algorithms and creating/running simulations. They must have a proven ability to drive business results with their data-based insights. They must be comfortable working with a wide range of stakeholders and functional teams. The right candidate will have a passion for discovering solutions hidden in large data sets and working with stakeholders to improve business outcomes.




Roles and Responsibility:


  • Research and properly evaluate sources of information to determine possible limitations in reliability or usability
  • Establish the appropriate scalable architecture to extract value from our data including integration with other internal data sources.
  • Responsible for leading, designing and developing data quality and conversion solutions to support the implementation of strategic Connected Health initiatives.
  • Should be able to work with structured data as well as unstructured data
  • Design & develop solutions using standard data migration methodology & tool-set for data extraction, mapping, scoping, transformation, validation & loads.
  • Deploy sophisticated analytics programs, machine learning, and statistical methods.
  • Develop custom data models and algorithms to apply to data sets.
  • Use predictive modeling to increase and optimize customer experiences, and other business outcomes.
  • Prepare data for predictive and prescriptive modeling and finding trends in data sets and developing algorithms to help make raw data more useful to the enterprise.
  • Develop a testing framework and test model quality and improve test coverage of existing code bases.
  • Support Connected Health platforms servicing worldwide Colgate Operations




Experience :


  • Experience with Analytic Tools such as R,SQL,SAS or Python
  • Strong understanding of AWS environment (PaaS, IaaS) and experience in working with hybrid model.
  • Strong in Data Architecture and management of Data Warehouse (DW), data lake, data governance and MDM architecture.
  • Able to translate business and technical requirements into Architectural components.
  • Design, develop, implement robust ETL pipelines for Enterprise DW and data marts ingesting both structured and unstructured data.
  • Hands-on experience with all aspects of designing, developing, testing and implementing ETL solutions
  • Experience with Tableau data extracts and providing data as a service.
  • Good knowledge of DW metadata concepts.
  • Knowledge of wearables technology preferred.
  • Familiarity with data privacy concepts (GDPR, PCI, HIPAA).


Qualification & Competencies


  • Bachelor's degree in Computer Science, Information Technology, Mathematics, Engineering or similar degree.
  • At least 5+ years of experience in manipulating data sets and building statistical models.
  • Strong problem-solving skills with an emphasis on product development.
  • Strong experience with test driven development methodologies.
  • Strong oral & written communication skills with an ability to express complex technical concepts in business terms and business needs in technical specifications
  • A drive to learn and master new technologies and techniques.
  • Strong analytical skills - strong problem-solving skills, communicates in a clear and succinct manner and effectively evaluates information/data to make decisions; anticipates obstacles and develops plans to resolve them.




Are you interested in working for Colgate-Palmolive? You can apply to work with us using this online application. 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.

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

Job Segment: Data Architect, Database, Architecture, Cloud, Engineer, Data, Engineering, Technology