Business Analyst, IN S&OP

Do you enjoy solving complex business problems, transforming data into information, and using that information to influence business decisions? Are you able to form a picture and tell a story based on what the numbers are saying? Do you have experience joining data sets from disparate sources in order to do so? If so, this opportunity may be for you.

Are you interested in being part of a high visibility, strategic team that directly impacts Amazon worldwide? The IN S&OP team is looking for motivated self-starters that can work in a fast paced, data-driven environment. The successful candidate will be an analytical problem solver, have an extremely high level of customer focus and a passion for process improvement.

As you launch your career as a Business Analyst at Amazon, you will focus on improving the success within Operations fulfillment by analyzing data, discovering and solving real world problem, and building metrics and business cases to improve the customers experience.
The responsibilities include, but not limited to:
Identify and build data sources
Extract, manipulate, assess, maintain data quality and convert data to facilitate and conduct analysis

Key job responsibilities

Enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format
Partnering with other analysts and BI engineers in planning and analytics to build analytical solutions to deliver on business goals
Propose and implement business metrics for senior management reviews and work with business intelligence and data engineers to design and develop data infrastructure to support business growth
Perform deep-dives to find the root causes behind variances of key parameters over a given time-period
Harness data to create business requirements documents and guide actionable technology requests
Collaborating with cross-functional teams, including finance, supply chain execution, transportation, and others, to identify pain points and opportunities for optimization.
Conducting in-depth analysis and cost-benefit assessments to evaluate the feasibility and impact of potential initiatives.
Program manage projects with category teams and drive decision making across cross functional teams and senior leadership acting as a common link between operations and categories.


About the team
The First mile S&OP is responsible for forecasting the volumes on weekly basis for OB, IB, Customer returns, Trans in and Trans out flows (upto 8 weeks). S&OP also owns the demand planning for ES/EF Channel.
Our Forecasting and planning teams work with cross functional collaboration to ensure all possible future external as well as internal factors are taken into consideration while forecasting so that we have the highest accuracy reducing site level churn and increasing efficiency. All flow owners monitors the flow of packages with respect to forecast on daily basis using S&OP deck and take appropriate actions on ground if we see high deviation in volume in comparison to plan which in turn ensure there are no choke points and prevents high backlog on floors which leads to good Customer experience.
- 1+ years of Excel or Tableau (data manipulation, macros, charts and pivot tables) experience
- Bachelors degree or equivalent
- Experience defining requirements and using data and metrics to draw business insights
- Experience creating complex SQL queries joining multiple datasets, ETL DW concepts
- Experience in Excel (macros, index, conditional list, arrays, pivots, lookups)
- Experience scripting for automation (e. g. , Python, Perl, Ruby)
- Experience using Python or R for data analysis or statistical tools such as SAS
- Experience using statistical tools such as Minitab
- Experience with reporting and Data Visualization tools such as Quick Sight / Tableau / Power BI or other BI packages
- Experience in project management