Business Intel Engineer, SCOT AIM Planning, SCOT AIM Planning

SCOT's Automated Inventory Management (AIM) Planning team is seeking a Business Intelligence Engineer who enjoys the challenge of diving into complex problems and solving the unsolvable to help our executives make impactful decisions.

In this role, you will support inventory management innovation, AIM Inventory Planning roadmap and system improvements to automate worldwide inventory management, and identify and drive long term free cash flow opportunities.

You will work closely with Scientists, Engineers and Product Managers to build scalable, high insight- high impact products and lead retail inventory planning cycles, to enable top-notch Amazon global retail inventory efficiency strategy within our rapidly growing, dynamic business and influence Amazon's inventory management decisions on a day-to-day basis.

Key job responsibilities
In this role you will…

• Collaborate with and influence a wide set of stakeholders, providing thought leadership, product expertise, and business insight.
• Own and execute retail inventory guidance planning cycles, as inputs into global Amazon financial plans and network plans
• Work across AIM Planning, PMs, Engineers, Scientists, Finance, and SCOT teams to deliver the Inventory Planning BIE Roadmap.
• Dive deep to create insights on how well Amazon is taking care of the customer as it relates to product availability and inventory levels
• Drive changes through insights to improve a wide range of internal products that impact planning, buying and sourcing.
• Develop improvements and invent new ways to look at / trends via an internal worldwide customer portal.
• Interface with cross-functional teams to build centralized tools that will allow for rapid defect detection and repair.
• Partner with Engineers and Software Engineers to design products and systems to transform and store billions of items using AWS redshift
• Explore/analyze and work with Product Managers to understand customer behaviors, spot system defects, and benchmark our ability to serve our customers
• Design and implement technical solutions with an appropriate analytics strategy and data set design; make technical trade-offs for long-term / short-term needs; and drive best practices in operational excellence, data modelling, and analysis.

Basic Qualifications

- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience with data modeling, warehousing and building ETL pipelines
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience writing complex SQL queries
- 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

Preferred Qualifications

- 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 committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, 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 https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.