Business Intelligence Engineer, NA S&OP Analytics

- Mid Level

Bellevue, WA

General Merchandise Retailers

About the position

Have you ever ordered a product on Amazon and when that box with the smile arrived you wondered how it got to you so fast? Have you wondered where it came from and how much it cost Amazon to deliver it to you? If so, the S&OP Planning Analytics team is for you. We manage the fulfilment of millions of products every week to Amazon's customers, achieving on-time delivery in a cost-effective manner to deliver a smile for our customers. North America S&OP is looking for a customer focused, analytically and technically skilled Business Intelligence Engineer to drive effective performance measurement and management, innovation and execution in last mile delivery. This position will be responsible for playing a key role in our placement and optimization team building out analysis and visualization tools and processes' to support the network. The successful candidate will be able to effectively retrieve, integrate, visualize and present critical data to improve the efficiency of the package delivery network, and enable efficient management of a large global logistics system. This individual will work with technical and business teams to optimize planning, execution, process improvement and track progress against goals. This role requires an individual with excellent analytical abilities as well as outstanding business acumen and comfort with technical teams and systems. The successful candidate will be a self-starter comfortable with ambiguity, with strong attention to detail, and enjoy working with large scale of data.

Responsibilities

• Working with technology and analytics teams to support the development of tools, automation, and dashboards
• Engineering critical input and output metrics across the full operations spectrum
• Creating process performance metrics to measure operational performance, identify root causes and trends, and prescribe action plans for delivery stations around the NA region
• Managing metrics across multiple projects simultaneously
• Communicating with and supporting various internal stakeholders and external audiences
• Partner with internal stakeholders across multiple teams, gathering requirements and delivering complete solutions
• Partner with Data Engineering and Software Development Engineers to prioritize and define S&OP data and BI development needs

Requirements

• 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 writing complex SQL queries
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
• Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field
• Experience in Statistical Analysis packages such as R, SAS and Matlab

Nice-to-haves

• 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 working as a BIE in a technology company

Benefits

• Full range of medical, financial, and/or other benefits
• Equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package