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