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. This role involves building complex software solutions that optimize the time and cost of package delivery across vendors, warehouses, and carriers. You will work with executive leaders, engineering, science, and operations stakeholders to drive process improvement, generate ideas, validate entitlement, and produce a path to production in a fast-paced environment.

Our mission is to build the most efficient and optimal transportation solution on the planet, leveraging big data, machine learning, and optimization techniques while operating high-volume, low-latency, and high-availability services.

Responsibilities

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

Qualifications

• Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, or 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 a database or data warehouse and scripting experience (Python) to process data for modeling.
• Experience in 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 BI, finance, engineering, statistics, computer science, mathematics, or 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 (familiarity with Tableau preferred).
• 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:

• USA, MN, Minneapolis: $99,500.00 - $160,000.00 USD annually
• USA, TN, Nashville: $94,600.00 - $160,000.00 USD annually
• USA, WA, Bellevue: $99,500.00 - $160,000.00 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 insurance, and optional 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.