Strategic BI Engineer for Long-Term Forecasting

Amazon; Bellevue (WA); On-site; USD 100,000 - 160,000; Full time

Benefits offered by this job

Medical, Dental, and Vision Coverage

PTO

401(k) Plan

Job summary

Amazon in Bellevue, WA is seeking a Business Intelligence Engineer II for the SCOT Long-Term Planning and Forecasting team. You will build dashboards, data models, and ETL processes to surface forecast performance across Topline, Inventory, and Capacity planning.

The role requires experience with SQL, data visualization tools like Tableau or Quicksight, and the ability to manage medium-complexity projects end-to-end; collaborate with scientists, engineers, and product managers; and apply

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.

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.
• Collaborate with scientists, engineers, and product managers to gather requirements and deliver data solutions that surface root-cause insights.
• Build and maintain data models, ETL processes, and automated reporting mechanisms.
• Leverage generative AI tools to accelerate insight generation and automate reporting workflows.
• Conduct deep-dive analyses to identify trends and opportunities for improvement.
• Proactively identify data quality issues and bottlenecks and document findings.
• Own and deliver medium-complexity projects from start to finish.
• Adopt and champion team best practices in data modeling and code quality.
• Support onboarding of new team members and participate in hiring processes as a bar raiser.

Skills

SQL

ETL

Data analysis

Python

Tableau/Quicksight

Data visualization

R/SAS/Matlab

Data modeling

Warehousing

Scripting (Python)

Tools

Tableau

Quicksight

Python

Job description

Amazon in Bellevue, WA is seeking a Business Intelligence Engineer II for the SCOT Long-Term Planning and Forecasting team. You will build dashboards, data models, and ETL processes to surface forecast performance across Topline, Inventory, and Capacity planning.

The role requires experience with SQL, data visualization tools like Tableau or Quicksight, and the ability to manage medium-complexity projects end-to-end; collaborate with scientists, engineers, and product managers; and apply