Amazon Business Analyst II Editorial Strategy Solutions 

United States, Washington, Seattle 

251634723

Key job responsibilities
• Own the design, development, and maintenance of scalable solutions for ongoing metrics, reports, analysis, dashboards, etc. to support analytical and business needs.
• Work with team leadership to understand the customer needs and concerns as well as define solutions.
• Translate basic business problem statements into analysis requirements. Work with internal customers to define best output based on expressed stakeholder needs.
• Use analytical and statistical rigor to solve complex problems and drive business decisions.
• Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
• Design and drive experiments, A/B testing, outlier deep dives and form actionable recommendations. Manage the implementation of those recommendations.
• Write queries and output efficiently, and have in-depth knowledge of the data available in area of expertise. Pull the data needed with standard query syntax; periodically identify more advanced methods of query optimization. Convert data to make it analysis-ready.
• Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
• Monitor and troubleshoot operational or data issues in the data pipelines
• Review and audit existing data migration jobs and SQL queries.

- 3+ years of tax, finance or a related analytical field experience
- 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience
- 3+ years of business or financial analysis experience
- Experience defining requirements and using data and metrics to draw business insights
- Experience making business recommendations and influencing stakeholders
- Experience with Excel
- Experience with data visualization tool Quicksight to build and populate dashboards

- 5+ years of business analyst, data analyst or similar role experience