Business Intelligence Engineer , North America Network Sales and Operations planning

DESCRIPTION

At Amazon Supply Chain, we power the world's fastest-growing e-commerce business and embrace the mission of being Earth’s most customer-centric company. As our business continues to expand, the customer fulfillment operations become larger and more complex each year.

The Network Sales and Operations Planning (S&OP) team forecasts all inventory flows across the entire North America Fulfillment network. We manage everything from what Amazon receives from vendors and sellers to what it ships from our Fulfillment Centers (FCs). The network S&OP forecast is the starting point of a weekly planning process spanning first, middle mile, last mile and defining the amount of resources (trucks, labor) that need to be secured to ensure we fulfill our customer orders at the highest speed, best quality, lowest cost and least carbon intensity as possible. We partner closely with Supply Chain Optimization Technology (SCOT) teams in North America and internal tech stakeholders across Transportation, Labor Planning and Finance teams to reconcile bottom-up and top-down inputs to build analytical forecasts which are accurate and provide valuable insight. We also partner with Supply Chain Execution (SCE) teams as well as Science partners to define the optimal allocation under constraints of volumes across the 9 Regions of the US fulfillment network.

We are now seeking a Business Intelligence Engineer to be part of a 2-3 person analytical group within the network S&OP team. This is a Day 1 opportunity to be part of an entrepreneurial and pioneering team building from the ground up. You will research forecasting techniques, deep dive existing data sources to build new models to improve forecasting accuracy. You will also develop data solutions and advanced visualization techniques to offer forecast analysis to senior stakeholders (up to SVP). You will collaborate with business, product management, and engineering teams to drive progress.

Key job responsibilities

• Develop new forecasting models
• Build advanced visualization solutions to allow business and tech stakeholders to deep dive and understand the teams forecasts.
• Collaborate across multiple teams to ensure alignment with business goals and objectives.

BASIC 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
• Bachelor's Degree
• Experience analyzing and communicating results to senior leadership
• Experience working directly with business stakeholders to translate between data and business needs
• Experience in scripting for automation (e.g. Python) and advanced SQL skills.
• Experience programming to extract, transform and clean large (multi-TB) data sets
• Experience with theory and practice of design of experiments and statistical analysis of results
• Experience with AWS technologies

PREFERRED QUALIFICATIONS

• 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 with statistical analytics and programming languages such as R, Python, Ruby, etc.
• Experience using Cloud Storage and Computing technologies such as AWS Redshift, S3, Hadoop, etc.
• 3+ years of SQL experience
• Master's degree in statistics, data science, or an equivalent quantitative field

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

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.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplement