Commercial Operations and Capabilities Co-Op (Year-round Intern)

No Relocation Assistance Offered
# 162802 - 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: Commercial Operations Data Analyst Co-Op (Year-round intern)
LOCATION: Hybrid in Overland Park, KS 

TRAVEL: None

DURATION: August - May

SALARY RANGE: $20.00 - $24.50/hr

 

Job Summary

 

The Commercial Operations Data Analyst Co-Op is responsible for developing dashboards and business intelligence tools for analytics and operations projects. This type of work requires attention to detail, an understanding of the most up to date data analysis tools, problem-solving skills, and an analytical mindset. This position will support the Customer Development team and current analysts with data requests, creation of dashboards using curated data sets, and use of analytical tools to answer business questions.

 

This position is a year-round Co-Op role which will require availability to work on average 20 hours per week in our hybrid work environment (about 3 days on site in Overland Park, KS each week) from August 2024- May 2025 with the possibility of a full time role post graduation. 

The Commercial Operations Data Analyst Intern will collaborate frequently with both experienced analysts and the broader Customer Development team to support analytics projects and help build our KPI and reporting structure in DOMO and SIGMA. The intern can also provide support as needed to other internal teams for specific projects requiring data preparation and/or analysis. 

 

Task

1. Use SQL to pull and aggregate data for projects, validating using SAP, DOMO and Sigma.

2. Conduct data cleaning, data merging, data architecture review, and data quality control, while creating documentation for each data request.

3. Help develop reports, analyses, and visualizations

4. Train and incorporate feedback from end-users on new reports and dashboards

5. Work with different members of the CDO and PVA teams on reporting and automated dashboards

6. Work cross functionally with different teams on data sets, inputs, and outputs

 

 

This is not an exhaustive list of duties or functions.

 

Educati