Business Intelligence Engineer, DSP Analytics

This job is with Amazon, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.DESCRIPTION: Do you enjoy diving deep into data, building data models and developing business metrics to generate actionable insights? Are you looking for an opportunity to define end to end analytics roadmap, work with cross functional teams and leverage cutting edge modern technologies and cloud solutions to develop analytics products. DSP Analytics team has an exciting opportunity for a Business Intelligence Engineer (BIE) to improve Amazon's Delivery Service Partner (DSP) program through impactful data solutions.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.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 performance and delivery quality. The business coverage is broad, and you will identify and prioritize what matters most for the business, quantify what is (or is not) working, invent and simplify the current process and develop self-serve data and reporting solutions.You should have excellent business and communication skills to be able to work with business owners to define roadmap, develop milestones, define key business questions, and build data-sets that answers those questions. The ideal candidate should have hands-on SQL and scripting language experience and excel in designing, implementing, and operating stable, scalable, low-cost solutions to flow data from production systems into the data warehouse and into end-user facing applications.Key job responsibilities - Lead the design, implementation, and delivery of BI solutions for the Worldwide DSP Performance solutions and Network Health. - 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. - 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 senior leadership team to review roadmap and contributing to business strategy and how they can leverage analytics for success.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: - 10+ years of professional or military experience - 7+ years of SQL experience - Experience programming to extract, transform and clean large (multi-TB) data sets - Experience with theory and practice of design of experiments and statistical analysis of results - Experience with AWS technologies - Experience with theory and practice of information retrieval, data science, machine learning and data mining - Experience in scripting for automation (e.g. Python) and advanced SQL skills. PREFERRED QUALIFICATIONS: - Experience working directly with business stakeholders to translate between data and business needs - Experience managing, analyzing and communicating results to senior leadershipOur 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.