Logo of Huzzle

Home

Matches

Explore

Manage

Customer Service & Logistics Data Analyst Year-Round Intern

image

Hill's Pet Nutrition

3mo ago

  • Internship
    Full-time
    Placement Program
  • Logistics
    Data
  • Overland Park

AI generated summary

  • You need upper-level coursework in data analytics, SQL skills, database experience, strong communication, analytical skills, and proficiency in SAP and planning systems. Willingness to learn is essential.
  • You will analyze data using SQL, clean and merge datasets, create reports and visualizations, train users, and collaborate across teams to support analytical needs in CS&L projects.

Requirements

  • 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
  • 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.

Responsibilities

  • Use SQL to pull and aggregate data for CS&L projects, validating using SAP and other analytical tools as required.
  • Conduct data cleaning, data merging, data architecture review, and data quality control, while creating documentation for each data request.
  • Help develop reports, analyses, and visualizations
  • Train and incorporate feedback from end-users on new reports and dashboards
  • Work with different members of the CS&L team on reporting and automating analytical needs
  • Work cross functionally with different teams on data sets, inputs, and outputs

FAQs

Is this position an internship?

Yes, this is a year-round internship.

What is the location of the internship?

The internship is hybrid, based in Overland Park, Kansas.

What is the duration of the internship?

The internship typically lasts from August to May.

What is the salary range for this position?

The salary range for the internship is $22.50 to $30.00 per hour.

What kind of tasks will the intern be responsible for?

The intern will be responsible for developing and managing data sets, conducting data cleaning and merging, creating reports and visualizations, and collaborating with the CS&L team on various projects.

What educational qualifications are required for this role?

Candidates must have a minimum of 3 upper-level college classes in data analytics or related subjects.

Is experience with SQL necessary for this position?

Yes, candidates must have experience in SQL programming and the ability to read/write complex SQL queries.

Will there be opportunities to work with experienced analysts?

Yes, the intern will collaborate frequently with experienced analysts and the broader CS&L team.

Are there any benefits associated with this internship?

The position may offer competitive compensation, but specific benefits such as insurance, retirement plans, and paid leave are typically associated with salaried employees rather than interns.

Is prior experience with specific databases required for this position?

Yes, experience working with databases like Snowflake and BigQuery is preferred.

What skills are expected from the ideal candidate?

The ideal candidate should have strong analytical skills, excellent communication abilities, attention to detail, and a willingness to learn and adapt to new priorities.

Will the intern be working independently?

The intern will need to learn and work in a changing environment but will have support from team members and experienced analysts.

Is there a possibility for this internship to transition into a full-time role?

The job description does not mention a direct transition to a full-time role, but internships can sometimes lead to future employment based on performance.

image

Hill's Pet Nutrition

At Hill's Pet Nutrition, we're always thinking about what comes next for your pet so you can enjoy the now.

Manufacturing & Electronics
Industry
1001-5000
Employees
1907
Founded Year

Mission & Purpose

Hill's Pet Nutrition is dedicated to improving the health and well-being of pets through innovative nutrition. The company develops scientifically formulated pet foods, tailored to meet the specific dietary needs of dogs and cats at various life stages. Their ultimate mission is to enrich the lives of pets and their owners by providing high-quality nutrition and resources. By prioritizing pet health and supporting veterinarians, Hill's aims to foster a deeper bond between pets and their families, ultimately promoting happier, healthier lives for all pets.