Site upgrade in progress. You will not be able to apply at this time. Please be patient and check back with us later.

A part of Colgate-Palmolive since 1976, Hill's Pet Nutrition offers the highest-quality pet nutrition available through product lines Prescription Diet® and Science Diet®. Veterinarians worldwide recommend and feed their own pets Hill's products more than any other brand of pet food.

Available in approximately 80 countries around the world, our extensive line of products includes more than 60 Prescription Diet brand pet foods and more than 50 Science Diet brand pet foods.

We believe all animals should be loved and cared for during their lifetimes. That is why we are proud our pet foods can make a difference in your pet's life.

A career at Hill’s Pet Nutrition or Colgate-Palmolive is an excellent opportunity if you seek a global experience, constant challenge, and development opportunities in an environment that respects work/life effectiveness.

Job Title:  Customer Service and Logistics Analyst Co-Op

Travel Required?:  Travel - up to 10% of time
Date:  Nov 18, 2023
Hybrid

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.

20%

2. Conduct data cleaning, data merging, data architecture review, and data quality control, while

creating documentation for each data request.

15%

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 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
▪ 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: No
▪ 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 http://www.hillspet.com and http://www.colgatepalmolive.com, or find us on LinkedIn, Facebook, Twitter and YouTube.

 

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.


Nearest Major Market: Kansas City

Job Segment: Data Analyst, Demand Planner, Supply Chain, Systems Analyst, Data Architect, Data, Technology, Operations