Amazon - Business Analyst

Key job responsibilities:

- 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.

- 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 ETL jobs and SQL queries.

- Good communication and writing. Effectively communicates with both business and technical teams.

Basic qualifications:

- 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

- Bachelor's degree or equivalent

- Experience defining requirements and using data and metrics to draw business insights

- Experience with Excel

- Experience with SQL

- Experience making business recommendations and influencing stakeholders