Description Are you excited about uncovering actionable insight to improve delivery experience? Do you get excited about operating in an ambiguous and fast moving environment? Are you looking for an opportunity to define analytics roadmap, work with cross functional teams, experiment with AWS tech solutions and build decision-driven analytics solution for work that is critical to Amazon’s continued ability to deliver smiles in communities? The DSP Analytics Team has an exciting opportunity for a Senior Business Intelligence Engineer (BIE) to make an impact on the Amazon’s Delivery Service Partner (DSP) program. The goal of Amazon’s DSP organization is to exceed the expectations of our customers by ensuring that their orders, no matter how large or small, are delivered as quickly, accurately, and cost effectively as possible. To meet this goal, Amazon is continually striving to innovate and provide best in class delivery experience through the introduction of pioneering new products and services in the last mile delivery space. Come join us and help us make history! We are looking for an innovative, highly-motivated and experienced BIE who can think holistically about problems to understand how systems work together to identify and execute both tactical and strategic projects. You will work closely with engineering teams, product managers, program managers and org leaders to deliver end-to-end data solutions aimed at continuously enhancing overall DSP Experience. You will have an opportunity to lead medium to large scale projects along with owning multiple domain within the team and contributing to analytics roadmap. Key job responsibilities - Earn the trust of your customers and stakeholders by continuing to constantly obsess over their business use cases and data needs, and helping them solve their problems by leveraging technology. - Work closely with business stakeholders and leadership team to review roadmap and contributing to business strategy and how they can leverage analytics for success. - Manage and execute entire projects from start to finish including stakeholder management, data gathering and manipulation, modeling, problem solving, and communication of insights and recommendations. - Extract, transform, and load data from many data sources using SQL, Scripting and other ETL tools. - Design, build, and maintain automated reporting, dashboards, and ongoing analysis to enable data driven decisions across our team and with partner teams. - Report key insight trends using statistical rigor to simplify and inform the larger team of noteworthy trends that impact the business. - Retrieve and analyze data using a broad set of Amazon’s data technologies (ex. Redshift, AWS S3, Amazon Internal Platforms/Solutions) and resources, knowing how, when, and which to use. About the team We are the core Amazon DSP BI team with the vision to enable data, insights and science driven decision-making. We have exceptionally talented and fun loving team members. In our team, you will have the opportunity to dive deep into complex business and data problems, drive large scale technical solutions and raise the bar for operational excellence. We love to share ideas and learning with each other. We are a relatively new team and do not carry legacy operational burden. We believe in promoting and using ideas to disrupt the status quo. Per the internal transfers guidelines, please reach out to the hiring manager for an informational through the "Request Informational" button on the job page. 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.