BI Engineer II: Middle Mile Optimization & Planning

Amazon; Bellevue (WA); On-site; USD 120,000 - 190,000; Full time

Job summary

Amazon's Middle Mile Transportation Technology team is chartered with building complex software solutions that optimize time and cost of delivering packages. As a Business Intelligence Engineer, you will lead analytics across vendors, warehouses, and carriers.

You will develop data models, ETL pipelines, and dashboards using SQL, Python, and BI tools; collaborate with executives and engineering teams to turn data into actionable improvements.

Qualifications

• Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field.
• 3+ years analyzing and interpreting data with Redshift, Oracle, NoSQL 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 with AWS solutions such as EC2, DynamoDB, S3, and Redshift.
• 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 experience.
• Knowledge of advanced skills in Excel as well as Tableau or similar BI tools.
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets.
• Experience working with business stakeholders to translate between data and business needs.
• Experience managing, analyzing and communicating results to senior leadership.

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

SQL

Python

Data Visualization

ETL

Data Modeling

AWS

Redshift

Stakeholder mgmt

Big Data

Education

Bachelor's degree in BI/CS/Engineering

Master's degree in BI/CS/Engineering

Tools

Tableau

Quicksight

NoSQL

Oracle

S3

Job description

Amazon's Middle Mile Transportation Technology team is chartered with building complex software solutions that optimize time and cost of delivering packages. As a Business Intelligence Engineer, you will lead analytics across vendors, warehouses, and carriers.

You will develop data models, ETL pipelines, and dashboards using SQL, Python, and BI tools; collaborate with executives and engineering teams to turn data into actionable improvements.