Business Intelligence Engineer II, SCOT - Long Term Planning and Forecasting

Amazon Inc.; Bellevue (WA); Sur place; USD 100 000 - 160 000; Plein temps

Résumé du poste

Amazon.com Services LLC in Bellevue, WA, is seeking a data/BI engineer to develop dashboards, data models, and automated reporting for long-term planning and forecasting. You will collaborate with cross-functional teams to surface insights that guide Topline, Inventory, and Capacity decisions and improve algorithms and data quality.

The role emphasizes hands-on data analysis, ETL pipelines, and adoption of AI-driven improvements; experience with Redshift, SQL, and visualization tools is

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc.
• 1+ years of SQL, ETL or Oracle experience
• 1+ years of processing large, multi-dimensional datasets from multiple sources
• 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

Responsabilités

• Develop and maintain analytical dashboards, reports, and data pipelines using Amazon QuickSight, SQL, and AWS services to track forecast performance across Topline, Inventory, and Capacity planning — following established architectural patterns and team standards to ensure solutions are reliable and well-documented
• Collaborate with scientists, engineers, and product managers to gather requirements and deliver data solutions that surface root-cause insights — escalating trade-offs and prioritization decisions to senior team members when needed
• Build and maintain data models, ETL processes, and automated reporting mechanisms that enable data-driven decision making — optimizing for performance and reliability within the team's existing frameworks
• Leverage generative AI tools and techniques to accelerate insight generation and automate reporting workflows, contributing ideas for new AI-driven improvements to the team's analytical processes
• Conduct deep-dive analyses to identify trends, patterns, and opportunities for improvement — delivering clear findings on well-scoped business questions and contributing to analyses on more complex or ambiguous problems with guidance from senior team members
• Proactively identify data quality issues, dependencies, and bottlenecks — troubleshooting and resolving issues within scope and escalating broader systemic problems with clear documentation
• Own and deliver medium-complexity projects from start to finish — developing project plans, tracking milestones, and communicating findings clearly to team leads and stakeholders
• Adopt and champion team best practices in data modeling, metric definitions, and code quality — proactively identifying opportunities to improve processes and tools within your area of ownership
• Support onboarding of new team members and contribute to knowledge-sharing initiatives; participate in hiring loops and technical assessments as a bar raiser candidate (with development support)

Connaissances

Data analysis

SQL

Python scripting

Statistical analysis

ETL development

Data visualization

Data modeling

Outils

Tableau

Quicksight

AWS Redshift

Oracle

NoSQL

Description du poste

Description

Where will Amazon's growth come from next year? In five years? Which product lines are staged to quintuple in size, and which ones are mature? Are we investing enough in our infrastructure, or too much? How will our customers react to changes in prices, or selection, or delivery speed? The SCOT Long-Term Planning and Forecasting (LTPF) team works to answer these key questions.

Where will Amazon's growth come from next year? In five years? Which product lines are staged to quintuple in size, and which ones are mature? Are we investing enough in our infrastructure, or too much? How will our customers react to changes in prices, or selection, or delivery speed? The SCOT Long-Term Planning and Forecasting (LTPF) team works to answer these key questions.

The Supply Chain Optimization Technology (SCOT) team owns Amazon's global inventory planning systems: SCOT decides what, when, where, and how much inventory to buy in order to meet customer needs as well as Amazon's business goals. We do this for millions of items, for hundreds of product lines worth billions of dollars of inventory world-wide. Our systems are built entirely in-house, and represent the forefront of automated large scale supply chain planning and optimization systems.. SCOT LTPF is responsible for long-term forecasting and planning across Topline, Inventory, and Capacity — helping Amazon plan key metrics including ordered units and GMS, inventory units and cost, and FC building capacity and topology (size and location).

Key job responsibilities

• Develop and maintain analytical dashboards, reports, and data pipelines using Amazon QuickSight, SQL, and AWS services to track forecast performance across Topline, Inventory, and Capacity planning — following established architectural patterns and team standards to ensure solutions are reliable and well-documented
• Collaborate with scientists, engineers, and product managers to gather requirements and deliver data solutions that surface root-cause insights — escalating trade-offs and prioritization decisions to senior team members when needed
• Build and maintain data models, ETL processes, and automated reporting mechanisms that enable data-driven decision making — optimizing for performance and reliability within the team's existing frameworks
• Leverage generative AI tools and techniques to accelerate insight generation and automate reporting workflows, contributing ideas for new AI-driven improvements to the team's analytical processes
• Conduct deep-dive analyses to identify trends, patterns, and opportunities for improvement — delivering clear findings on well-scoped business questions and contributing to analyses on more complex or ambiguous problems with guidance from senior team members
• Proactively identify data quality issues, dependencies, and bottlenecks — troubleshooting and resolving issues within scope and escalating broader systemic problems with clear documentation
• Own and deliver medium-complexity projects from start to finish — developing project plans, tracking milestones, and communicating findings clearly to team leads and stakeholders
• Adopt and champion team best practices in data modeling, metric definitions, and code quality — proactively identifying opportunities to improve processes and tools within your area of ownership
• Support onboarding of new team members and contribute to knowledge-sharing initiatives; participate in hiring loops and technical assessments as a bar raiser candidate (with development support)

A day in the life

LTPF BI Engineers focus on how our customers use our forecasts and plans, and ensuring it's as easy as possible to access and understand them. We serve on the front lines of forecast and plan validation as a proxy for our customers, making sure changes across Topline, Inventory, and Capacity are well understood and clearly communicated. We develop reports and data access points that answer key questions about forecast performance, inventory positioning, and capacity planning — and work with science and engineering teams to resolve forecast and planning questions.

Amazon offers a full range of benefits that support you and eligible family members, including domestic partners and their children. Benefits can vary by location, the number of regularly scheduled hours you work, length of employment, and job status such as seasonal or temporary employment.

The benefits that generally apply to regular, full-time employees include:

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

At Amazon, we value people with unique backgrounds, experiences, and skillsets.

About The Team

Long-Term Planning & Forecasting (LTPF) enables coordinated long-term planning and drives critical decisions that maximize Amazon's ability to serve customers worldwide. The organization develops forecasting, optimization, and analytics products and services to plan Amazon's Topline, Inventory, as well as Capacity and Topology, driving strategic decisions and Amazon policies to improve key business metrics.

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

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

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 Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits.

USA, WA, Bellevue - 99,500.00 - 160,000.00 USD annually

Company - Amazon.com Services LLC

Job ID: A10552186