Job Title: Customer Service and Logistics Analyst Co-Op
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