• Job Description

  Req#: 161611

  No Relocation Assistance Offered
  # 161611 - Overland Park, Kansas, United States
  
  Who We Are
  Colgate-Palmolive Company is a caring, innovative growth company that is reimagining a healthier future for all people, their pets and our planet. Focused on Oral Care, Personal Care, Home Care and Pet Nutrition, we sell our products in more than 200 countries and territories under brands such as Colgate, Palmolive, elmex, hello, meridol, Sorriso, Tom’s of Maine, EltaMD, Filorga, Irish Spring, PCA SKIN, Protex, Sanex, Softsoap, Speed Stick, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill’s Pet Nutrition.
  
  We are recognized for our leadership and innovation in promoting sustainability and community wellbeing, including our achievements in decreasing plastic waste and promoting recyclability, saving water, conserving natural resources and improving children’s oral health.
  
  If you want to work for a company that lives by their values, then give your career a reason to smile and join our global team!
  

  Job Title: Data Migration and Analytics Intern

  Job Description:

  Position Overview:

  As a Data Migration and Analytics Intern, you will play a crucial role in our S/4HANA implementation project. You will work closely with our supply chain, data engineering, and analytics teams to ensure seamless data migration, develop back-end data processes, create front-end dashboards, and implement automation solutions. This internship offers a unique opportunity to gain practical experience in both data migration and analytics within a dynamic and collaborative environment.

  Key Responsibilities:

  • S/4HANA Implementation:

    • Assist in the planning and execution of data migration activities for the S/4HANA implementation.

    • Collaborate with cross-functional teams to ensure accurate and efficient data transfer from legacy systems to S/4HANA.

    • Support data validation, cleansing, and transformation processes to ensure data integrity and consistency.

  • Back-End Data Processes:

    • Develop ETL (Extract, Transform, Load) processes to facilitate data objects.

    • Work with data engineers to design and implement data pipelines for supply chain analytics.

    • Ensure data quality and reliability through rigorous testing and validation.

  • Front-End Solutions:

    • Create and maintain interactive dashboards and reports using CP tools (e.g., DOMO, Looker Studio).

    • Collaborate with stakeholders to understand their reporting needs and deliver actionable insights.

    • Provide training and support to end-users on how to effectively use the dashboards and reports.

  • Automation:

    • Identify opportunities for automation within data migration and analytics processes.

    • Develop and implement automation scripts and tools to streamline workflows and improve efficiency.

    • Monitor and maintain automated processes to ensure they operate smoothly.

  
  
  

  Qualifications:

  
  
  

  • Currently pursuing a degree in Computer Science, Data Science, Information Systems, Supply Chain Management, or a related field.

  • Basic understanding of data migration concepts and ETL processes.

  • Familiarity with SAP S/4HANA or other ERP systems is a plus.

  • Experience with BI tools such as SAP Analytics Cloud, Tableau, or Power BI.

  • Proficiency in programming languages such as Python, SQL, or similar.

  • Strong analytical and problem-solving skills.

  • Excellent communication and teamwork abilities.

  • Ability to work independently and manage multiple tasks simultaneously.

  
  Compensation and Benefits
  Salary Range $21,50 - $32,50 USD
  
  Pay is based on multiple non-discriminatory, individualized factors including but not limited to experience, job-related knowledge and education, skills and office/market location. In addition to base salary, salaried employees are eligible for annual discretionary bonuses, profit-sharing and, for Executive-level (salary grade 16 and above) roles only, long-term incentives in the form of Restricted Stock Units and/or Stock Options.
  
  Subject to the terms and conditions of the applicable benefits plans then in effect, all salaried employees are also eligible for a competitive benefits package which includes:

  • Insurance: Employees (and their eligible dependents) are eligible to participate in Company-sponsored Medical, Dental, Vision, Basic Life Insurance, Accidental Death & Dismemberment and Disability insurance plans.
  • Retirement Plans: Employees are eligible to enroll in Colgate's 401(k) plan, which provides for company matching contributions subject to eligibility requirements
  • Vacation/PTO: Employees receive a minimum of 15 days of vacation/PTO leave annually
  • Paid Holidays: Employees receive a minimum of 13 paid/floating holidays annually
  • Paid Sick Leave: Based on location and consistent with applicable state and local law, employees receive a minimum of 40 hours of paid sick leave on January 1st of each year
  • Paid Parental Leave: Eligible employees may take up to eight weeks of paid parental leave and 12 weeks of unpaid leave (varies for employees with fewer than 12 months of service and is subject to hours worked requirements)

  
  Our Commitment to Sustainability
  With the Colgate brand in more homes than any other, we are presented with great opportunities and new challenges as we work to integrate sustainability into all aspects of our business and create positive social impact. We are determined to position ourselves for further growth as we act on our 2025 Sustainability & Social Impact Strategy.
  
  Our Commitment to Diversity, Equity & Inclusion
  Achieving our purpose starts with our people — ensuring our workforce represents the people and communities we serve —and creating an environment where our people feel they belong; where we can be our authentic selves, feel treated with respect and have the support of leadership to impact the business in a meaningful way.
  
  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 contact Application_Accommodation@colpal.com with the subject "Accommodation Request" should you require accommodation.
  
  For additional Colgate terms and conditions, please click here.
  
  #LI-Hybrid

• About the company

  Colgate-Palmolive Company is an American multinational consumer products company headquartered on Park Avenue in Midtown Manhattan, New York City. It specializes in the production, distribution and provision of household, health care, personal care and veterinary products.

Notice