Back to jobs

Regulatory Affairs Data Specialist

Pay
USD 86,000–121,000/yearAnnual period assumed. Location-specific pay — pay source
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.
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Build and maintain automated ELT pipelines for North American regulatory data needs

  • Architect data models covering raw ingredients, formulas, manufacturing sites and distribution

  • Write production-quality SQL and Python for analysts and data scientists

  • Translate regulatory compliance requirements into documented data products

  • Partner with IT on data architecture and analytics tools

From the employer’s posting
Build and maintain automated ELT pipelines that aggregate the exact data required to meet specific NA regulatory obligations
Architect data models that map the complete SKU lifecycle - capturing raw ingredient origins, formulation changes, manufacturing sites, and distribution
Use SQL and Python to write production-quality code to meet the data transformation needs of analysts, data scientists, and other business partners
translate complex North American compliance requirements into well-documented data models
Partner with IT to align on data architecture, analytics tools, and other technologies

Before you apply

Employer’s visa record
9 H-1B petitions approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.
Education & alternatives
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!

About Colgate-Palmolive

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.

In the employer’s words · Read in context

Apply at Colgate-Palmolive

Posting record

Report an error
Status in our records
Live
First seen by us
Nov 13, 20268 days ago
Recorded sightings
10
Last seen by us
Nov 22, 2026
Reposted
once since Oct 27, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications. We count a repost when the same title and location comes back as a new listing within 60 days of the last one coming down. Some hiring systems expire listings on a schedule, so repost rates vary by system.

How this job compares

Pay

Lower than most similar jobs

$86K–$121K against $127K–$189K, the middle half of what similar US postings state.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 8

Similar jobs usually come down between day 6 and day 56.

At Colgate-Palmolive, jobs usually come down by about day 24.

From 14,766 similar postings that came down, and 101 of Colgate-Palmolive’s. Coming down is not always a hire.

Colgate-Palmolive is hiring

44 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring at a steady pace
  • Takes jobs down at a usual pace
  • 9% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • BigQuery
  • dbt
  • Snowflake
  • Airflow
  • GCP
Where the posting names them
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
● 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
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!

Your next step

Complete your application on jobs.colgate.com. The employer’s form will show what is required.

Applying through SAP SuccessFactors

  • Images (.jpg) aren’t accepted as a resume.

Already applied? Track this application

Has Colgate-Palmolive posted this job before?

Yes. We’ve followed one other Regulatory Affairs Data Specialist job there since October 2026. It is still up.

  1. PiscatawayStill up after 25 days, first seen Oct 27
  2. This jobUp 9 days so far, first seen Nov 13

Job description

View original posting ↗

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 should you require accommodation.

For additional Colgate terms and conditions, please click here.

#LI-On-site

About Colgate-Palmolive

People
About 33,600 in 2025, down 1% from the year before.Annual report (SEC Form 10-K)
Company
Listed as CL.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
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.
Location & working pattern

Piscataway, NJ, US

For additional Colgate terms and conditions, please click here. #LI-On-site
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.