Sr Business Intelligence Engineer III, SCOT - Long Term Planning and Forecasting

Socket.dev; Bellevue (WA); On-site; USD 130,000 - 176,000; Full time

Benefits offered by this job

Medical, Dental, Vision coverage

Paid Time Off

401(k) Plan

Parental Leave

Job summary

Amazon's Long-Term Planning & Forecasting (LTPF) team seeks a Business Intelligence Engineer to build and maintain analytics for Topline, Inventory, and Capacity planning. You will design scalable dashboards, data models, and ETL pipelines using QuickSight, SQL, and AWS services, driving data-driven decisions and stakeholder collaboration.

You will lead analytics projects, mentor teammates, and contribute to forecasting strategies, while ensuring data quality and timely insights for management

Qualifications

• 5+ years of SQL experience.
• 5+ years processing large, multi-dimensional datasets.
• 5+ years of developing automated reporting experience.
• 5+ years of performing statistical analysis experience.
• Experience programming to extract, transform and clean large data sets.
• Experience with theory and practice of design of experiments and statistical analysis of results.
• Experience with AWS technologies.
• Experience in scripting for automation (e.g. Python) and advanced SQL skills.
• Experience with theory and practice of information retrieval, data science, machine learning and data mining.

Responsibilities

• Design, develop, and maintain scalable analytical solutions, dashboards, and data pipelines using Amazon QuickSight, SQL, and AWS services to track forecast performance across Topline, Inventory, and Capacity planning - ensuring solutions are extensible, well-architected, and easy for others to maintain
• Partner with scientists, engineers, product managers, and cross-functional stakeholders to gather requirements, prioritize initiatives, and deliver data solutions that drive to root cause
• Build and optimize data models, ETL processes, and automated reporting mechanisms that enable data-driven decision making across the organization
• Identify and implement opportunities to integrate generative AI into analytical tools and processes, accelerating insight generation and automating reporting workflows
• Conduct deep-dive analyses to identify trends, patterns, and opportunities for improvement, leading the analytics strategy for complex and ambiguous business questions independently
• Identify and mitigate data quality issues, dependencies, and bottlenecks; expedite and drive resolution as needed
• Take the lead on large projects from start to finish — developing project plans, tracking milestones, and communicating findings effectively to management audiences
• Influence the team's analytics strategy and drive best practices in data modeling, metric definitions, and code quality — continuously improving processes and tools
• Mentor and develop other team members; participate in hiring and technical assessments

Skills

SQL

Data processing

Automated reporting

Statistics

Python scripting

ML / data mining

AWS

Data retrieval

Tools

Amazon QuickSight

ETL tooling

Python

Job 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.

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).

SCOT LTPF is looking for a Business Intelligence Engineer to support the team. LTPF BI Engineers build and maintain analytical tools supporting Topline, Inventory, and Capacity planning, and engage with internal stakeholders and external consumers of LTPF forecasts to ensure they have timely data in the right context to answer key business questions. The ideal candidate will have experience in leading analytics projects including but not limited to: forecasting, business monitoring, business intelligence and data visualization. The candidate should also have experience mapping analytical solutions to business problems in the most ambiguous environments with a track record of making data easy to consume for end users. This position will require extensive stakeholder and project management.

Key job responsibilities

• Design, develop, and maintain scalable analytical solutions, dashboards, and data pipelines using Amazon QuickSight, SQL, and AWS services to track forecast performance across Topline, Inventory, and Capacity planning - ensuring solutions are extensible, well-architected, and easy for others to maintain
• Partner with scientists, engineers, product managers, and cross-functional stakeholders to gather requirements, prioritize initiatives, and deliver data solutions that drive to root cause
• Build and optimize data models, ETL processes, and automated reporting mechanisms that enable data-driven decision making across the organization
• Identify and implement opportunities to integrate generative AI into analytical tools and processes, accelerating insight generation and automating reporting workflows
• Conduct deep-dive analyses to identify trends, patterns, and opportunities for improvement, leading the analytics strategy for complex and ambiguous business questions independently
• Identify and mitigate data quality issues, dependencies, and bottlenecks; expedite and drive resolution as needed
• Take the lead on large projects from start to finish — developing project plans, tracking milestones, and communicating findings effectively to management audiences
• Influence the team's analytics strategy and drive best practices in data modeling, metric definitions, and code quality — continuously improving processes and tools
• Mentor and develop other team members; participate in hiring and technical assessments

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

If you are not sure that every qualification on the list above describes you exactly, we'd still love to hear from you!

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:

• 5+ years of SQL experience
• 5+ years of processing large, multi-dimensional datasets from multiple sources experience
• 5+ years of developing automated reporting experience
• 5+ years of performing statistical analysis experience
• 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
• Experience in scripting for automation (e.g. Python) and advanced SQL skills.
• Experience with theory and practice of information retrieval, data science, machine learning and data mining

Preferred Qualifications:

• Experience working directly with business stakeholders to translate between data and business needs
• Experience managing, analyzing and communicating results to senior leadership

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.

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 - 130,400.00 - 176,300.00 USD annually