Business Intelligence Engineer, Forecasting & Labs Analytics

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

Job summary

A leading e-commerce company is looking for a Business Intelligence Engineer in Toronto. This role requires expertise in data mining, analysis, and the development of scalable data solutions. Candidates should have experience with Redshift, SQL, and ETL pipelines. With a salary range of CAD 76,400.00 - 127,600.00 annually, the position offers a great opportunity to work with complex datasets and contribute to impactful business decisions.

Benefits

Medical, dental, vision coverage

Maternity and parental leave options

Paid time off (PTO)

Qualifications

• 3+ years of experience analyzing and interpreting data.
• Expertise in SQL to pull data from databases.
• Experience in using AWS solutions such as EC2, DynamoDB, S3, and Redshift.

Responsibilities

• Apply mining and statistical models to understand customer interactions.
• Build scalable solutions to provide insights for business decisions.
• Optimize performance of business-critical queries.

Skills

Experience with Redshift

Data modeling

Complex SQL queries

Data visualization using Tableau

ETL pipelines

Scripting experience in Python

Statistical Analysis packages

AWS solutions

Job description

Overview

The Supply Chain Optimization Technologies (SCOT) organization has an immediate need for a creative business intelligence engineer (BIE) with a passion for building systems that have a measurable impact. The right candidate will be innovative and technically versatile. You will have the opportunity to work with one of the largest and most complex warehouses in the world to gather insights from across Amazon. As a BIE, you should be an expert in the architecture of data warehouse solutions for the enterprise using multiple platforms. You should excel in the design, creation, management, and business use of extremely large datasets. Excellent business and communication skills are required to work with business analysts and data engineers to understand how best to design reporting and analytics data systems.

Responsibilities

• Apply mining, quantitative analysis, and statistical models to understand how our customers interact with us and identify ways to improve the customer experience and meet our goals
• Build scalable solutions and self-serve platforms that will provide insights to inform business decision making
• Optimizing the performance of business-critical queries and dealing with ETL job-related issues
• Gathering and understanding data requirements, working with the team to achieve high quality data ingestion and building systems that can process, transform, and store the data in various relational and non-relational stores
• Dive deeply into technical details (e.g., key dependencies, design choices, operability, etc.) with engineering teams and drive constructive technical discussions. Extracting and combining data from various heterogeneous data sources
• Build and evaluate end-to-end designs for strengths and weaknesses (quality, scalability, latency, security, performance, data integrity, etc.)
• Create interactive visual dashboards with Tableau and QuickSight
• Write clear documentation, architecture documents and create an engineering roadmap
• Explore and learn the latest AWS technologies to provide new capabilities and increase efficiency

Qualifications

• Experience with Redshift, Oracle, NoSQL, and 3+ years of analyzing and interpreting data
• 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
• 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

Benefits

Amazon offers a range of benefits that support employees and eligible family members, including domestic partners and their children. Benefits can vary by location, hours, length of employment, and job status. Regular, full-time employees generally receive medical, dental, vision coverage; maternity and parental leave options; paid time off (PTO); and other benefits. The base salary range listed is CAD; final compensation includes additional elements such as sign-on payments and restricted stock units (RSUs) where applicable.

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

EEO and Accommodations

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status. 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.