Data Migration and Analytics Intern

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.

  • Apply for this role

    Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.

    Apply Now →Generate Application Kit

    Free account required — sign up in 30s

    Report an issue

    Company

    Colgate-Palmolive

    View company profile →