Data Engineering - Specialist / Sr. Specialist

Relocation Assistance Offered Within Country
# 156966 - 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!
 

The candidate is an individual contributor and responsible for design, development and implementation of various applications in the area of large scale worldwide Colgate e-Commerce Operation and provides support.

The person will be required to collaborate with business teams / functional teams and IT counterparts for daily support incidents and project activities in different business areas across all geographies.

The person should have the ability to understand the requirements related to business problems and transform that into a solution design.

• Understand and apply information technology standards to daily support and project implementation activities
• Involve in planning, design, development and maintenance of our data repositories, pipeline, and analytical solutions
• Build and maintain optimal data pipeline architecture
• Assemble large, sophisticated data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for efficient extraction, transformation, and loading of data from a wide variety of data sources
• Assist with data-related technical issues and support their data infrastructure needs.
• Build data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Work with data and analytics specialists to strive for greater functionality in our data systems
• Apply conceptual knowledge of business processes and technology to design solutions and tackle high complexity issues
• Work closely with internal team and external partners to ensure new developments align with roadmap and integrate seamlessly with other platform components
• Ensuring that systems are safe and secure against cybersecurity threats
• Maintain production systems reliability through correct utilization of GIT standard support and governance processes
• Support day to day business requirements according to global SLA
• Deliver solutions to solve business requirements considering priorities and resources availability
• Ensure the proper use of information technology project management methodology to comply of information technology governance practices
• Collaborate with business and functional teams, develop detailed plans and accurate estimates for completion of build, system testing and implementation phases of project
• Ensure proper documentation of processes, knowledge acquisitions and transfers
• Manage / guide members to implement cross functional projects / initiatives leveraging project management standards
• Conduct performance tuning to improve system performance over multiple business processes
• Mentor and share knowledge to grow and develop the skills of the eCommerce team members
• Eager to learn new technologies, extract insights and value from data and how to leverage technology to deliver those insights while protecting user data through compliance with privacy standards & regulations and implementation of appropriate security safeguards

• Over all 5+ years of IT experience and min 4 years of experience in a Data Engineer role
• SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• 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 find opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• A successful history of manipulating, processing and extracting value from large disconnected datasets.
• Experience supporting and working with multi-functional teams in a multifaceted environment

• Bachelor’s degree or higher degree in Computer Science, Statistics, Informatics, Information Systems or related work experience
• Certification in Data Engineer is preferable
• Experience with relational SQL and NoSQL databases: MongoDB, Neo4j, etc
• Experience with cloud services: Snowflake, GCP, DBT, etc
• Experience with object-oriented/object function scripting languages: Python, JS, etc.
• Experience with big data tools: Hadoop, Spark, Kafka, etc.
• Experience with Data Flow, Data Pipeline and workflow management tools: Cloud Composer, Airflow, Luigi, etc.

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 Application_Accommodation@colpal.com with the subject "Accommodation Request" should you require accommodation.
#LI-Hybrid