Regulatory Affairs Data Specialist

BSBF

Piscataway Township (NJ)

On-site

USD 86,000 - 121,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Paid vacation
Paid holidays
401(k) match
Medical/dental/vision
Parental leave
Disability coverage

Job summary

Colgate-Palmolive Company in Piscataway, NJ is seeking a Regulatory Affairs Data Specialist (2 year contract) to build data pipelines and support regulatory submissions across NA frameworks.

You will collaborate with Regulatory Affairs, IT, and data scientists to enable rapid regulatory analysis, ensure traceability from R&D to post-market, and help shape AI infrastructure for compliance.

Qualifications

  • Bachelor’s Degree in Science, Technology, Engineering, Math or Computer Science.
  • Minimum 3 years of Data Engineering experience.
  • High level of Python proficiency.
  • High level of SQL proficiency.
  • Experience building ETL/ELT pipelines.
  • Strong familiarity with cloud computing platforms.
  • Strong oral and written English skills.

Responsibilities

  • Use SQL and Python to write production-quality code for data transformation needs.
  • Support analytics platforms and data science workflows; scale data foundation.
  • Architect data models mapping the complete SKU lifecycle for regulatory submissions.
  • Build and maintain automated ELT pipelines for NA regulatory obligations.
  • Translate business requirements into well-documented data models for end users.
  • Collaborate cross-functionally to identify data needs and opportunities.
  • Engage with Regulatory Affairs to deliver data products for AI-based analysis.
  • Communicate complex concepts to a non-technical audience.
  • Evaluate external partners for analytics initiatives.
  • Partner with IT to align data architectures and tools.

Skills

Python
SQL
Data engineering
ETL/ELT pipelines
Cloud computing
English proficiency

Education

Bachelor's degree in Science/Engineering/Math/CS
Master’s degree in Data Engineering/Cloud Computing (preferred)

Tools

Google Cloud Platform
Snowflake
BigQuery
dbt
Apache Airflow
GitHub
SAP S4/ECC tables

Job description

Established in 1806 as a small soap and candle business in New York City, Colgate-Palmolive is now a truly global company with products sold in over 200 countries and territories under such internationally recognized brand names as Colgate, Palmolive, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, elmex, Tom's of Maine, Sanex, Ajax, Axion, Soupline, Haci Sakir, Suavitel, PCA SKIN, EltaMD, Filorga and Hello as well as Hill's Science Diet and Hill's Prescription Diet.

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.

Every day millions of people trust our products to care for themselves and the ones they love. Our goal is to use our technology to create products that will continue to improve the quality of life for our consumers wherever they live.

A career at Colgate-Palmolive is an excellent opportunity if you seek a global experience, constant challenge, and development opportunities in an environment that respects work/life effectiveness.

Job Title: Regulatory Affairs Data Specialist

Travel Required?: Travel - up to 10% of time

Posting Start Date: 11/13/26

On-site

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.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Manager, Regulatory Affairs
Sr. Manager, Regulatory Affairs

BSBF • Piscataway Township (NJ)

On-site
USD 139,000 - 174,000
Manager, Data Strategy & Transformation
Manager, Data Strategy & Transformation

BSBF • Piscataway Township (NJ)

Hybrid
USD 124,000 - 174,000
Hybrid work model
Data Engineer
Data Engineer

Colgate-Palmolive • Piscataway Township (NJ)

On-site
USD 97,000 - 137,000
Medical insurance
Dental insurance
Vision insurance
+5
Sr. Data Engineer
Sr. Data Engineer

Colgate-Palmolive Company • Piscataway Township (NJ)

Hybrid
USD 115,000 - 174,000
Data Architect - Global Technology
Data Architect - Global Technology

Colgate-Palmolive • Piscataway Township (NJ)

Hybrid
USD 86,000 - 121,000
Medical benefits
401(k) matching
Paid time off
Regulatory Affairs Project Manager
Regulatory Affairs Project Manager

Colgate-Palmolive • Piscataway Township (NJ)

On-site
USD 124,000 - 155,000
Medical, dental, vision
401(k) with company match
Paid vacation and holidays
+1
Data Architect - Global Technology
Data Architect - Global Technology

Colgate-Palmolive • Piscataway Township (NJ)

Hybrid
USD 86,000 - 121,000
Medical, dental, vision insurance
Basic life insurance
Paid parental leave
+5
Sr. Manager, Customer Analytics and Experience
Sr. Manager, Customer Analytics and Experience

Colgate-Palmolive • Piscataway Township (NJ)

On-site
USD 139,000 - 174,000
Health benefits
Paid time off
Global Consumer Affairs Brand Integration Specialist
Global Consumer Affairs Brand Integration Specialist

Colgate-Palmolive • Piscataway Township (NJ)

Hybrid
USD 97,000 - 121,000
Medical benefits
401(k) plan
Paid time off
+1
Data Architect - Global Technology (177245)
Data Architect - Global Technology (177245)

Colgate-Palmolive • Piscataway Township (NJ)

Hybrid
USD 86,000 - 121,000