Senior BI Engineer for Long-Term Planning & Forecasting

Amazon; New York (NY); On-site; USD 110,000 - 185,000; Full time

Benefits offered by this job

Medical, Dental, Vision

Maternity leave

PTO

401(k) Plan

Job summary

Amazon’s Long-Term Planning & Forecasting (LTPF) team seeks a BI Engineer to design and maintain analytical dashboards and data pipelines supporting Topline, Inventory, and Capacity planning. You will collaborate with scientists and product managers to transform data into actionable insights and leverage AI to automate reporting processes.

Ideal candidates bring 3+ years of data analysis experience, strong SQL/ETL skills, and proficiency in Tableau or QuickSight, with Python scripting to support

Qualifications

• 3+ years of data analysis and interpretation using Redshift, Oracle, NoSQL.
• 1+ years of SQL, ETL, or Oracle experience.
• 1+ years processing large, multi-source datasets.
• 1+ years of statistical analysis.
• 1+ years developing automated reporting.
• Experience with data visualization using Tableau, QuickSight, or similar tools.
• Experience with data modeling, warehousing, and ETL pipelines.
• Experience with statistical packages like R, SAS, Matlab.
• Python scripting 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 that enable data-driven decision making.
• Leverage generative AI tools and techniques to accelerate insight generation and automate reporting workflows.
• Conduct deep-dive analyses to identify trends and opportunities for improvement.
• Proactively identify data quality issues, dependencies, and bottlenecks.
• Own and deliver medium-complexity projects from start to finish.
• Adopt and champion team best practices in data modeling, metric definitions, and code quality.
• Support onboarding of new team members and participate in hiring loops as a bar raiser.

Skills

Data analysis

SQL

ETL

Python

Data visualization

Data modeling

Statistical analysis

R/SAS/Matlab

Tableau

Quicksight

Tools

Tableau

Quicksight

Job description

Amazon’s Long-Term Planning & Forecasting (LTPF) team seeks a BI Engineer to design and maintain analytical dashboards and data pipelines supporting Topline, Inventory, and Capacity planning. You will collaborate with scientists and product managers to transform data into actionable insights and leverage AI to automate reporting processes.

Ideal candidates bring 3+ years of data analysis experience, strong SQL/ETL skills, and proficiency in Tableau or QuickSight, with Python scripting to support