Dear Ms. Hartley,
I am applying for the Junior Data Analyst position on your merchandising analytics team. For four years I was an assistant store manager at a home goods retailer, and over the last year I completed a data analytics certificate and built three portfolio projects using SQL, Excel and Tableau, linked below.
In the store I was the person who pulled the weekly sales and labor reports and explained them to my manager. I noticed our labor schedule did not match our busiest hours, so I exported six months of hourly transaction counts, built a simple Excel model of traffic by hour and day, and we moved two shifts. Lines at the register shortened and our customer survey comments about waiting fell off.
My strongest portfolio project analyzes a public retail sales dataset. I wrote SQL queries to join orders, products and returns, found that one product category had a return rate far above the others, and built a Tableau dashboard that lets a user filter returns by region and reason. I documented every cleaning step so someone else could repeat the analysis.
I understand retail operations from the floor, and I would like to help your merchandising team answer questions with data. Thank you for considering my application. I would be glad to walk you through any of my projects.
Sincerely, Jordan Mitchell