Business Intelligence Eng-II, AMZL NA Product & Science

DescriptionHave you ever ordered a product on Amazon and when that box with the smile arrived you wondered how it got to you so fast? Have you wondered where it came from and how much it cost Amazon to deliver it to you? If so, the Amazon Logistics, Last Mile team is for you. We manage the delivery of tens of millions of products every week to Amazons customers, achieving on-time delivery in a cost-effective manner.We are hiring a Business Intelligence Engineer to identify strategic initiatives that will form the next generation of Amazon Logistics. As a Business Intelligence Engineer you will be working in one of the world's largest and most complex data warehouse environments. In this role, you will primarily work on designing and building automated reporting and dashboards using complex data. We are still in the nascent stage so it is an exciting opportunity to be involved from design-to-execution. As a BI Engineer, you will operate as a mix of hands-on builder and influencer.The teams success depends on our ability to create actionable insight from the data that we and our partners generate. The ideal BIE candidate will have excellent analytical abilities, business acumen, high judgment, strong technical skills, and good written and verbal communication skills. This person will be a self-starter, comfortable with ambiguity, able to think big and be creative (while paying careful attention to detail), and enjoys working in a fast-paced dynamic environment. To be successful in this role, you should have broad skills in data mining, be comfortable dealing with large and complex data sets, while applying analytical rigor to solve business problems.This role is cross-functional - you will work closely with partners in Product Management, Training and Program Management to design and deliver data needs. You should be comfortable working in a dynamic, start-up environment, and seek data-driven decision-making. You should have strong analytical and communication skills and be able to work with product managers and business development teams to define key business questions and build data sets and models that answer them.Key job responsibilities- Develop complex queries for ad hoc requests and projects, as well as ongoing reporting.- Design, develop and maintain scalable, automated, user-friendly systems, reports, dashboards, etc. that will support our analytical and business needs- Design, implement, and support key datasets that provide structured and timely access to actionable business information addressing stakeholder needs.- Interface directly with stakeholders, gathering requirements and owning automated end-to-end reporting solutions.- Partner with analysts, data engineers, business intelligence engineers, and software development engineers across Amazon to produce complete data solutions.- Simplify and automate reporting, audits, and other data-driven activities; build solutions to have maximum scale and self-service ability by stakeholders- Proficiency with SQL queries to retrieve and analyze data. Learn and understand a broad range of Amazons data resources and know how, when, and which to use.- Estimate models, write analyses, and extract insights and provide business recommendations.About the teamWe serve AMZLs Learning teams as the strategic thought leader, looking beyond where other teams are focused to drive transformative solutions that leverage technology and processes to improve learning outcomes and drive down the cost to serve.Basic Qualifications- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. 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 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.