Apply for this job now

Lead Data Engineer

Piscataway, New Jersey
Job Type
1 Aug 2022
No Relocation Assistance Offered
# 136300 - Piscataway, New Jersey, United States

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

This position has a full remote option with preference in Piscataway, NJ location.

Data Engineers focus on expanding and optimizing our data, data pipeline architecture, data flow and collection for multi-functional teams. The Lead Data Engineer will be a highly experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. You will lead a team of data engineers who 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!

What you will do:
Provide Leadership
Manage a portfolio of data engineering projects with a team of 3-5 data engineers reporting directly to you
Drive the development, implementation, and documentation of data engineering best practices throughout the organization
Collaborate with data and analytics leadership to strive for greater functionality in our data systems
Provide thought leadership around new technology platforms that will improve our data engineering practice
Provide Functional Expertise
Define, build, and maintain optimal data pipeline architecture
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Define and build the infrastructure required for efficient extraction, transformation, and loading of data from a wide variety of data sources
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 products into innovative industry leaders
Manage the resolution of data-related technical issues and support business owners data infrastructure needs
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Comply with all policies and standards

Required Qualifications
Bachelor's degree in Computer Science, Information Technology, Engineering, similar degree or experience.
Advanced knowledge of the Python programming language and common libraries, including pandas and numpy
5 or more years of experience in a Data Engineering 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 analytical skills related to working with structured and 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
1 or more years of experience managing a team of data engineers
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.

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.

Are you interested in working for Colgate-Palmolive? You can apply online and attach all relevant documents such as a cover letter and resume or CV. Applications received by e-mail are not considered in the selection process. Become part of our team. We look forward to your application.

Colgate-Palmolive is a leading global consumer products company, tightly focused on Oral Care, Personal Care, Home Care and Pet Nutrition. Colgate sells its products in over 200 countries and territories around the world under such internationally recognized brand names as Colgate, Palmolive, elmex, Tom s of Maine, Sorriso, Speed Stick, Lady Speed Stick, Softsoap, Irish Spring, Protex, Sanex, Elta MD, PCA Skin, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill s Science Diet and Hill s Prescription Diet.

For more information about Colgate s global business, visit the Company s web site at . To learn more about Colgate Bright Smiles, Bright Futures oral health education program, please visit . To learn more about Hill's and the Hill s Food, Shelter & Love program please visit . To learn more about Tom s of Maine please visit .

Reasonable accommodation during the application process is available for persons with disabilities. Please contact with the subject "Accommodation Request" should you require accommodation.
Apply for this job now


  • Job Reference: 674041789-2
  • Date Posted: 1 August 2022
  • Recruiter: Colgate-Palmolive
  • Location: Piscataway, New Jersey
  • Salary: On Application
  • Sector: I.T. & Communications
  • Job Type: Permanent