Relocation Assistance Offered Within Country # 160010 - Mumbai, Maharashtra, India 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!   Specialist / Sr.Specialist, Data Engineering Global Information Technology Global Shared Services Organization (GSSO) Reporting Structure: If role has direct or indirect reporting into: Leadership Competencies Teamwork and Collaboration Planning/Priority Setting Functional Competencies Flexibility/Adaptability Employment type (full time vs part time) Job Summary (purpose) Data Engineers focus on expanding and optimizing our data, data pipeline architecture, data flow and collection for multi-functional teams. The Data Engineer will be an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. You will support our software developers, data analysts and data scientists on data initiatives and will ensure efficient data delivery architecture is consistent throughout ongoing projects. You must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. You will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives. This team is a group of innovators and technologists that love to learn and collaborate! Main Responsibilities 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 Required Qualifications: Knowledge required,  Skills (language & other) Bachelor’s degree required, Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field a plus We are looking for a candidate with at least 2 - 3 years of experience in a Data Engineer role Working 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 harmonizing, processing and extracting value from large disconnected datasets Experience supporting and working with multi-functional teams in a dynamic environment Experience with object-oriented/object function scripting languages: Python, Java, etc. Preferred Qualifications Experience with relational SQL and NoSQL databases: MongoDB, Snowflake, PostgreSQL, etc Experience with cloud services: GCP, AWS, etc Experience with Visualization tools like Tableau, QlikView Experience with big data tools: Hadoop, Spark, Kafka, etc. Experience with Data Flow, Data Pipeline and workflow management tools: Cloud Composer, Airflow, Luigi, etc. About Colgate-Palmolive Do you want to come to work with a smile and leave with one as well? In between those smiles, your day consists of working in a global organization, continually learning and collaborating, having stimulating discussions, and making impactful contributions! If this is how you see your career, Colgate is the place to be!  Our dependable household brands, dedicated employees, and sustainability commitments make us a company passionate about building a future to smile about for our employees, consumers, and surrounding communities. The pride in our brand fuels a workplace that encourages creative thinking, champions experimentation, and promotes authenticity which has contributed to our enduring success.  If you want to work for a company that lives by their values, then give your career a reason to smile...every single day. In today’s dynamic technology environment, it is an exciting time to be a part of the information technology team at Colgate. Our highly technical and innovative team is dedicated to driving growth for Colgate Palmolive in this ever-changing landscape. What role will you play as a member of the Colgate’s Information Technology team? Data Engineers focus on expanding and optimizing our data, data pipeline architecture, data flow and collection for multi-functional teams. The Data Engineer will be an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. You will support our software developers, data analysts and data scientists on data initiatives and will ensure efficient data delivery architecture is consistent throughout ongoing projects. You must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. You will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives. This team is a group of innovators and technologists that love to learn and collaborate! You are a function expert -  Build and maintain optimal data pipeline architecture 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 You connect the dots - Assemble large, sophisticated data sets that meet functional / non-functional business requirements Build data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader   You are a collaborator -  Work with data and analytics specialists to strive for greater functionality in our data systems   You are an innovator -  Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.   What you’ll need…(Required) Bachelor’s degree required, Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field a plus We are looking for a candidate with at least 2-3 years of experience in a Data Engineer role Working 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 dynamic environment Experience with object-oriented/object function scripting languages: Python, Java, etc. What you’ll need…(Preferred) Experience with relational SQL and NoSQL databases: MongoDB, Snowflake,PostgreSQL etc Experience with cloud services: GCP, AWS, etc   Experience with big data tools: Hadoop, Spark, Kafka, etc. Experience with Data Flow, Data Pipeline and workflow management tools: Cloud Composer, Airflow,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