Shopbop is looking for a nimble, curious BIE within the Buying and Planning organization to help design, build and implement BI solutions. This role will own development of long-term automation solutions to improve the Buying and Planning workflow, while also creating short-term tools and reporting to support the evolving needs of the business. The ideal candidate is innovative, data-driven and strives to answer fast-changing business/operational questions with thoughtful analysis. They are comfortable in distilling data from multiple sources to create simplified, concise reporting and visualizations to support leadership decision making, and can manage multiple analyses/projects simultaneously. Successful candidates will be expected to demonstrate our leadership principles: Invent and Simplify, Customer Obsession, Bias for Action, and Deliver Results.

Key job responsibilities
- Developing concise, insightful reporting on the key drivers of our business
- Enabling efficient decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format
- Generating flexible models for KPI definition and tracking to support Shopbop strategic initiatives
- Writing high quality SQL codes to retrieve and analyze data
- Communicating complex, data-driven subject matter to key stakeholders, both verbally and in writing
- Partnering with internal stakeholders to gain a deep understanding of the business need and existing challenges

BASIC QUALIFICATIONS

- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience writing complex SQL queries
- Knowledge of advanced skills in Excel as well as any data visualization tools like Tableau or similar BI tools (familiarity with Tableau preferred)
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Experience with forecasting and statistical analysis
- Experience with business analysis and comfort with tackling ambiguous problems and distilling complex data sets into digestible insights for leadership

PREFERRED QUALIFICATIONS

- Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets

Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.