Sr. Specialist, Data Engineering (Mumbai, MH, IN)

<style type="text/css"> </style> <p><span style="font-family:Arial, Helvetica, sans-serif">Relocation Assistance Offered Within Country<br>Job Number #174667 - Mumbai, Maharashtra, India<br><br><strong>Who We Are</strong><br><br>Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specializing in Oral Care, Personal Care, Home Care, Skin Care, and Pet Nutrition. Our products are trusted in more households than any other brand in the world, making us a household name!<br><br>Join Colgate-Palmolive, a caring, innovative growth company reimagining a healthier future for people, their pets, and our planet. Guided by our core values—Caring, Inclusive, and Courageous—we foster a culture that inspires our people to achieve common goals. Together, let's build a brighter, healthier future for all.</span><br> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"><strong>Brief introduction - Role Summary/Purpose: </strong></span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Colgate-Palmolive is looking for a Specialist Data Engineer to join its growing Global Information Technology organization. The Specialist Data Engineer will work closely with the discrete business areas, as well as the Global Information Technology functional organizations across the globe.</span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">The successful candidate will be managing and 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 deliver 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 demonstrate technology to deliver those insights through efficient data pipelines</span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Additionally, knowledge of cloud environments and automation/optimisation skills would be good, as well Should be experienced in ETL pipelines and aware of code standards .The candidate should be able to play a lead role towards the evolution of technology deployments across the global footprint.</span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"><strong>Responsibilities: </strong></span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Major position responsibilities include but are not limited to the following:</span></p> <ul style="list-style-type:disc"> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">You are excited at the prospect of demonstrating technology to solve complex data problems</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Build data applications on Google cloud platform and integrate with different data sources/ tools.</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Design, develop, and maintain a world class data warehouse and analytics architecture to meet business analysis, reporting needs, and data science initiatives</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Work directly with divisional and global business users and data scientists to assist in project analysis</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Participate in the development and maintenance of ETL jobs and data pipelines to aggregate data from various on premise, cloud platforms &amp; external data sources</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Design and develop data marts for consumption by analytics tools and end users</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Develop code standards, guidelines to manage and ensure data quality and integrity</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Optimize and scale data warehouse and data processing infrastructure</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Evaluate new technologies and constantly work towards continuous improvements in data engineering, our platform, and the organization</span></p> </li> </ul> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"><strong>Required  Qualifications : </strong></span></p> <ul style="list-style-type:disc"> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Bachelor’s degree required, Graduate degree or equivalent experience in Computer Science, Statistics, Informatics, Information Systems or another quantitative field would be an advantage</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Ability to work as a Data Engineer with minimum 2-3years of experience.</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Demonstrates expertise in data modeling, ETL development, and Data warehousing</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Knowledge of data management fundamentals and data storage principles</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Experience with Python or similar programming languages</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Experience in CI/CD workflow approaches</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Knowledge of Python, Terraform, docker Kubernetes, cloud functions, snowflake/BigQuery, DBT</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Experience with Git for version control</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Strong analytical, problem solving &amp; conceptual skills</span></p> </li> </ul> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"><strong>Preferred Qualifications : </strong></span></p> <ul style="list-style-type:disc"> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Experience building and optimizing"big data" data pipelines, architectures and data sets.</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Experience performing root cause analysis on internal and external data and processes to answer specific business questions and find opportunities for improvement.</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Experience with SAP data extractors, SAP Integration tools like SLT, SDI &amp; understanding of Supply chain processes is preferred</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Experience with cloud data warehousing/Big data environments like Snowflakes, BigQuery, Google cloud storage etc is a plus</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Experience with data pipelines and streaming frameworks such as Pubsub, Spark, Airflow, Kafka etc</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Experience with RDBMS; NoSQL experience also encouraged</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Ability to embrace, learn, and apply new technologies and tools</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Familiarity with agile software development methodology</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Should be able to communicate well with both technical and non-technical teams</span></p> </li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black"> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt;color:black">Knowledge of AI tools used for data pipelines will be preferred</span></p> </li> </ul><p><br><span style="font-family:Arial, Helvetica, sans-serif"><strong>Our Commitment to Inclusion</strong><br>Our journey begins with our people—developing strong talent with diverse backgrounds and perspectives  to best serve our consumers around the world and fostering an inclusive environment where everyone feels a true sense of belonging. We are dedicated to ensuring that each individual can be their authentic self, is treated with respect, and is empowered by leadership to contribute meaningfully to our business.</span><br><br><br><span style="font-family:Arial, Helvetica, sans-serif"><strong>Equal Opportunity Employer</strong><br>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.<br><br>Reasonable accommodation during the application process is available for persons with disabilities. Please complete this<a href="https://docs.google.com/forms/d/e/1FAIpQLSdaxk_eF4utznQoVHlxmL9jVFJbOkM4Oe5CAdKOg-h9EPdLfg/viewform" target="_blank" rel="noopener"> <span style="color:#0000ff">request form</span></a> should you require accommodation.<br><br><span style="color:#000000">#LI-Hybrid</span></span></p>