E-commerce Data Analyst / Planner

We are looking for an E-commerce Data Analyst / Planner (Advanced MS Excel/Google Sheets) for our growth marketing team. This teammate extracts and converts data sets from e-commerce platforms to create reports for sales forecasting/projections and ad hoc reporting. Furthermore, data investigation, insights, and recommendations will also be provided by this teammate promptly, ensuring the report’s accuracy.

This is a great opportunity for someone who wants to work with a well-known brand and wants continuous learning and growth during their career.

The Benefits

Work From Home
Attendance, Performance, and Referral Bonuses
Paid Holidays and Time Offs
Health Insurance Card

The Role

Pull and convert data (at scale) to create “apples to apples” comparisons (i.e., single units vs. bundles) using MS Excel or Google Sheets
Set up pricing sheets for promotions based on given directions
Export inventory and sales data from Netsuite and Shopify
Aggregate historical data as directed by the Director of Planning to aid in sales forecasting/projections
Data manipulation (i.e., sorting, scrubbing, tagging, cleaning, de-duping)
Provide daily / weekly / monthly reporting on various data sets
Validate and troubleshoot existing and new reports to ensure data’s accuracy and logic
Perform other ad-hoc data analysis tasks as needed

The Requirements

3+ years of experience in complex data analysis is a must-have
Must have advanced skills in MS Excel or Google Sheets (can do advanced formulas and functions like lookups, if/then, pivot tables, macros, etc.)
Demonstrated ability to generate ad-hoc reports and dashboards from scratch is a must-have
Preferably with experience in Finance, Strategy Supply Chain, or Business Operations stakeholders
Experience with Tableau or similar BI tools is a nice-to-have
Intermediate to advanced SQL scripting experience (Big Query or similar dialect/language) is a nice-to-have
Familiarity with Gmail and Slack for internal communication
Should have meticulous attention to detail and the ability to work fast and pull/sort/convert data at scale quickly and without error
Excellent English communication skills (both verbal and written)
Can work on the graveyard shift following any US time zones