Amazon Business Analyst 

United States, California, San Diego 

437544397

Responsibilities:
- Understand the various operations across Payment Risk
- Design and develop highly available dashboards and metrics using SQL and Excel/Tableau- Understand the requirements of stakeholders and map them with the data sources/data warehouse- Draw inferences and conclusions, and create dashboards and visualizations of processed data, identify trends, anomalies- Execute analytical projects and understanding of analytical methods (like ANOVA, Distribution theory, regression, forecasting, Machine Learning Techniques, etc.)Key job responsibilities
• Understand the various operations across Payment Risk• Design and develop highly available dashboards and metrics using SQL and Excel/Tableau/QuickSight• Understand the requirements of stakeholders and map them with the data sources/data warehouse• Own the delivery and backup of periodic metrics, dashboards to the leadership team• Draw inferences and conclusions, and create dashboards and visualizations of processed data, identify trends, anomalies• Execute high priority (i.e. cross functional, high impact) projects to improve operations performance with the help of Analytics managers• Perform business analysis and data queries using appropriate tools• Execute analytical projects and understanding of analytical methods (like ANOVA, Distribution theory, regression, forecasting, Machine Learning Techniques, etc.)

- Bachelor's degree in business, engineering, statistics, computer science, mathematics or related field
- 1+ years of tax, finance or a related analytical field experience
- Experience creating complex SQL queries joining multiple datasets, ETL DW concepts
- Experience defining requirements and using data and metrics to draw business insights
- Experience demonstrating problem solving and root cause analysis
- Experience with reporting and Data Visualization tools such as Quick Sight / Tableau / Power BI or other BI packages
- Experience in a BI role with a technology company or financial institution
- Knowledge of Microsoft Excel at an advanced level, including: pivot tables, macros, index/match, vlookup, VBA, data links, etc.
- Experience using databases with a large-scale data set
- 1+ year of experience working in Analytics / Business Intelligence environment with prior experience of design and execution of analytical projects

- Experience in Amazon Redshift and other AWS technologies
- Experience scripting for automation (e.g., Python, Perl, Ruby)
- Experience using Python or R for data analysis or statistical tools such as SAS
- Experience in e-commerce / on-line companies in fraud / risk control functions
- Analytical mindset and ability to see the big picture and influence others
- Detail-oriented and must have an aptitude for solving unstructured problems. The role will require the ability to extract data from various sources and to design/construct/execute complex analyses to finally come up with data/reports that help solve the business problem
- Good oral, written and presentation skills combined with the ability to be part of group discussions and explaining complex solutions
- Ability to apply analytical, computer, statistical and quantitative problem solving skills is required
- Ability to work effectively in a multi-task, high volume environment
- Ability to be adaptable and flexible in responding to deadlines and workflow fluctuations