Business Intelligence Engineer II, SCOT - Forecasting & Labs

Amazon; Toronto; On-site; CAD 76,000 - 128,000; Full time

Job summary

Amazon in Toronto, Ontario is seeking a Business Intelligence Engineer II to enhance forecast accuracy and enable data-driven decisions across forecasting and labs. You will work with Data Engineering/DS/Program teams, leveraging Redshift, Tableau and AWS tools to detect issues, build metrics, and deliver actionable insights.

The role emphasizes partnering with PMs, scientists and engineers to craft forecasting solutions for new business areas, while communicating effectively with senior

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc.
• Experience with data modeling, warehousing and ETL pipelines.
• Experience with data visualization using Tableau, Quicksight, or similar BI tools.
• Experience writing complex SQL queries.
• Experience in Statistical Analysis packages such as R, SAS and Matlab.
• Experience using SQL to pull data from a database and scripting (Python) for modeling.
• Advanced Excel skills and BI tool familiarity (Tableau preferred).
• Ability to communicate effectively with senior leadership.

Responsibilities

• Understand opportunities for improvement and partner with PMs, Science and Engineering to design forecasting solutions.
• Collaborate with machine learning researchers to solve forecasting challenges for new businesses Amazon keeps inventing.
• Communicate and earn trust with our customers in retail and our downstream systems.
• Develop robust reporting mechanisms for internal and external teams.

Skills

Redshift

SQL queries

Python

Tableau

Data Visualization

Excel (Advanced)

Senior leadership communication

Education

Master's degree in BI/Finance/Engineering/Statistics/CS

Tools

AWS (EC2/S3/DynamoDB/Redshift)

Quicksight

Job description

Business Intelligence Engineer II, SCOT - Forecasting & Labs

Amazon has the world’s most complex supply chain: we fulfill global demand for hundreds of millions of products at lightning fast delivery speeds. We need your skills to optimize our supply chain, with the end goal of delighting our customers. A core part of the supply chain operations is Demand Forecasting: We forecast the demand of tens of millions of products. These forecasts are used to make many decisions, such as automatically order hundreds of millions worth of inventory, decide where to place that inventory, and establish labor plans for hundreds of warehouses.

We need a creative, smart and enthusiastic Business Intelligence Engineer. Your mission will be to improve forecast accuracy and enable partner teams and customers to optimize supply chain decisions. You will do this by detecting, diagnosing and correcting forecast problems and generating metrics and insights. You will have the resources and tools to help you deliver this mission - support from partner teams like Data Engineering/Data Science/Program, rich datasets and tools like AWS Redshift and Tableau.

Key job responsibilities

As a Business Intelligence Engineer in forecasting, you will be responsible for:

• Understanding the opportunities for improvement and partnering with PMs, Science and Engineering to design solutions to complex forecasting problems.
• Come up with innovative solutions working with our machine learning & research scientists that solves forecasting challenges for new businesses that Amazon keeps inventing.
• Communicate and earn trust with our customers in retail & our downstream systems.
• Develop strong reporting mechanisms for internal and external teams.

A day in the life

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. If you’re passionate about this role and want to make an impact on a global scale, please apply!

Basic Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Experience with data modeling, warehousing and building ETL pipelines
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience writing complex SQL queries
• 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
• Knowledge of advanced skills in Excel as well as any data visualization tools like Tableau or similar BI tools (familiarity with Tableau preferred)
• Experience communicating effectively with senior leadership

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
• Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or 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. As a total compensation company, Amazon's package may include other elements such as sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon offers comprehensive benefits including health insurance (medical, dental, vision, prescription, basic life & AD&D insurance), Registered Retirement Savings Plan (RRSP), Deferred Profit Sharing Plan (DPSP), paid time off, and other resources to improve health and well-being. We thank all applicants for their interest, however only those interviewed will be advised as to hiring status.

CAN, ON, Toronto - 76,400.00 - 127,600.00 CAD annually

Posted: February 27, 2026 (Updated 11 days ago)

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

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
• Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or 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. As a total compensation company, Amazon's package may include other elements such as sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon offers comprehensive benefits including health insurance (medical, dental, vision, prescription, basic life & AD&D insurance), Registered Retirement Savings Plan (RRSP), Deferred Profit Sharing Plan (DPSP), paid time off, and other resources to improve health and well-being. We thank all applicants for their interest, however only those interviewed will be advised as to hiring status.

CAN, ON, Toronto - 76,400.00 - 127,600.00 CAD annually

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