Colgate Palmolive

Data Architect

Colgate Palmolive$106K — $155K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science, Industrial Engineering, Supply Chain, or a related quantitative field.
  • 4+ years of experience in Data Engineering & Data Architecting.
  • Hands-on experience with Python, SQL, dbt, and Airflow.
  • Experience creating Entity Relationship Diagrams (ERDs) and Data Flow Diagrams (DFDs).
  • Familiarity with Snowflake as a Data Warehouse.

Responsibilities

  • Resolve technical blockers across Python, SQL, Snowflake, and dbt pipelines.
  • Conduct GitHub PR reviews to enforce testing, quality, and standards.
  • Ensure compliance with cloud data warehousing and orchestration standards like Airflow and GKE.
  • Deliver impactful datasets for core metrics sourced from SAP, Kinaxis, and WMS/TMS tools.
  • Manage sprint backlogs, project timelines, and resources across multiple initiatives.

Benefits

  • Comprehensive medical, dental, and vision insurance.
  • Basic life insurance and disability coverage.
  • Paid parental leave and participation in a 401(k) retirement plan with company matching.
  • Minimum of 15 vacation/PTO days and 13 paid holidays.
  • Paid sick leave adjusted according to local laws.
Full Job Description
No Relocation Assistance Offered
Job Number #175991 - Piscataway, New Jersey, United States

As our Data Architect, you are a hands-on technical driver who bridges business strategy and data engineering, working side-by-side with our Data Delivery Leads & Data Engineers to build and ship high-performance data products on time. Instead of managing from the sidelines, you will dive deep into code to unblock engineers, optimize data pipelines, and keep our supply chain logistics running seamlessly so products reach store shelves clean and fresh.

This position is based out of the Piscataway, NJ location. Work visa sponsorship is not available for this position.

The impact you'll make
  • Serve as the hands-on lead resolving technical blockers across Python, SQL, Snowflake, and dbt pipelines.
  • Perform GitHub PR reviews to enforce testing, quality, and platform standards.
  • Ensure all engineering aligns with modern cloud data warehousing and orchestration standards (Airflow / GKE).
  • Deliver high-impact datasets for core metrics (OTIF, Forecast Accuracy, Inventory) sourced from SAP, Kinaxis, and WMS/TMS tools.
  • Manage sprint backlogs, project timelines, internal engineers, and third-party consultants across concurrent initiatives.


What You'll Bring to the Team

Required Qualifications
    Bachelor's degree in Computer Science, Industrial Engineering, Supply Chain, or a related quantitative field.
  • 4+ years total in Data Engineering & Data Architecting
  • Hands-on experience with Python, SQL, dbt, Airflow.
  • Hands-on experience creating ERDs and DFDs
  • Data Warehouse experience (Snowflake preferred).


Preferred Qualifications
    Background in Consumer Packaged Goods or high-volume retail/logistics environments.
  • Exposure to automated testing tools like Great Expectations, Monte Carlo, or dbt tests.
  • Experience using Lucid


Compensation and Benefits
Salary Range $106,400.00 - $155,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.

#LI-Hybrid

About Colgate Palmolive

Colgate-Palmolive Company (Colgate) is a consumer products company whose products are marketed in over 200 countries and territories throughout the world. It operates in two segments: Oral, Personal and Home Care and Pet Nutrition. Oral Care business products include Colgate Total, Colgate Sensitive Pro-Relief, Colgate Max Fresh, Colgate Optic White, and Colgate Luminous White toothpastes, Colgate 360° manual toothbrushes and Colgate and Colgate Plax mouth rinses. Colgate's Oral Care business also includes dental floss and pharmaceutical products for dentists and oral health professionals. Its Personal Care products also include Palmolive, Softsoap and Sanex brand shower gels, Palmolive, Irish Spring, and Protex bar soaps and Speed Stick, Lady Speed Stick and Sanex deodorants and antiperspirants. It sells liquid hand soap under the Palmolive, Protex and Softsoap brands. Colgate, through its Hill's Pet Nutrition segment (Hill's), manufactures pet nutrition products for dogs and cats.

Colgate-Palmolive Careers

Join the vibrant team at Colgate-Palmolive, a global leader in oral care, personal care, and pet nutrition, where innovation, leadership, and care converge to create outstanding job opportunities. At Colgate-Palmolive, we are committed to offering more than just employment; we are dedicated to providing a platform where careers flourish and talents shine.

Work You’ll Do

At Colgate-Palmolive, every position is a chance to enhance global health and well-being. Whether you're involved in product development, marketing, finance, or technology, you'll contribute to projects that touch lives worldwide. Our team's diversity and commitment to inclusive leadership help foster an environment where new ideas and perspectives lead to dynamic solutions.

Innovate and Grow

Join a company renowned for innovation and set your career on a trajectory of growth and discovery. Colgate-Palmolive is the perfect place to challenge your skills and expand your horizons. Here, innovation isn't just another buzzword—it's a practical part of how we approach solutions and processes to improve the lives of our consumers.

Be Part of a Great Team

Our culture is all about collaboration and teamwork. At Colgate-Palmolive, you’ll work alongside professionals who are leaders in their fields, united by a common goal to make every day better for people around the globe. Our team is supported by robust diversity training programs that enhance understanding and drive innovation.

Future-Proof Your Career

With a multitude of career paths and job opportunities at all levels, Colgate-Palmolive empowers you to tailor your career journey. From internships to leadership roles, every career stage at Colgate-Palmolive is supported by extensive training and professional development opportunities, ensuring that your career aspirations have no limits.

Explore Job Opportunities and Internships

Whether you're a seasoned professional or a recent graduate, Colgate-Palmolive offers a range of opportunities. Explore positions that match your skills and interests through our job portal. We are continuously hiring and looking for curious, creative, and driven individuals to join our team.

Networking and Professional Development

At Colgate-Palmolive, career growth is complemented by opportunities for networking and professional development. Engage with leaders and peers at all levels and take advantage of our comprehensive benefits and programs designed to enhance your life both inside and outside of work.

Prepare for Your Interview

Ready to join us? Polish your resume, prepare for your interview, and show us why you are a perfect fit for our team. At Colgate-Palmolive, we value a straightforward and insightful interview process that seeks out individuals eager to contribute and grow.

Stay Connected

Keep up to date with the latest at Colgate-Palmolive: - **Career Tips**: Get insider perspectives and industry-leading insights you can use today—all from the people who work here. - **Job Alert Emails**: Personalize your subscription to receive job alerts and the latest news tailored to your preferences. Discover the exciting and rewarding opportunities that await at Colgate-Palmolive. Join Colgate-Palmolive and be part of a company that believes in growth, innovation, and the power of a diverse team to lead the industry forward. Explore our careers page and find out how your skills and passions can make a difference at one of the most respected companies in the world.
Learn more about Colgate Palmolive
Size
33,800 employees
Market Cap
$66.6 billion
Industry
Net Income
$2.6 billion
Founded
1806
5 Year Trend
+2.8%
Revenue
$16.4 billion
NASDAQ

Similar Jobs

More Jobs at Colgate Palmolive

More Information Technology Jobs

Find similar Data Architect jobs: