Returning Candidate?

Analytics Intern

Analytics Intern

Job Locations 
US-PA-Paoli
Category 
Information Technology

More information about this job

Overview

Turn 5 is one of the largest and fastest growing e-commerce retailers in the Greater Philadelphia area.  Best known for our award-winning e-commerce platforms, AmericanMuscle.com, ExtremeTerrain.com and AmericanTrucks.com, we’ve been engaging car enthusiasts with exceptional products, services, and experiences since 2004.

 

Our purpose, however, extends beyond selling just car parts.  We have a commitment to curating a diverse assortment mix that not only contains items that our customers want and need, but also unique, specialty products that inspire even the most experienced owner to think bigger. 

 

We have an exciting opportunity for a Analytics Intern to join our Information Technology team! This intern will gain experience working as a part of our data and analytics team within our eCommerce business. 

 

Reporting to the BI Analyst, the Analytics Intern will assist the IT team in resolving a variety of data related requests coming from various departments.

These requests may include (but are not limited to) routine and ad hoc requests for raw data, extracting and loading data to and from different sources, and creating data visualizations and dashboards which are to be delivered primarily via Tableau.

 

Responsibilities

  • Write SQL queries to extract and/or summarize data from various sources to answer specific business questions presented by users.
  • Extract and load data to and from various sources.
  • Use Tableau Desktop to create reports and dashboards with the goal of delivering meaningful and actionable insights to end users.

We Need You to Have...

  • Experience working with large volumes of data, specifically with regards to data cleansing, formatting, aggregating and summarizing
  • Experience working with SQL and Relational Databases such as MS SQL Server, Oracle, MySQL, etc.
  • Analytical skills and attention to details.
  • Proficiency in Excel. (functions, pivot tables, VBA, etc.)
  • Excellent oral and written communication, and interpersonal skills.

We are looking for students currently enrolled in a four-year undergraduate program with at least 90 credit-hours completed (Junior/Senior preferred). Prior experience in a business setting is ideal. This is a paid internship.