Data Analyst

Job Locations US-PA-Paoli
Category
Information Technology

Overview

Turn 5 is one of the largest and fastest growing e-commerce retailers in the Greater Philadelphia area experiencing 15+ years of double-digit growth driven by our customer and data-first approach. 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 car parts. We have a commitment to creating meaningful customer experiences at every step of their journey. Whether it’s supplying a unique product that customizes the look and feel of their ride, providing thousands of educational videos for the DIYer or leveraging user generated content to inspire even the most experienced owner, we are obsessed with ensuring we reach as many like-minded gearheads across the globe.

 

To continue our growth path, we need a Data Analyst who thrives working with large data sets to create & analyze reports & prove out multiple scenarios that support business decisions across all areas of the business. This is a highly impactful role as you’ll work across every step of the analytics process from problem identification, data gathering, and data cleansing, to developing thoughtful analysis and making presentation of findings.

 

The Turn5 business is built on using data – not opinions – to guide the path forward. Turn5 boasts industry leading business and marketing strategies. Those strategies come from smart people armed with the right data and analysts to challenge their thinking, provide insights & pounce on opportunities.

 

You will be challenged to work collaboratively across all departments to spread the use of data and knowledge to make better decisions throughout the company. At times, you will be using custom SQL code to build reports that help analyze a new data set. Other times, you will collaborate with our department leads to analyze KPI reports. Regardless of the task, it’s critical you have strong situational awareness and EQ as you’ll work with diverse stakeholders across the organization.

 

If you're passionate about data & analysis and want to work with people who believe in the power of analysis, join us!

Responsibilities

  • The role will be key in uncovering positive and negative anomalies in business/marketing performance. Acting as the first line of defense that highlights causes and drives next steps.
  • Assisting and leading next steps on complex analysis regarding Customer Lifecycles which will include Lifetime Value.
  • In depth analysis on New customer and retention of repeat customers. 
  • Support Marketing Director in Quarterly Marketing Business review by analyzing previous quarters results and adding insight or new visualizations into what drove growth or decline.
  • Discovering opportunities for improvement and provide recommendations for improvement within Turn5's Web strategy to drive incremental success
  • Working with team of Data Engineers to ensure performance reliability of dashboards and visualizations available via Tableau Server
  • Using custom SQL to improve data structure, optimize/automate data flow, and build custom reports
  • Collaborating with representatives from across Turn5's departments to contribute to analytics and data integration projects
  • Performing ad-hoc reporting analysis for Marketing/Web functions to help highlight performance/opportunities to assist in future decisions
  • Being presented with business/marketing problems and doing any required aspects (data identification, data cleansing, data movement, analysis, etc.) to figure out the cause and how to improve performance  
  • Create and optimize data sources combining web & customer data for unique insight.
  • Developing and confidently presenting data directly to C-level executives.

Qualifications

We can’t skip over some of the specific skills and experience we know are a “must” to be successful. So, we need you to have:

 

  • BA/BS in IT, marketing, e-commerce, economics, mathematics, or other related degrees & at minimum 1-2 years of experience working in a similar capacity
    • BA/BS degree requirement can be substituted for 3+ years of related work experience
  • Excellent analytical skills: including being able to quality-assure, clean, and analyze large data sets to draw conclusions and propose recommendations
  • Google Analytics experience is not required but a huge plus
  • 6 months - 2 years of experience with MS SQL Server 2012+
    • Comfortable with implementing basic statements for DDL (SELECT, INSERT, DELETE & MERGE). 
  • 6 months - 2 years of experience working in/moving data from Tableau, Google Analytics, or any other analytics platforms
  • Data centric experience working with various applications (OMS, WMS, etc.) implemented within an eCommerce setting would be a plus
  • Proficiency in Excel

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed