Business Intelligence Engineer II, SCOT - Forecasting & Labs

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

Benefits offered by this job

Medical, Dental, and Vision Coverage

Maternity and Parental Leave Options

Paid Time Off (PTO)

401(k) Plan

Job summary

Amazon Development Centre Canada ULC is seeking a Business Intelligence Engineer to improve forecast accuracy and enable data-driven decisions across the supply chain. You will partner with PMs, science and engineering to design scalable solutions and create insightful dashboards.

You will work with Redshift/Oracle/NoSQL data, build ETL pipelines, craft SQL queries, and communicate actively with stakeholders.

Qualifications

• 3+ years analyzing and interpreting data with Redshift/Oracle/NoSQL.
• 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 and Python scripting for modeling.
• Advanced Excel and BI tool familiarity (Tableau preferred).
• Proactive, independent, able to meet deadlines and deliver on projects.

Responsibilities

• Understand opportunities for improvement and design solutions with PMs, Science and Engineering.
• Collaborate with ML/Research to solve forecasting challenges for new businesses.
• Communicate and earn trust with customers in retail and downstream systems.
• Develop robust reporting mechanisms for internal and external teams.

Skills

Redshift data analysis

SQL querying

ETL pipelines

Tableau/Quicksight

Python scripting

Excel advanced

Problem solving

Stakeholder communication

Education

Master's degree in BI / quantitative field

Tools

AWS Redshift

Tableau

Quicksight

Oracle

NoSQL

Python

Job description

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

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

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)
• Can work proactively and independently, meet deadlines, and deliver on projects and tasks
• Experience handling ambiguous or undefined challenges through strong problem solving abilitiesi>
• Confidence in dealing with technical and non-technical senior level staff.

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

Company

Amazon Development Centre Canada ULC

Job ID: A10470201