Skip to main content
Colgate-Palmolive logo

Regulatory Affairs Data Specialist

Colgate-Palmolive

Piscataway, NJContract$86–121K/yrSeen 2 days agoIn the employer's feed · checked in the last 2 days

See where you stand before you apply. No sign-up to start.

You apply on the posting's application page, with no Olive account needed.

Watch jobs like this.

Don't just apply. Show up ready.

Olive works from this exact posting.

At a glance

Compensation
$86–121K/yr
Location
Piscataway, NJ
Schedule
Contract
Work Authorization
Not specified

Olive focuses on jobs in the United States, including remote roles you can work from there.

Requirements

Credentials this posting asks for.

Bachelor's degree, required

Job overview

The Regulatory Affairs Data Specialist develops data infrastructure and pipelines supporting product innovation, registrations, regulatory compliance, and analytics. The role structures product data across the SKU lifecycle and supports AI-enabled regulatory analysis under North American frameworks. It works with cross-functional teams and leads, manages, and mentors others. The position is a two-year contract based in Piscataway, New Jersey.

Skills & qualifications

RequiredNice to have

Skills

Python, requiredSQL, requiredETL/ELT Pipelines, requiredCloud Computing Platforms, requiredEnglish, requiredConsumer Goods Experience, nice to haveRegulatory Environments, nice to haveGitHub, nice to haveData Engineering, nice to haveCloud Computing, nice to haveAdditional Programming Language, nice to haveGoogle Cloud Platform, nice to haveApache Airflow, nice to haveDbt, nice to haveSAP S4/ECC, nice to haveSnowflake, nice to haveGoogle BigQuery, nice to haveData Analytics Workflows, nice to have

Qualifications

Bachelor's in STEM or CS, required3+ Years Data Engineering Experience, requiredMaster's Degree or Professional Certification, nice to have

Benefits

Medical Insurance
Dental Insurance
Vision Insurance
Parental Leave
401(k) Match
Paid Time Off

Full job description

No Relocation Assistance Offered

Job Number #177413 - Piscataway, New Jersey, United States

Who We Are

Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specializing in Oral Care, Personal Care, Home Care, Skin Care, and Pet Nutrition. Our products are trusted in more households than any other brand in the world, making us a household name!

Join Colgate-Palmolive, a caring, innovative growth company reimagining a healthier future for people, their pets, and our planet. Guided by our core values—Caring, Inclusive, and Courageous—we foster a culture that inspires our people to achieve common goals. Together, let's build a brighter, healthier future for all.

Title Position: Regulatory Affairs Data Specialist (2 year contract)

Location : Piscataway, NJ location

Reports into: Sr. Director Regulatory Affairs

The Regulatory Data Specialist develops digital infrastructure and data pipelines to accelerate

product innovation, development and registrations with targeted support of regulatory

compliance. A core focus of this role is ensuring comprehensive data availability across the

entire lifecycle of our SKUs, enabling seamless traceability from R&D formulation through

commercialization and post-market surveillance. You will work with cross functional teams to

gather, wrangle, cleanse, structure and build data products that support the analytics goals of

Regulatory Affairs, the Global Technology community and the broader organization. Of focus

will be to support the AI infrastructure development and data pipelines to support rapid and

comprehensive Regulatory analysis. By structuring complex product data, you will directly

safeguard our portfolio's compliance with strict North American regulatory frameworks,

including FDA, EPA, and Health Canada mandates. The Data Specialist also builds and maintains

the foundational data analytics infrastructure to improve underlying business processes for cost

savings. You will lead, manage, and mentor others to expand the team’s capabilities and

collective knowledge.

Principal Duties and Responsibilities:

  • 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

  • Architect data models that map the complete SKU lifecycle - capturing raw

ingredient origins, formulation changes, manufacturing sites, and distribution, to

guarantee instant data availability for regulatory submissions

  • Build and maintain automated ELT pipelines that aggregate the exact data required

to meet specific NA regulatory obligations (e.g., FDA MoCRA, Health Canada

regulations, EPA requirements, and state-level mandates)

  • 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 problem statements, data

needs and opportunities to use data to drive business solutions

  • Engage with Regulatory Affairs to translate complex North American compliance

requirements into well-documented data models to deliver high value data

products, and ensure our AI infrastructure can rapidly conduct comprehensive

regulatory analysis.

  • 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

  • A minimum of 3 years of Data Engineering experience

  • High level of Python proficiency

  • High level of proficiency with SQL

  • Experience building ETL/ELT pipelines

  • Strong familiarity with cloud computing platforms

  • Strong oral and written English skills

Preferred qualifications include:

  • Consumer Goods Proven Experience is preferred

  • Understanding of Regulatory environments and regulations for drugs, cosmetics

and/or medical devices

  • 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

  • Strong familiarity with SAP S4/ECC tables

  • Familiarity with Snowflake or Google Big Query are preferred

  • Familiarity with data analytics workflows, objectives, tech stacks, common

terminology

We are a results oriented company with a caring culture and work life balance. Apply with us!

Come and join our outstanding team!

Compensation and Benefits

Salary Range $86,000.00 - $121,000.00 USD

Pay is determined based on experience, qualifications, and location. Salaried employees may also be eligible for discretionary bonuses, profit-sharing, and long-term incentives for Executive-level roles.

Benefits: Salaried employees enjoy a comprehensive benefits package, including medical, dental, vision, basic life insurance, paid parental leave, disability coverage, and participation in the 401(k) retirement plan with company matching contributions subject to eligibility requirements. Additional benefits include a minimum of 15 vacation/PTO days (hourly employees receive a minimum of 120 hours) and 13 paid holidays (vacation days are prorated based on the employee's hire date within the calendar year). Paid sick leave is adjusted based on role and location in accordance with local laws. Detailed information regarding paid sick leave entitlements will be provided to employees upon hiring and may be subject to adjustments based on changes in legislation or company policies.

Our Commitment to Inclusion

Our journey begins with our people—developing strong talent with diverse backgrounds and perspectives to best serve our consumers around the world and fostering an inclusive environment where everyone feels a true sense of belonging. We are dedicated to ensuring that each individual can be their authentic self, is treated with respect, and is empowered by leadership to contribute meaningfully to our business.

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 complete this request form (https://docs.google.com/forms/d/e/1FAIpQLSdaxk\_eF4utznQoVHlxmL9jVFJbOkM4Oe5CAdKOg-h9EPdLfg/viewform) 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-On-site

How this job compares

Set against the 3,140 open Data Engineering jobs on Olive Jobs, counted November 16, 2026.

Pay
  • This posting$86–121K/yr
  • New Jersey median$131–206K/yr87 salary ranges
  • US median$124–214K/yr2,627 salary ranges

This range's midpoint, $104K, is 40% below the New Jersey median midpoint ($174K) — in the lowest quarter of Data Engineering salary ranges in New Jersey.

Openings
Olive Jobs lists 94 open Data Engineering jobs in New Jersey and 3,140 across the US. 8% of them nationwide are listed as remote or flexible.
Hiring the most in New Jersey
Experience
This posting asks for at least 3 years of experience — less than three in four Data Engineering postings that state a minimum ask for (median 5 years, across 2,773 postings).
Education
This posting asks for a bachelor's degree; 1,237 of the 3,140 open Data Engineering jobs (39%) ask for a bachelor's degree or higher.

Counted across the open, public US postings on Olive Jobs on November 16, 2026. Figures based on too few postings are left out.

Prepare for this role

You've read the whole posting — now see how you match it.