Colgate Palmolive

Data Architect

Colgate Palmolive$109K — $155K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's or Master's degree in Computer Science, Information Systems, Data Science, or related field
  • 6+ years of experience in data architecture, modeling, and management
  • Deep understanding of various modeling methodologies (relational, dimensional, NoSQL)
  • Strong knowledge of integration patterns (ETL, ELT, API integration)
  • Experience with relational databases (SQL Oracle, PostgreSQL, SAP HANA)
  • Familiarity with cloud platforms (GCP, AWS, Azure)
  • Excellent communication and problem-solving skills

Responsibilities

  • Analyze the data landscape for North America's needs and requirements
  • Define and align the data vision with broader enterprise strategy
  • Design and maintain comprehensive data models for accurate asset representation
  • Implement scalable and performant data models adhering to best practices
  • Document and design data integration patterns between systems
  • Collaborate with teams to ensure efficient data pipeline implementation
  • Establish data governance policies and monitor compliance with quality metrics

Benefits

  • Comprehensive medical, dental, and vision coverage
  • Paid parental leave and disability coverage
  • 401(k) retirement plan with company matching contributions
  • Minimum of 15 vacation/PTO days and 13 paid holidays
  • Paid sick leave entitlements based on local laws
  • Relocation assistance offered within the country
Full Job Description
Relocation Assistance Offered Within Country
Job Number #173743 - Piscataway, New Jersey, United States

Role Summary

We are seeking a highly skilled and experienced Data Architect to spearhead the definition, design, and governance of data assets for the North America division within Global IT. This pivotal role ensures that data remains consistent, high-quality, secure, and accessible to support strategic business initiatives. You will collaborate closely with business stakeholders, delivery leads, data engineers, data scientists, and platform team to build robust data models and integration strategies.

Responsibilities

1. North America Data Strategy, Vision and Delivery
  • Landscape Analysis: Develop and maintain a deep understanding of the data landscape, including sources, consumers, and requirements for North America.
  • Strategic Alignment: Define the division's data vision, principles, and standards, ensuring they align with the broader enterprise data strategy.


2. Data Modeling and Design
    Model Management: Design and maintain conceptual, logical, and physical data models that accurately reflect the domain's assets and relationships.
  • Performance & Scalability: Ensure all data models are scalable, performant, and adhere to industry best practices.


3. Data Integration and Flow
    Integration Design: Design and document data integration patterns and flows between the domain and other relevant systems.
  • Pipeline Implementation: Collaborate with data engineering teams to implement reliable and efficient data pipelines.


4. Data Governance and Quality
    Policy Enforcement: Collaborate with governance teams to establish and enforce policies, standards, and procedures.
  • Quality Assurance: Define and monitor data quality metrics, working with teams to ensure accuracy, completeness, and consistency.

Required Qualifications
    Education: Bachelor's or Master's degree in Computer Science, Information Systems, Data Science, or a related field.
  • Experience: 6+ years of experience in data architecture, data modeling, and data management.


Preferred Qualifications
    Technical Knowledge:
    • Deep understanding of modeling methodologies (relational, dimensional, NoSQL).
    • Strong grasp of integration patterns (ETL, ELT, API integration).
    • Experience with relational databases (e.g., SQL Oracle, PostgreSQL, SAP HANA).
    • Knowledge of data warehousing/data lakes (e.g., Snowflake, Databricks, GCP BigQuery, Hadoop).
    • Experience with transformation tools like DBT or Coalesce.
    • Understanding of cloud platforms (GCP, AWS, Azure).
  • Governance: Familiarity with data governance principles, data quality management tools, and practices.
  • Skills: Excellent communication, presentation, interpersonal, and problem-solving skills.
  • Industry Experience: Experience in Retail or CPG domains.
  • Tooling: Familiarity with metadata management and data catalog tools.
  • Certifications: Relevant certifications such as Certified Data Management Professional (CDMP) or cloud-specific data certifications.


Compensation and Benefits
Salary Range $109,600.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

  • Colgate Palmolive
    Specialist, Raw Materials
    $96K — $130K *
    Piscataway, NJ 08854 (Middlesex County)
    Pharmaceuticals & Biotech
    In-Person
  • Colgate Palmolive
    Data Architect
    $109K — $155K *
    Piscataway, NJ 08854 (Middlesex County)
    Information Technology
    In-Person
  • Colgate Palmolive
    VP, Global Applications - Supply Chain
    $270K — $320K *
    Piscataway, NJ 08854 (Middlesex County)
    Information Technology
    In-Person
  • Colgate Palmolive
    Digital Integration Developer
    $96K — $137K *
    Piscataway, NJ 08854 (Middlesex County)
    Information Technology
    In-Person
  • Colgate Palmolive
    Data Engineer
    $96K — $137K *
    Piscataway, NJ 08854 (Middlesex County)
    Information Technology
    In-Person

More Information Technology Jobs

Find similar Data Architect jobs: