Business Intelligence Engineer II, DEX Speed

We are looking for a motivated Business Intelligence Engineer to join the worldwide sub same day team, part of the broader Delivery Experience org. The team owns innovations around delighting customers around the world with a growing assortment of fast, innovative, and convenient delivery programs like One-Day and Same-Day delivery designed to help customers get their stuff when and where they need it. On the Delivery Experience team, we are constantly innovating to help our customers get even faster delivery, on an ever-broader assortment of products, with ambitious goals to expand these global delivery services to more and more cities each year while continually improving speed of delivery.

Role Overview

In this role you will work closely with product managers, marketers, and engineering leaders to derive quantitative insights about how customers navigate our products, identify opportunities for improvement, and shape strategic recommendations. You will be responsible for developing and maintaining insights, developing dynamic dashboards for our business partners, defining new metrics to inform the business, as well as conducting ad-hoc and strategic analyses. You have the capability to extract, manipulate, and summarize large sets in analysis through the use of business intelligence and reporting tools. You will partner closely with Product Managers to solve business problems and should be skilled at translating complex or ambiguous problem statements into analytic requirements. Additionally, you will act in an analytic consultative capacity and can articulate the \”so-what\” of your analytic results to senior leadership.

Responsibilities

• Own the development, and maintenance of ongoing metrics, reports, analyses, dashboards on the key drivers of our business.
• Partner with operations and business teams to consult, develop and implement KPI\’s, automated reporting solutions and infrastructure improvements to meet business needs.
• Develop and maintain scaled, automated, user-friendly systems, reports, dashboards, etc. that will support business needs.
• Perform both ad-hoc and strategic analyses.
• Strong verbal/written communication and presentation skills, including an ability to effectively communicate with both business and technical teams.

Qualifications

• Experience in analyzing and interpreting data with Redshift, Oracle, NoSQL etc.
• Experience writing complex SQL queries.
• Experience in Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau.
• Experience defining requirements and using data and metrics to draw business insights.
• Experience making business recommendations and influencing stakeholders.
• 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.

Equal Opportunity

Amazon is an equal opportunities employer. We believe passionately that employing a diverse workforce is central to our success. We make recruiting decisions based on your experience and skills. We value your passion to discover, invent, simplify and build. Protecting your privacy and the security of your data is a longstanding top priority for Amazon. Please consult our Privacy Notice (https://www.amazon.jobs/en/privacy_page) to know more about how we collect, use and transfer the personal data of our candidates.