Business Intelligence Engineer II, Sourcing Performance Operations

Have you ever ordered a product on Amazon and when that box with the smile arrived, wondered how it got to you so fast? Wondered where it came from and how much it cost Amazon? If so, the Amazon Global Supply Chain Optimization Technologies organization is for you.

Watch this video to learn more about our organization, SCOT: http://bit.ly/amazon-scot

Strategic Sourcing Systems (OSS) at Amazon is seeking a Business Intelligence Engineer (BIE) to join our team. As a BIE in this role, you will be a key contributor to enhancing the Inbound efficiency and accurate predictions of our supply chain sourcing inbound operations through business intelligence. Our current focus is on improving overall visibility that Amazon has into incoming inbound freight through improving signal quality as well as signal aggregation. This allows us to orchestrate inbound freight through the supply chain, and improve overall inbound lead times. You will collaborate with cross-functional teams to drive data-driven insights that optimize inbound signals, scheduling, and overall supply chain performance.

Key job responsibilities

Design, develop, and maintain complex data models and ETL pipelines to support operations and a diverse portfolio of business intelligence products, tools, and services

Create and optimize SQL queries for large-scale data analysis, diving deep into data to analyze root causes and implement simple, long-term solutions

Build and maintain interactive dashboards and visualizations that support business decisions and strategic initiatives across Ops teams

Partner with business stakeholders and product/tech teams to understand requirements, identify opportunities for innovation and improvement, and translate them into technical solutions

Conduct in-depth analyses and create comprehensive reports aligned with S-Team and OLT goals to drive company-wide success

Implement data quality controls and monitoring systems to ensure data integrity and reliability at scale

Develop automated reporting solutions and self-service analytics capabilities, staying current with trends and best practices in business intelligence and data analytics

Collaborate with data engineering and product/tech teams to optimize data architecture and performance within a highly collaborative, fast-paced environment

Mentor team members and share knowledge to foster a culture of continuous learning within the organization

About the team

The Optimal Sourcing Systems (OSS) team at Amazon is at the forefront of revolutionizing global supply chain management. We are responsible for developing and implementing cutting-edge algorithmic solutions and data platforms that drive Amazon's sourcing decisions worldwide. Our mission is to optimize the entire procurement process, from vendor selection to inventory placement, ensuring the most efficient and cost-effective supply chain operations. We tackle complex challenges that directly impact Amazon's bottom line and customer satisfaction by leveraging advanced analytics, machine learning, and big data technologies to make data-driven decisions that optimize costs, improve delivery times, and enhance product availability across millions of items.

Basic qualifications

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

- Experience with data modeling, warehousing and building ETL pipelines

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

- Experience writing complex SQL queries

- Experience in Statistical Analysis packages such as R, SAS and Matlab

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

Preferred qualifications

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

- Knowledge of Microsoft Excel at an advanced level, including: pivot tables, macros, index/match, vlookup, VBA, data links, etc.

- Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift

- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets

- Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business

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.