Customer Service & Logistics Data Analyst Year-Round Intern

About the position
The CS&L (Customer Service & Logistics) Data Analyst Intern is responsible for developing and managing data sets for analytical projects. This role requires attention to detail, an understanding of data analysis tools, problem-solving skills, and an analytical mindset. The intern will support the CS&L team with data requests, creation of curated data sets, and use analytical tools to answer business questions and provide visibility to data.
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.
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 resolve 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.
Nice-to-haves
? Familiarity with data visualization tools
,
? Experience with project management tools
Benefits
? Salary Range $22.50 - $30.00 USD
,
? Medical, Dental, Vision, Basic Life Insurance, Accidental Death & Dismemberment and Disability insurance plans
,
? 401(k) plan with company matching contributions
,
? Minimum of 15 days of vacation/PTO leave annually
,
? Minimum of 13 paid/floating holidays annually
,
? Minimum of 40 hours of paid sick leave annually
,
? Up to eight weeks of paid parental leave and 12 weeks of unpaid leave.