Business Intelligence Engineer II, SCOT-FO, TVP

About the role

The Amazon Supply Chain Optimization Technologies (SCOT) team works on some of the world's most complex supply chain challenges, at Amazon scale. We understand inventory availability for the millions of items on Amazon, compute accurate delivery expectations for customer orders, and monitor fulfillment network changes to inform delivery updates and optimizations.

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

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• 1+ years of SQL, ETL or Oracle experience
• 1+ years of processing large, multi-dimensional datasets from multiple sources experience
• 1+ years of performing statistical analysis experience
• 1+ years of developing automated reporting experience
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• 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

Benefits

• Medical, Dental, and Vision Coverage
• Maternity and Parental Leave Options
• Paid Time Off (PTO)
• 401(k) Plan