Specialist, Data Engineering

Relocation Assistance Offered Within Country
# 160005 – Mumbai, Maharashtra, India

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!
 

General Position Information

Position Title:

Specialist, Data Engineering 

Location:

CGBS Mumbai

Scope of Responsibility

Role 

This role will involve working with business analysts to understand needs and then developing the solution which entails planning, design, development and maintenance of our data repositories, pipeline and analytical solutions. The ideal candidate is self driven and looking to build high quality tools to provide actionable insights to our business partners to facilitate data-driven decision making. The candidate needs to be a self-starter – eager to learn new technologies, extract insights and value from data and how to leverage technology to deliver those insights. The candidate should also have an interest in analytics, focus on customer experience and design and intuitive visualization to ensure business users are getting the most from delivered tools.

Specific Responsibilities:

Major position responsibilities include but are not limited to the following: 

• You are excited at the prospect of leveraging technology to solve complex data problems

• Build data applications on Google cloud platform and integrate with different data sources/ tools.

• Design, develop, and maintain a world class data warehouse and analytics architecture to meet business analysis, reporting needs, and data science initiatives

• Work directly with supply chain business users and data scientists to assist in project analysis

• Participate in the development and maintenance of ETL jobs and data pipelines to aggregate data from various on premise, cloud platforms & external data sources 

• Design and develop data marts for consumption by analytics tools and end users

• Develop code standards, guidelines to manage and ensure data quality and integrity

• Optimize and scale data warehouse and data processing infrastructure

• Evaluate new technologies and constantly work towards continuous improvements in data engineering, our platform, and the organization

Basic Qualifications (Required education, experience, skills etc to qualify candidate):

• Bachelor’s degree required, Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field is preferred

• At least 3 year of experience as a Data Engineer role.  

• At least 1 year of experience in data warehousing & analytical tools like Tableau etc. 

• Demonstrates ability in data modeling, ETL development, and Data warehousing

• Knowledge of data management fundamentals and data storage principles

• Experience with Python or similar big data  programming languages

• Working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases

• Experience in CI/CD workflow approaches 

• Knowledge of Terraform, docker kubernetes , cloud functions 

• Experience with Git for version control

• Strong analytical, problem solving & conceptual skills

Preferred Qualifications (Additional education, experience, skills etc as assets):

• Experience building and optimizing”big data” data pipelines, architectures and data sets.

• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

• Experience with data warehousing platforms/storage platforms such as SAP BW/HANA

• Experience with SAP data extractors, SAP Integration tools like SLT, SDI  & understanding of Supply chain processes is preferred

• Experience with cloud data warehousing/Big data environments like Snowflakes, Bigquery, Google cloud storage etc is a plus

• Experience with object-oriented/object function scripting languages: Python, Java, etc.

• Experience with data pipelines and streaming frameworks such as Pubsub, Spark, Airflow, Kafka etc

• Experience with RDBMS; NoSQL experience also encouraged

• Ability to embrace, learn, and apply new technologies and tools

• Familiarity with agile software development methodology

• Ability to communicate well with both technical and non-technical teams

Colgate Functional & Leadership Competencies

Company Overview for External Posting (not to be modified)

Colgate-Palmolive is a leading global consumer products company, 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, Mennen, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, Ajax, Axion, Soupline, and Suavitel. At our Hill’s Pet Nutrition division, makers of Science Diet® and Prescription Diet® brand pet foods, our mission is to help enrich and lengthen the special relationships between people and their pets by providing the best, leading-edge pet nutrition technology, products and expertise to pet owners, veterinary professionals and other key pet professionals worldwide. For more information about Colgate’s global business, visit the Company’s web sites on the Internet at www.Colgate.com  and www.Hillspet.com .

EEO Statement for External Posting (not to be modified)

This position will be filled without regard to race, color, religion, sex, national origin, age, sexual orientation, disability, veteran status or any other characteristic protected by law. 

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 [email protected] with the subject “Accommodation Request” should you require accommodation.

#LI-Hybrid