Commercial Operations Data Intern

No Relocation Assistance Offered
Job Number #168830 - Overland Park, Kansas, United States

Who We Are

Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specializing in Oral Care, Personal Care, Home Care, Skin Care, and Pet Nutrition. Our products are trusted in more households than any other brand in the world, making us a household name!

Join Colgate-Palmolive, a caring, innovative growth company reimagining a healthier future for people, their pets, and our planet. Guided by our core values—Caring, Inclusive, and Courageous—we foster a culture that inspires our people to achieve common goals. Together, let's build a brighter, healthier future for all.
 

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 2025- May 2026 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.

 

Education/ Experience Requirements:

Basic qualifications include:
● Minimum 3 upper level college classes in data analytics including - data analysis and forecasting, data mining and predictive analytics, system analysis and design and data visualization in business or similarly related classes
● Experience working in databases like snowflake, Big query, etc.
● Experience in SQL programming: ability to read/write complex SQL queries to analyze data, investigate systemic defects and validate data quality
● Working knowledge of data modeling, data warehousing, and ability to access relational and
multidimensional databases

● 3.0 GPA minimum

 

Expected Areas of Skills
▪ Strong desire to serve the customer, identify and revolve needs and follow up when necessary. ▪ Ability to leverage knowledge of numerous data sources (including SAP, external data, and existing internal reports)
▪ Excellent written and verbal communication skills and interpersonal skills.
▪ Ability to learn and work in a changing environment with minimal supervision.
▪ Demonstrated analytical, organizational skills, critical thinking, and attention to detail
▪ A strong willingness to learn and adapt to new priorities as they come<