Data Engineer I / Data Engineer II

Relocation Assistance Offered Within Country

# 84506 - Mumbai, Maharashtra, India

Scope of Responsibility

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 SAP BI/BW, HANA & Google cloud platform


• 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

• Bachelor’s degree required, Graduate degree in Computer Science, Statistics, Informatics, Information


• Systems or another quantitative field is preferred


• At east 4 year of experience as Data Engineer role. 


• At least 1 year of experience in SAP 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/Javascript or similar programming languages


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

Preferred Qualifications

• 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

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 http://www.colgatepalmolive.com. To learn more about Colgate Bright Smiles, Bright Futures® oral health education program, please visit http://www.colgatebsbf.com. To learn more about Hill's and the Hill’s Food, Shelter & Love program please visit http://www.hillspet.com. To learn more about Tom’s of Maine  please visit  http://www.tomsofmaine.com.

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.