Business Intelligence Engineer II, SCOT-FO, TVP

The Amazon Supply Chain Optimization Technologies (SCOT) team works on some of the worlds most complex supply chain challenges at Amazon scale. We understand inventory availability for the millions of items on Amazon compute accurate delivery expectations for customer orders and monitor fulfillment network changes to inform delivery updates and optimizations. When customers place orders our systems utilize real-time large-scale optimization techniques to optimally select shipping sources and consolidate multiple orders. This enables us to ensure customers receive their shipments within the promised timeframe in an efficient manner.

Fulfillment Optimization (FO) owns products and services that plan and execute First Party (1P) and 3P fulfillment resources for the outbound fulfillment network WW. This includes designing network topology coordinating resource planning for inventory labor planes and trucks and utilizing these resources optimally by being aware of the networks true capacity constraints and capabilities. We provide fast accurate and optimized delivery promises identify the optimal fulfillment plans and will orchestrate XXB shipments in 2025 to efficiently leverage outbound fulfillment capabilities.
The team is composed of scientists Business Intelligence Engineers (BIE) Software Engineers and Researchers who lead the industry in the development of innovative algorithms and strategies to maximize the long term effectiveness of Amazons business.

The team is seeking an exemplary Business Intelligence Engineer (BIE) with broad technical skills to build analytic and reporting capabilities that enable optimization of delivery promises for our millions of customers worldwide. The ideal candidate is a highly analytical critical thinker with advanced problem solving data mining and software development skills. They will enjoy working with world-class product managers economists research scientists data engineers and software developers to drive decisions across Amazons retail and operations teams. Successful members of this team are customer obsessed flexible and collaborative team players who enjoying working across functions and organizations to solve problems and get results. They ask hard questions and build scalable solutions that provide critical business insight necessary to influence decision making across retail and operations teams. They find timely answers buried in large data sets and complex systems identify root causes get their hands dirty building data systems and sharing insight.

To help describe some of our challenges we created a short video about Supply Chain Optimization at Amazon - job responsibilities
- Collaborate with software development teams to implement analytics systems and data structures to support large-scale data analysis and delivery of machine learning and econometric models
- Define develop and maintain critical business and operational reports reviewed on a weekly monthly quarterly and annual basis
- Analyze historical data to identify trends and support decision making including written and verbal presentation of results and recommendations
- Mine and manipulate data from database tables simulation results and log files
- Identify data needs and drive data quality improvement projects
- Understand the broad range of Amazons data resources which to use how and when
- Provide thought leadership on data mining and analysis

A day in the life
- Collaborate with the Engineering and Science teams to define new product features construct data pipelines and test new functionalities
- Learn about new Amazon technologies and create proposals to adapt to those technologies
- Conduct deep dives into anomalies and generate insights for leadership and product management
- Use customers inputs to define new data requirements
- Explain plan-over-plan differences or discrepancies between expected and actual performance
- Maintain dashboards and reporting and address any data quality issues that arise

Amazon offers a full range of benefits that support you and eligible family members including domestic partners and their children. Benefits can vary by location the number of regularly scheduled hours you work length of employment and job status such as seasonal or temporary employment.

The benefits that generally apply to regular full-time employees include:
- Medical Dental and Vision Coverage
- Maternity and Parental Leave Options
- Paid Time Off (PTO)
- 401(k) Plan

If you are not sure that every qualification on the list above describes you exactly wed still love to hear from you!

At Amazon we value people with unique backgrounds experiences and skillsets. If youre passionate about this role and want to make an impact on a global scale please apply!

About the team
As the Fulfillment Network Planning team we leverage big data to identify key patterns understand root causes and build models to fix the most impactful problems. This role is challenging yet rewarding requiring innovative thinking a desire to learn and the skills to develop advanced solutions that continuously improve the customer delivery experience.

- 3 years of analyzing and interpreting data with Redshift Oracle NoSQL etc. experience
- 1 years of SQL ETL or Oracle experience
- 1 years of processing large multi-dimensional datasets from multiple sources experience
- 1 years of performing statistical analysis experience
- 1 years of developing automated reporting experience
- Experience with data visualization using Tableau Quicksight or similar tools
- Experience with data modeling warehousing and building ETL pipelines
- Experience in Statistical Analysis packages such as R SAS and Matlab
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

- Experience with AWS solutions such as EC2 DynamoDB S3 and Redshift
- Experience in data mining ETL etc. and using databases in a business environment with large-scale complex datasets

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status disability or other legally protected status.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process including support for the interview or onboarding process please visit for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience qualifications and location. Amazon also offers comprehensive benefits including health insurance (medical dental vision prescription Basic Life & AD&D insurance and option for Supplemental life plans EAP Mental Health Support Medical Advice Line Flexible Spending Accounts Adoption and Surrogacy Reimbursement coverage) 401(k) matching paid time off and parental leave. Learn more about our benefits at TX Austin - 99500.00 - 160000.00 USD annually