No Relocation Assistance Offered
# 155121 – Kansas City, Kansas, [[filter1]
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.
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
● 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
● 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.
Teamwork and Collaboration
Partnerships and Collaboration
Leveraging Systems and Information
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