Data Ingestion Specialist

2 months ago


Ajax, Ontario, Canada Colgate Full time
Job Title: Platform Engineer - Data Ingestion

Colgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable, and programs that enrich communities around the world.

As a Platform Engineer - Data Ingestion, you will play a critical role in maintaining and supporting the data ingestion tools that are used in Colgate for extracting data and taking complete ownership of these tools. You must be self-directed and comfortable supporting the data needs of multiple teams, systems and products.

Key Responsibilities:
  • Supporting/ Monitoring all the existing data ingestion tools in the organization.
  • Identify, design, and implement internal process improvements automating manual processes, optimizing data delivery, redesigning infrastructure for greater scalability, etc.
  • Work with partners including the Executive, Product, Data and Design teams to assist with data related technical issues and support their data infrastructure needs.
  • Collaborate, coordinate, and communicate across teams, departments, and segments.
  • Create and update documentation for the purposes of architectural governance and support or the tools that are used.
  • Assist in educating others on standard processes surrounding data ingestion work (i.e. data modeling, database design, ETL design, job scheduling and monitoring, etc.)
  • Ensuring the ideal utilization of the warehouses with respect of cost is looked after for data ingestion tools.
  • Performs support related activities specific to the platforms supported by the team.
  • Follows all policies and standards.
Requirements:
  • Bachelor's Degree or relevant.
  • Around 3 - 4 years of experience with data ingestion tools and data pipeline support work.
  • Working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
  • 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.
Preferred Qualifications:
  • Master's Degree Computer Science, Statistics, Informatics, Information Systems or another quantitative field a plus.
  • Experience with data ingestion tools like HVR, SAP Data Intelligence, SAP BTP solution, Airbyte, other open source ingestion 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.

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.



  • Ajax, Ontario, Canada Colgate Full time

    About ColgateColgate is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable, and programs that enrich communities around the...


  • Ajax, Ontario, Canada Colgate Full time

    About ColgateColgate is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable, and programs that enrich communities around the...


  • Ajax, Ontario, Canada Colgate Full time

    Job Title: Platform Engineer SpecialistColgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable, and programs...


  • Ajax, Ontario, Canada Colgate Full time

    Job Title: Specialist / Sr. Specialist, Platform EngineerColgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more...


  • Ajax, Ontario, Canada Colgate Full time

    Job Title: Specialist / Sr. Specialist, Platform EngineerColgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more...


  • Ajax, Ontario, Canada Colgate Full time

    Job Title: Platform Engineer SpecialistColgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition.We are committed to offering products that make lives healthier and more enjoyable, and programs...


  • Ajax, Ontario, Canada Colgate Full time

    Job Title: Platform Engineer SpecialistColgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition.We are committed to offering products that make lives healthier and more enjoyable, and programs...


  • Ajax, Ontario, Canada Colgate Full time

    About the RoleWe are seeking a highly skilled Platform Engineer - Data Ingestion to join our Information Technology team at Colgate. As a key member of our team, you will be responsible for maintaining and supporting our data ingestion tools, ensuring seamless data extraction and processing.Key ResponsibilitiesDesign, implement, and maintain data ingestion...


  • Ajax, Ontario, Canada Colgate Full time

    About the RoleWe are seeking a highly skilled Platform Engineer - Data Ingestion to join our Information Technology team at Colgate. As a key member of our team, you will be responsible for maintaining and supporting our data ingestion tools, ensuring seamless data extraction and processing.Key ResponsibilitiesDesign, implement, and maintain data ingestion...


  • Ajax, Ontario, Canada Colgate Full time

    About the RoleWe are seeking a highly skilled Platform Engineer - Data Ingestion to join our Information Technology team at Colgate. As a key member of our team, you will be responsible for maintaining and supporting our data ingestion tools, ensuring seamless data extraction and processing.Key ResponsibilitiesSupport and maintain existing data ingestion...


  • Ajax, Ontario, Canada Colgate Full time

    About the RoleWe are seeking a highly skilled Platform Engineer - Data Ingestion to join our Information Technology team at Colgate. As a key member of our team, you will be responsible for maintaining and supporting our data ingestion tools, ensuring seamless data extraction and processing.Key ResponsibilitiesSupport and maintain existing data ingestion...


  • Ajax, Ontario, Canada Colgate Full time

    About the RoleWe are seeking a highly skilled Platform Engineer - Data Ingestion to join our Information Technology team at Colgate. As a key member of our team, you will be responsible for maintaining and supporting our data ingestion tools, ensuring seamless data extraction and processing.Key ResponsibilitiesSupport and maintain existing data ingestion...


  • Ajax, Ontario, Canada Colgate Full time

    About the RoleWe are seeking a highly skilled Platform Engineer - Data Ingestion to join our Information Technology team at Colgate. As a key member of our team, you will be responsible for maintaining and supporting our data ingestion tools, ensuring seamless data extraction and processing.Key ResponsibilitiesSupport and maintain existing data ingestion...


  • Ajax, Ontario, Canada Colgate Full time

    About the RoleWe are seeking a highly skilled Platform Engineer - Data Ingestion to join our Information Technology team at Colgate. As a key member of our team, you will be responsible for maintaining and supporting our data ingestion tools, ensuring seamless data extraction and processing.Key ResponsibilitiesSupport and maintain existing data ingestion...


  • Ajax, Ontario, Canada Colgate Full time

    About the RoleWe are seeking a highly skilled Platform Engineer - Data Ingestion to join our Information Technology team at Colgate. As a key member of our team, you will be responsible for maintaining and supporting our data ingestion tools, ensuring seamless data extraction and processing.Key ResponsibilitiesSupport and maintain existing data ingestion...


  • Ajax, Ontario, Canada Colgate Full time

    Job Title: Platform Engineer SpecialistColgate is seeking a highly skilled Platform Engineer Specialist to join our Information Technology team. As a Platform Engineer Specialist, you will be responsible for maintaining and supporting data ingestion tools, ensuring the ideal utilization of warehouses, and providing solutions pertaining to the...


  • Ajax, Ontario, Canada Colgate Full time

    Job Title: Platform Engineer SpecialistColgate is seeking a highly skilled Platform Engineer Specialist to join our Information Technology team. As a Platform Engineer Specialist, you will be responsible for maintaining and supporting data ingestion tools, ensuring the ideal utilization of warehouses, and providing solutions pertaining to the...

  • Platform Engineer

    3 weeks ago


    Ajax, Ontario, Canada Colgate Full time

    Job Title: Specialist / Sr. Specialist, Platform EngineerColgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more...


  • Ajax, Ontario, Canada Apgar Consulting SARL Full time

    About the RoleWe are seeking a highly skilled Data Solutions Expert to join our team at Apgar Consulting SARL. As a key member of our team, you will be responsible for designing and implementing technical phases of MDM implementation projects, coordinating technical activities of a team of developers, and operating instructions and working on definition of...


  • Ajax, Ontario, Canada Apgar Consulting SARL Full time

    About the RoleWe are seeking a highly skilled Data Solutions Expert to join our team at Apgar Consulting SARL. As a key member of our team, you will be responsible for designing and implementing technical phases of MDM implementation projects, coordinating technical activities of a team of developers, and operating instructions and working on definition of...