We are excited to invite applications for the position of Data Engineer within our eCommerce applications team. Operating within the world’s leading Oral Care Company, we have a number of exciting projects in B2B and Marketplace applications.

We are looking for a highly motivated data engineer to join our team to help us win in eCommerce.

This role will involve 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 meaningful 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 use technology to deliver those insights while protecting user data through compliance with privacy standards & regulations and implementation of appropriate security safeguards.

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.

Basic Qualifications:

• Bachelor’s degree or higher degree in Computer Science, Statistics, Informatics, Information Systems or related work experience.
• At least +1 year 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 dynamic environment.
• Strong analytical, oral & written communication skills

They should also have experience using the following software/tools:

• Experience with relational SQL and NoSQL databases: MongoDB, Neo4j, etc
• Experience with cloud services: GCP, AWS, etc
• Experience with object-oriented/object function scripting languages: Python, Java, 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.

Every one of our employees plays an important role in ensuring we deliver the quality products consumers rely on to care for themselves and the ones they love. So we recognize that our success is driven by these talented and dedicated Colgate people around the world. And in turn we are dedicated to the success of our people, offering an array of resources to help expand their professional and personal horizons - from stimulating career opportunities and access to world-class training and leadership development programs, to wellness initiatives and opportunities to contribute to the communities where we live and work.