Customer Service and Logistics Analyst Co-Op

November 21, 2023

Job Description

No Relocation Assistance Offered

# 155121 – Kansas City, Kansas, [[filter1]

Job Summary

The CS&L (Customer Service & Logistics) Data Analyst Intern is responsible for developing and managing data

sets for analytical 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 CS&L team

and current analysts with data requests, creation of curated data sets from existing raw data, and use of analytical

tools to answer business questions and provide visibility to data.

The CS&L Data Analyst Intern will collaborate frequently with both experienced analysts and the broader CS&L

team to support analytics projects and help build our data architecture. The intern can also provide support as

needed to other internal teams for specific projects requiring data preparation and/or analysis. The CS&L Data

Analyst Intern must leverage both customer data and internal data to meet synchronization initiatives.

% of time Task 30%

1. Use SQL to pull and aggregate data for CS&L projects, validating using SAP and other

analytical tools as required.


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 15% 4. Train and incorporate feedback from end-users on new reports and dashboards 10% 5. Work with different members of the CS&L team on reporting and automating analytical needs 10% 6. Work cross functionally with different teams on data sets, inputs, and outputs 100% Total Percent (not to exceed 100%)

This is not an exhaustive list of duties or functions.

Education/ Experience


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


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

Familiar with how to access, input and analyze data in SAP

Proficiency with planning systems and Google and Microsoft Office products, to include Excel, Google Sheets,

Google presentations, etc.

Leadership Competencies

Planning/Priority Setting

Teamwork and Collaboration

Effective Communication

Functional Competencies

Partnerships and Collaboration

Leveraging Systems and Information

Working Relationships

Does this position supervise:

Hill’s Customers (DTC customers, HtH, warehouse personnel)

Hill’s CS&L Managers (warehousing, global, transportation, demand planning, operations, and field)

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

Are you interested in working for Hill’s Pet Nutrition? You can apply online and attach all relevant documents such as a cover letter and resume or CV. Applications received by e-mail are not considered in the selection process. Become part of our team. We look forward to your application.

Work that matters, fueled by passion for pets! At Hill’s we have a purpose. Every day around the world, we transform the lives of millions of pet families through pioneering innovation, amazing nutrition, and the best and brightest people. Founded more than 75 years ago with an unwavering commitment to pet nutrition, Hills’ mission is to help enrich and lengthen the special relationships between people and their pets.

HILL’S Prescription Diet therapeutic pet foods, HILL’S Science Diet and HILL’S Ideal Balance wellness pet foods are sold worldwide. Hill’s is a division of Colgate-Palmolive, a leading global consumer products company, tightly focused on Oral Care, Personal Care, Home Care and Pet Nutrition, with sales of products in more than 200 countries.

To learn more about Hill’s and Colgate, please visit


Related Jobs