Business Intelligence Engineer II, Middle Mile Planning & Optimization

Amazon; Minneapolis (MN); On-site; USD 100,000 - 160,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Paid time off

Parental leave

Job summary

Amazon’s Middle Mile Transportation Technology team seeks a Business Intelligence Engineer to drive the future of the network with intelligent routing and data-driven decision making.

You will generate insightful analyses, build predictive models, and translate data into actionable insights for executive stakeholders while collaborating with engineering, science and operations teams in a fast-paced environment. The role requires hands-on work in BI, data warehousing and ML-enabled analytics.

Qualifications

• Bachelor’s degree in BI, finance, engineering, statistics, computer science, mathematics, or equivalent.
• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL, etc.
• 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 and Python for modeling.
• Experience with statistical analysis packages such as R, SAS and Matlab.
• Experience using AWS solutions such as EC2, DynamoDB, S3, and Redshift.
• Experience developing, deploying and managing AI products at scale.

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

Skills

Data analysis

SQL

Python

R

SAS

Matlab

Redshift

Tableau

Quicksight

NoSQL

Oracle

DynamoDB

S3

ETL pipelines

Education

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

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

Tools

Tableau

Quicksight

SQL

Python

R

SAS

Matlab

ETL

Redshift

NoSQL

Oracle

DynamoDB

S3

Job description

DescriptionDo you want to lead the journey of building the next-gen global transportation network using intelligent routing algorithms & systems that power the delivery of packages? Are you up for this challenge? We are looking for a Business Intelligence Engineer that will lead the innovation and exploration that would drive the future of Middle Mile Transportation at Amazon.

Amazon's Middle Mile Transportation Technology team is chartered with building complex software solutions that work across our vendors, warehouses and carriers to optimize both time & cost of getting the packages delivered. Our services already handle thousands of requests per second, make business decisions impacting billions of dollars a year, integrate with a network of small and large carriers, owner operators and drivers worldwide, manage business rules for millions of unique products, and improve ordering and delivery experience for millions of online shoppers.

Our mission is to build the most efficient and optimal transportation solution on the planet, using our technology and engineering muscle as our biggest advantage. We aim to leverage latest technologies in big data, machine learning, and optimization techniques, and operate high volume, low latency, and high availability services.

As part of this team you will work with executive leaders, engineering, science and operations stakeholders to drive process improvement, generate ideas, validate entitlement and then produce a path to production. You’ll work in a fast-paced environment and will be required to lead not only at the strategic level, but also tactically day-to-day by diving deeply into business and technical domains. As a multi-discipline leader, the buck will stop with you - you will work as part of the engineering organization.

Key job 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

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, NoSQL etc. experience
• 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, finance or equivalent quantitative field
• 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Knowledge of advanced skills in Excel as well as any data visualization tools like Tableau or similar BI tools (familiarity with Tableau preferred)
• Experience in data mining, ETL, etc. 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

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

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

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits.

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

Company - Amazon.com Services LLC

Job ID: A10491068