Business Intelligence Engineer II, R2L Delivery BI

DescriptionRapid and Rural Logistics is a rapidly growing area of Amazon fulfillment that includes rush service and super rural delivery. As a Business Intelligence (BI) Engineer, your focus will be on providing metrics, operational insight, and other analytical support to stakeholders for the Sub-Same Day (SSD),Rural Super Rural (RSR) and Amazon Today(AT) Delivery business. The Delivery BI team partner closely with Delivery and the operations teams to influence the strategic direction of the business, drive operations excellence, and make sound investment and expansion decisions, with the primary goal of continuously improving the customer experience while driving long-term profitability for our portfolio of businesses. We experiment constantly, fail fast, and never stop learning.Candidates will have excellent analytical abilities, sound judgment, curiosity, strong technical skills, and superior written and verbal communication skills. They will have a strong bias toward data driven decision making. They must be a self-starter, comfortable with ambiguity, and able to think big and be creative to support a rapidly growing business that operates like a start-up within Amazon. They will work with key stakeholders to document and translate business requirements into technical requirements and create interactive dashboards and data visualizations that are widely used throughout the organization.They will provide technical and business expertise in integrating data from a variety of source systems and presenting it through an array of self-service applications.If you are excited about data, are results oriented, and want to join a growing analytics team, this role is for you.Key job responsibilitiesThe successful candidate is a seasoned data professional with a strong bias for action, data modeling, ETL, SQL, and scripting skills. In this role, you will help identify complex business problems, identify opportunities, and implement solutions to improve operations finance facing systems, processes, and tools. The successful candidate will provide technical expertise in extracting, integrating, and analyzing critical data, Clearly communicate any potential discrepancies and/or reporting downtime, including specific root cause and steps to resolution and design/develop key performance metrics and indicators. The successful candidate will be a self-starter, quick learner, comfortable with ambiguity, result-oriented with strong attention to detail, insist on high standards, support thoughtful decision-making, and adapt to a rapidly evolving environment. A typical day in this role provides an opportunity to build innovative data solutions with large-scale systems, identify high-priority work and projects that maximize results for key stakeholders, and solve complex problems that impact company-wide strategic decisions. Further, you will help automate processes by developing deep-dive tools, metrics, and dashboards to communicate these insights in real time to the business teams. Successful members of this team collaborate effectively with business customers and cross-functional data management teams to solve problems and implement new solutions.A day in the lifeThe successful candidate will demonstrate an ability to influence business owners, support thoughtful decision-making, and adapt to a rapidly-evolving environment. They will collaborate with executives and business units across Amazon, bring excellent verbal and written communication skills, and prioritize the most impactful projects and programs to drive businesses forward. A typical day in this role provides an opportunity of building innovative solutions with large-scale data tools, identifying high-priority work and projects that maximize results for key stakeholders, and solving complex problems that impact company-wide strategic decisions.About the teamThe Rapid and Rural Logistics team covers a portfolio of high-growth businesses with unique fulfillment and operational capabilities such as Sub Same Day (SSD), Rural Super Rural (RSR), and Amazon Today.Our team needs to move fast and scale quickly with the growing businesses we support. We expect you to be able to identify one- vs two-way doors and make decisions on your own, requesting help when necessary. Strong bias for action is important. Technical skills must be balanced against people skills and business acumen so you can work with stakeholders to understand their needs and deliver the optimal BI solution.Basic Qualifications

Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field

3+ years of analyzing and interpreting data with Redshift, Oracle, etc. experience

Experience with data visualization using Tableau, Quicksight, or similar tools

Experience with AWS technologies, data modeling, warehousing and building ETL pipelines

Experience writing complex SQL queries

Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

Preferred Qualifications

Experience working directly with business stakeholders to translate between data and business needs

Experience managing, analyzing and communicating results to senior leadership

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. 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.