Business Intelligence Engineer II, Middle Mile Planning & Optimization

About the role

We are looking for a Business Intelligence Engineer to lead innovation and exploration that will drive the future of Middle Mile Transportation at Amazon. The Middle Mile Transportation Technology team builds complex software solutions that optimize the time and cost of package delivery across vendors, warehouses, and carriers. Our services handle thousands of requests per second, impact billions of dollars in business decisions annually, and integrate with a global network of carriers and drivers. Our mission is to build the most efficient transportation solution on the planet using big data, machine learning, and optimization techniques.

You will collaborate with executive leaders, engineering, science, and operations stakeholders to drive process improvement, generate ideas, validate entitlement, and produce a path to production. This role requires strategic leadership as well as tactical, day-to-day involvement in both business and technical domains.

Responsibilities

• Generate insightful analysis, reporting, and data visualizations to answer critical business questions, proactively identify trends, and communicate business performance.
• Translate data into actionable insights for stakeholders while identifying new areas of opportunity to drive improvements.
• Apply expertise in data mining and modeling using multiple data sources to uncover insights, identify key performance drivers, and build predictive models.
• Work backwards from the end-customer to define, design, and execute work items with an emphasis on improved metrics, productivity, and efficiency.
• Recognize and adopt best practices in reporting and analysis, including data integrity, test design, validation, and documentation.

Requirements

• Bachelor's degree in Business Intelligence, finance, engineering, statistics, computer science, mathematics, or an equivalent quantitative field.
• 3+ years of experience analyzing and interpreting data with Redshift, Oracle, NoSQL, or similar technologies.
• Experience with data visualization using Tableau, Quicksight, or similar tools.
• Experience with data modeling, warehousing, and building ETL pipelines.
• Experience using SQL to pull data from databases or data warehouses and scripting experience (Python) to process data for modeling.
• Experience with statistical analysis packages such as R, SAS, and Matlab.
• Experience using Python scripting to process data for modeling.
• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift.
• Experience developing, deploying, and managing AI products at scale.

Preferred Qualifications

• Master's degree in Business Intelligence, finance, engineering, statistics, computer science, mathematics, or an equivalent quantitative field.
• 5+ years of experience analyzing and interpreting data with Redshift, Oracle, NoSQL, or similar technologies.
• Advanced skills in Excel and data visualization tools like Tableau or similar BI tools.
• Experience in data mining, ETL, and using databases in a business environment with large-scale, complex datasets.
• Experience working directly with business stakeholders to translate between data and business needs.
• Experience managing, analyzing, and communicating results to senior leadership.

Pay

Base salary ranges:

• Minneapolis, MN: $99,500 - $160,000 USD annually
• Nashville, TN: $94,600 - $160,000 USD annually
• Bellevue, WA: $99,500 - $160,000 USD annually

Your Amazon package will include sign-on payments, restricted stock units (RSUs), and comprehensive benefits such as health insurance, 401(k) matching, paid time off, and parental leave.

Benefits

• Health insurance (medical, dental, vision, prescription, Basic Life & AD&D, with options for supplemental life plans).
• Employee Assistance Program (EAP) and mental health support.
• Medical Advice Line and Flexible Spending Accounts.
• Adoption and surrogacy reimbursement coverage.
• 401(k) matching.
• Paid time off and parental leave.