Business intelligence Engineer, Optimal Inventory Health

DescriptionAmazon SCOT OIH (Supply Chain Optimization Technology - Optimal Inventory Health) team owns inventory health management for Retail worldwide. We use a dynamic programming model to maximize the net present value of inventory driving actions such as pricing markdowns, deals, removals, coupons etc.Our team, the OIH Insights Team energize and empower OIH business with the clarity and conviction required to make impactful business decisions through the generation of actionable and explainable insights, we do so through the following mechanisms:- Transforming raw, complex datasets into intuitive, and actionable insights that impact OIH strategy and accelerate business decision making.- Building and maintaining modular, scalable data models that provide the generality, flexibility, intuitiveness, and responsiveness required for seamless self-service insights.- Generating deeper insights that drive competitive advantage using statistical modeling and machine learning.We are looking for experienced, self-driven, and strategic Business intelligence Engineer with superior analytical skills. This position is critical in coming up with creative strategies, helping us building scalable BI solution, learning more from data to delight our customers and Selling Partners with data driven insights, and starting the new chapter of end to end Insights generation in the data-driven decision-making culture of OIH. You will be part of the Science and Analytics team that has research scientists, data scientists, business intelligence engineers and data engineers.You can contribute to each layers of data solution you work closely with data engineers to implement data pipeline for scalable BI solution, you team up with research/data scientists, product managers to productionize self-service Insights generation, you will be diving deep in our data and have a strong bias for action to generate insights, review with business leaders and stakeholders, and drive business actions. As a business intelligence engineer in OIH, you will see how the BI solution and intuitive Insights impact our customers, improve Amazons Long Term Free Cash Flow.Key job responsibilities- Translating the business requirements to structured BI solutions.- Designing and implementing BI technical solutions with the appropriate analytics strategy and data set design.- Implementing data pipeline for Insights generation.- Translating the raw data into meaningful insights through collaboration with Product Managers, Data scientists and Data engineers.- Structuring large scale, complex analysis and performing the analysis to generate insights.- Driving business actions through Insights to accelerate the business and technical evolution.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 modelingPreferred 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 datasetsAmazon 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 $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.