SQL Data Analyst

Profile

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\u2019ve 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\u2019s 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 to leverage analytics technology to create, update, and analyze reports for various business units and processes.
 
Under the direction of Chief Merchandising Officer, the Data Analyst will be responsible for leveraging MS SQL Server and Tableau to create, update, maintain, and analyze reports for various business units and/or processes throughout Turn5.  This position will have a focus on sales, marketing, and product analysis.  The Data Analyst is primarily responsible for scoping requirements for reports, developing metrics and dashboards, and collaborating with representatives from across Turn5\u2019s departments to contribute to analytics and data projects.
Responsibilities
Year 1 is going to be about:

Update, maintain, and analyze all product management and merchandising reports and other department reports as needed
Develop reports and dashboards using data visualization tools, such as Tableau, and data querying languages such as SQL and TSQL.
Triage, prioritize, manage, and resolve any data related requests and issues generated to the Product Management department.
Discover opportunities for improvement within reporting and product management department processes and act to provide further insight or improvements.
Consistently and reliably work with the IT department to maintain databases and keep data clean.
Become a liaison between product management requests and the IT department, making sure all requirements from an IT perspective are met

Qualifications
We can\u2019t skip over some of the specific skills and experience we know are a \u201cmust\u201d to be successful. So, we need you to have:

1 year(s) of experience working with large data sets in MS SQL Server Environments
BA/BS in IT, marketing, e-commerce, economics, mathematics, or other related degrees
Excellent analytical skills: including being able to quality-assure, clean, and analyze large data sets in order to draw conclusions and develop recommendations
Proficiency in MS SQL Server
Proficiency in Excel
Proficiency in Tableau
Proficiency in Google Analytics
Oral and written communication, interpersonal skills
Ability to quality-assure, clean, and analyze large data sets
Understanding of e-commerce marketing channels
Proficiency in Access a plus but not a requirement

 

Company info

Turn5 Incorporated