Business Analyst II

Have you ever thought about what it takes to detect and prevent fraudulent activity among hundreds of millions of e-commerce transactions across the globe? What would you do to increase trust in an online marketplace where millions of buyers and sellers transact? How would you build systems that evolve over time to proactively identify and neutralize new and emerging fraud threats?
Our mission in Buyer Risk Prevention is to make Amazon the safest place to transact online. Buyer Risk Prevention safeguards every financial transaction across all Amazon sites, while striving to ensure that these efforts are transparent to our legitimate customers. As such, Buyer Risk Prevention designs and builds the software systems, risk models and operational processes that minimize risk and maximize trust in Amazon. com.
As a Business Analyst in Buyer Risk Prevention, you will be responsible for analyzing terabytes of data to identify specific instances of risk, broader risk trends and points of customer friction, developing scalable solutions for prevention. You will need to collaborate effectively with business and product leaders within BRP and cross-functional teams to solve problems, create operational efficiencies, and deliver successfully against high organizational standards. You should be able to apply a breadth of tools, data sources, and analytical techniques to answer a wide range of high-impact business questions and proactively present new insights in concise and effective manner. In addition you will be responsible for building a robust set of operational and business metrics and will utilize metrics to determine improvement opportunities.
You should be an effective communicator capable of independently driving issues to resolution and communicating insights to non-technical audiences. This is a high impact role with goals that directly impacts the bottom line of the business.


Responsibilities:
- Understand the various operations across Payment Risk
- Design and develop highly available dashboards and metrics using SQL and Excel/Tableau
- Perform business analysis and data queries using scripting languages like R, Python etc
- 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 create robust, scalable analytics solutions and frameworks with the help of Analytics/BIE managers
- Perform business analysis and data queries using appropriate tools
- Work closely with internal stakeholders such as business teams, engineering teams, and partner teams and align them with respect to your focus area
- Execute analytical projects and understanding of analytical methods (like ANOVA, Distribution theory, regression, forecasting, Machine Learning Techniques, etc. )
- Draw inferences and insights from the data using EDA and data manipulations using advanced SQL for business reviews




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

Work closely with internal stakeholders such as business teams, engineering teams, and partner teams and align them with respect to your focus area

Execute analytical projects and understanding of analytical methods (like ANOVA, Distribution theory, regression, forecasting, Machine Learning Techniques, etc. ) - Bachelors degree in finance, accounting, business, economics, engineering , analytics, mathematics, statistics or a related technical or quantitative field
- 3+ years of business analyst, data analyst or similar role experience
- 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc. ) and data visualization tools such as Tableau experience
- 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
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience creating complex SQL queries joining multiple datasets, ETL DW concepts
- Experience demonstrating problem solving and root cause analysis
- Experience using databases with a large-scale data set
- 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