Amazon Sr Business Intelligence Engineer SMB Marketing Analytics 

United States, Washington, Seattle 

444765789

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 recommendations
Key job responsibilities
* Own the design, 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.
* Promote best practices in ETL and mentor your team.
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
* Improve the Knowledge management environment by providing guidance in technical documentation

- 8+ years of professional or military experience
- 5+ years of SQL experience
- Experience programming to extract, transform and clean large (multi-TB) data sets
- Experience in scripting for automation (e.g. Python) and advanced SQL skills.
- Experience in the data/BI space