DescriptionAmazon’s Automated Inventory Management (AIM) team is looking for an experienced Business Intelligence Engineer to conceptualize, articulate, and develop state of the art technology to understand and measure the shopping experience of every Amazon customer. AIM is part of Amazon’s Supply Chain Optimization Technology (SCOT) organization, whose charter is to deliver the best possible customer experience while maximizing the return on our inventory investment, fulfillment assets, and transportation network in terms of long term free cash flow. We are never satisfied with the status quo and are convinced that there is always opportunity to innovate on behalf of customers.Unlike brick and mortar stores where it is challenging to capture customer interest in a product unless they actually purchase the item, e-commerce offers the unique advantage of capturing customer "glance views" even if they don't convert to sales. Glance views, or GVs, are a leading indicator of potential future demand and allow us to capture a comprehensive set of data points (eg. price, delivery speed) to understand what we showed the customer and the resultant customer behavior. Amazon uses GV data to metricize and improve key performance indicators for customer experience like availability and promised delivery speed.You will be owning Tier 1, Availability metrics that serve as a measure of customer experience and provide stakeholders across Amazon with deep insights to identify and resolve defects. Currently, we own a suite a business health metrics that answer questions like: Was Amazon in stock on an item when customers were viewing it? Was the inventory in a location from where it could be immediately picked, packed, and shipped out to the customer? If not, what was the root cause? We own publishing metrics that are used by Board of Directors, Stores and Operations leadership teams, stakeholders and business users across entire Amazon e-commerce organization in 20 marketplaces worldwide. We also own models that help us identify anomalies at scale and quantify impact of various inventory planning and supply chain execution defects. In this role, you will build new product capabilities that will pave the way to automated defect repair actions and managing business outcomes across 1000+ users and 120+ teams worldwide.You will always be challenged to think several steps ahead so that the solutions we are building today will scale well with future growth and without adding excessive operational overhead. You will need to develop deep technical and business understanding of existing system (owned by us as well as other teams across Amazon) as you will responsible for identifying synergies and minimizing investment in redundant features. You will work with supply chain operations teams, in-house scientists, other BI Engineers, and software teams to identify enhancement opportunities and new features for our data products. Successful candidates should excel at diving into data in order to analyze problems and implement simple, long term solutions. This is a highly visible role and will require regular interaction and communication with senior leaders. You must have experience and capability to document your work for technical as well as non-technical audiences. Successful candidates should excel at diving into data in order to analyze problems and implement simple, long term solutions. You will have the opportunity to thrive in a highly collaborative, creative, analytical, and fast-paced environment oriented around building the world’s most flexible and effective supply chain management technology.We are seeking talented individuals who enjoy the challenge of diving into complex problems and developing new capabilities to improve customer experience.Key job responsibilities Performing complex analysis to understand the behavior of automated inventory management systems, identify the root cause of system / process issues and provide insight on potential solutions. Building audits (analytical products) to identify trend breaks or defects at scale for millions of products and multiple Marketplaces globally. Creating new solutions to automate the business process of identifying and resolving defects (e.g. through metric dashboards and automated alarms). Extracting insights from data, identifying opportunities for improvement, working with partner teams to deliver automated and scalable solutions, and providing regular performance/progress updates to stakeholders. Developing dashboards and insight products.We are open to hiring candidates to work out of one of the following locations:Bellevue, WA, USABasic 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
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. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $79,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.
