Business Intelligence Engineer (BIE)

The Amazon Supply Chain Optimization Technologies (SCOT) team works on complex supply chain challenges at Amazon scale.

The Fulfillment Optimization (FO) team owns products and services that plan and execute First Party (1P) and 3P fulfillment resources for the outbound fulfillment network worldwide.

We are seeking a Business Intelligence Engineer (BIE) with broad technical skills to build analytic and reporting capabilities that enable optimization of delivery promises for our millions of customers worldwide.

The ideal candidate is a highly analytical, critical thinker with advanced problem-solving, data mining, and software development skills.

Key Responsibilities:

• Collaborate with software development teams to implement analytics systems and data structures to support large-scale data analysis and delivery of machine learning and econometric models.
• Define, develop, and maintain critical business and operational reports reviewed on a weekly, monthly, quarterly, and annual basis.
• Analyze historical data to identify trends and support decision-making, including written and verbal presentation of results and recommendations.
• Mine and manipulate data from database tables, simulation results, and log files.
• Identify data needs and drive data quality improvement projects.
• Understand the broad range of Amazon's data resources, which to use, how, and when.
• Provide thought leadership on data mining and analysis.

A Day in the Life:

• Collaborate with the Engineering and Science teams to define new product features, construct data pipelines, and test new functionalities.
• Learn about new Amazon technologies and create proposals to adapt to those technologies.
• Conduct deep dives into anomalies and generate insights for leadership and product management.
• Use customer inputs to define new data requirements.
• Explain plan-over-plan differences or discrepancies between expected and actual performance.
• Maintain dashboards and reporting, and address any data quality issues that arise.

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 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 developing and presenting recommendations of new metrics allowing better understanding of the performance of the business.

Preferred Qualifications:

• Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance, or equivalent quantitative field.
• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift.
• Experience in analyzing and evaluating machine learning algorithms and optimization models.