Amazon BI Engineer - Music Merch Amazon Content Analysis & Strategy 

United States, California 

905443658

You will develop new core datasets and interactive dashboards. You will conducting ad-hoc analyses to empower the team to make data-driven decisions. You'll work closely with cross-functional partners, translating complex data into actionable insights that shape our merchandising strategies. This position is ideal for a detail-oriented, customer-obsessed individual who thrives in an ambiguous environment and is passionate about the intersection of music, merchandising/retail, and data analytics.
Key job responsibilities
* Create and optimize SQL reporting for key performance indicators and deep-dive metrics
* Build robust ETL pipelines assembling core datasets to create robust source-of-truth for reporting, analysis, and visualization
* Work with technical and business stakeholders in to scope, design, and execute pipelines, reporting, and analysis
* Develop and maintain intuitive, interactive dashboards with advanced features to enable self-service analytics (Tableau, Quicksight, Amplitude, Thoughtspot)
* Analyze and optimize business performance across various metrics, sharing key learnings with the team
* Conduct in-depth data analysis on customer insights for artist merch campaigns and broader business evaluations
* Contribute to the development and execution of data-driven experiments and tests

- 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience building and maintaining basic data artifacts (e.g., ETL, data models, queries)
- Experience with one or more industry analytics visualization tools (e.g. Excel, Tableau, QuickSight, MicroStrategy, PowerBI) and statistical methods (e.g. t-test, Chi-squared)
- Experience gathering business requirements, using industry standard business intelligence tool(s) to extract data, formulate metrics and build reports
- Demonstrated experience influencing business decisions

- Master's degree, or Advanced technical degree
- Knowledge of data modeling and data pipeline design
- Experience with statistical analysis, co-relation analysis