Colgate-Palmolive
Analytics Engineer
Colgate-Palmolive, Piscataway, New Jersey, us, 08854
No Relocation Assistance Offered
# 163266 - Piscataway, New Jersey, United States
Who We Are
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!
Colgate-Palmolive invites you to apply for an Analytics Engineer position based in our Piscataway, NJ location.
Our Analytics Engineer develops digital infrastructure and data pipelines to accelerate product innovation, product design, and product development. You will work with cross functional teams to gather, wrangle, cleanse, structure and build data products that support the analytics goals of the Global Technology community and the broader organization. The Analytics Engineer builds and maintains the foundational data analytics infrastructure to enable new revenue-generating business models and improve underlying business processes for cost savings. You will lead, manage, and mentor others to expand the team’s capabilities and collective knowledge.
What you will do
Use SQL and Python to write production-quality code to meet the data transformation needs of analysts, data scientists, and other business partners
Support the use of analytics platforms and data science workflows, while identifying ways to strengthen and scale our data foundation
Help design and develop transparent ELT pipelines that deliver timely and accurate data to end users
Translate business requirements and logic into well-documented data models to drive clarity and efficiency for end users
Collaborate cross functionally to understand and identify data needs and opportunities to use data to drive business solutions
Communicate technical concepts to a non-technical audience in a compelling manner
Evaluate external partners across different dimensions for analytics initiatives
Partner with IT to align on data architecture, analytics tools, and other technologies
Performs other duties as assigned
Complies with all policies and standards
Required Qualifications
Bachelors’ Degree in Science, Technology, Engineering, Math or Computer Science
4+ years of Data Engineering experience
High level of Python & SQL proficiency
Experience building ETL/ELT pipelines
Strong familiarity with cloud computing platforms
Strong familiarity with SAP S4/ECC tables
Preferred Qualifications
Consumer Goods Proven Experience
Active GitHub account with examples of past work is helpful
Master’s Degree or Professional Certification in Data Engineering or Cloud Computing Platform
Proficiency with at least one other programming language in addition to Python
Familiarity with Google Cloud Platform
Familiarity with Apache Airflow
Familiarity with dbt
Familiarity with Snowflake or Google Big Query
Familiarity with data analytics workflows, objectives, tech stacks, common terminology
Compensation and Benefits
Salary Range $91,200.00 - $140,000.00 USD
Pay is based on multiple non-discriminatory, individualized factors including but not limited to experience, job-related knowledge and education, skills and office/market location. In addition to base salary, salaried employees are eligible for annual discretionary bonuses, profit-sharing and, for Executive-level (salary grade 16 and above) roles only, long-term incentives in the form of Restricted Stock Units and/or Stock Options.
Subject to the terms and conditions of the applicable benefits plans then in effect, all salaried employees are also eligible for a competitive benefits package which includes:
Insurance: Employees (and their eligible dependents) are eligible to participate in Company-sponsored Medical, Dental, Vision, Basic Life Insurance, Accidental Death & Dismemberment and Disability insurance plans.
Retirement Plans: Employees are eligible to enroll in Colgate's 401(k) plan, which provides for company matching contributions subject to eligibility requirements
Vacation/PTO: Employees receive a minimum of 15 days of vacation/PTO leave annually
Paid Holidays: Employees receive a minimum of 13 paid/floating holidays annually
Paid Sick Leave: Based on location and consistent with applicable state and local law, employees receive a minimum of 40 hours of paid sick leave on January 1st of each year
Paid Parental Leave: Eligible employees may take up to eight weeks of paid parental leave and 12 weeks of unpaid leave (varies for employees with fewer than 12 months of service and is subject to hours worked requirements)
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.
For additional Colgate terms and conditions, please click here (https://www.colgatepalmolive.com/content/dam/cp-sites/corporate/corporate/en_us/corp/locale-assets/pdf/colgate-terms-and-conditions-2023.pdf) .
#LI-Hybrid
# 163266 - Piscataway, New Jersey, United States
Who We Are
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!
Colgate-Palmolive invites you to apply for an Analytics Engineer position based in our Piscataway, NJ location.
Our Analytics Engineer develops digital infrastructure and data pipelines to accelerate product innovation, product design, and product development. You will work with cross functional teams to gather, wrangle, cleanse, structure and build data products that support the analytics goals of the Global Technology community and the broader organization. The Analytics Engineer builds and maintains the foundational data analytics infrastructure to enable new revenue-generating business models and improve underlying business processes for cost savings. You will lead, manage, and mentor others to expand the team’s capabilities and collective knowledge.
What you will do
Use SQL and Python to write production-quality code to meet the data transformation needs of analysts, data scientists, and other business partners
Support the use of analytics platforms and data science workflows, while identifying ways to strengthen and scale our data foundation
Help design and develop transparent ELT pipelines that deliver timely and accurate data to end users
Translate business requirements and logic into well-documented data models to drive clarity and efficiency for end users
Collaborate cross functionally to understand and identify data needs and opportunities to use data to drive business solutions
Communicate technical concepts to a non-technical audience in a compelling manner
Evaluate external partners across different dimensions for analytics initiatives
Partner with IT to align on data architecture, analytics tools, and other technologies
Performs other duties as assigned
Complies with all policies and standards
Required Qualifications
Bachelors’ Degree in Science, Technology, Engineering, Math or Computer Science
4+ years of Data Engineering experience
High level of Python & SQL proficiency
Experience building ETL/ELT pipelines
Strong familiarity with cloud computing platforms
Strong familiarity with SAP S4/ECC tables
Preferred Qualifications
Consumer Goods Proven Experience
Active GitHub account with examples of past work is helpful
Master’s Degree or Professional Certification in Data Engineering or Cloud Computing Platform
Proficiency with at least one other programming language in addition to Python
Familiarity with Google Cloud Platform
Familiarity with Apache Airflow
Familiarity with dbt
Familiarity with Snowflake or Google Big Query
Familiarity with data analytics workflows, objectives, tech stacks, common terminology
Compensation and Benefits
Salary Range $91,200.00 - $140,000.00 USD
Pay is based on multiple non-discriminatory, individualized factors including but not limited to experience, job-related knowledge and education, skills and office/market location. In addition to base salary, salaried employees are eligible for annual discretionary bonuses, profit-sharing and, for Executive-level (salary grade 16 and above) roles only, long-term incentives in the form of Restricted Stock Units and/or Stock Options.
Subject to the terms and conditions of the applicable benefits plans then in effect, all salaried employees are also eligible for a competitive benefits package which includes:
Insurance: Employees (and their eligible dependents) are eligible to participate in Company-sponsored Medical, Dental, Vision, Basic Life Insurance, Accidental Death & Dismemberment and Disability insurance plans.
Retirement Plans: Employees are eligible to enroll in Colgate's 401(k) plan, which provides for company matching contributions subject to eligibility requirements
Vacation/PTO: Employees receive a minimum of 15 days of vacation/PTO leave annually
Paid Holidays: Employees receive a minimum of 13 paid/floating holidays annually
Paid Sick Leave: Based on location and consistent with applicable state and local law, employees receive a minimum of 40 hours of paid sick leave on January 1st of each year
Paid Parental Leave: Eligible employees may take up to eight weeks of paid parental leave and 12 weeks of unpaid leave (varies for employees with fewer than 12 months of service and is subject to hours worked requirements)
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.
For additional Colgate terms and conditions, please click here (https://www.colgatepalmolive.com/content/dam/cp-sites/corporate/corporate/en_us/corp/locale-assets/pdf/colgate-terms-and-conditions-2023.pdf) .
#LI-Hybrid