Amazon Business Intelligence Engineer SMB Marketing Analytics 

United States, New York, New York 

115928028

SMB Marketing Analytics team supports SMB Marketing team in delivering highly relevant and personalized marketing content to majority of current and prospective advertisers. In this role, you will work with 10+ highly motivated team-members and will be responsible for designing, building and maintaining data infrastructure, creating automated reporting and dashboards, designing and measuring experiments, and executing complex analysis to support business functions.In this role you will:-Serve as liaison between the business and product/science teams to prototype new marketing solutions and perform ad hoc investigations into future improvements or innovations. This will require data gathering and manipulation, synthesis and modeling, problem solving, and communication of insights and recommendationsKey job responsibilities
* Own development, and maintenance of datasets, ongoing metrics, analyses and dashboards to drive key business decisions.
* Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
* Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers.
* Use analytical and statistical rigor to identify performance gaps and opportunities for optimization.
* Build data infrastructure in collaboration with partner tech-teams to facilitate scaling-up various marketing initiatives.
* Support central BI team in reporting on global marketing efforts.
A day in the life
* Use technical expertise to suggest ways to improve processes and incorporate operational excellence best practices
* Use analytical and statistical rigor to answer business questions and drive business decisions
* Recognize and adopt best practices in reporting and analysis: data integrity, design, analysis, validation, and documentation

- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with data modeling, warehousing and building ETL pipelines
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling