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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10112870
- Position Id: 6ed749343a8cdf66093dac463e73d68a
- Posted 36 minutes ago