Business Intelligence Engineer, IT PnD Data & Analytics (DnA)

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

Job summary

Amazon Development Centre Canada in Vancouver seeks a Business Intelligence Engineer to translate data into actionable insights and troubleshoot features across products. You will build BI solutions, create data structures, and deliver secure, scalable analytics that inform leadership decisions.

You will work with SQL, Python, Tableau/Quicksight and AWS data tech, tackling complex datasets while communicating results to stakeholders.

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience.
• 2+ years of Tableau Desktop, Quicksight or other relevant data visualization software experience
• Bachelor's degree or above in business administration, finance, economics, computer science, data science, engineering, or other related field, or 2+ years of Amazon RME (BB/3P) Full Time Exempt experience
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• 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 using SQL (Structured Query Language) to pull data from a database or data warehouse
• Experience using Python scripting to process data for modeling

Responsibilities

• Build BI solutions – data sets, queries, reports, dashboards, analyses – to answer business questions with data
• Deliver end product on schedule based on defined requirements
• Create and populate data structures using schema definition languages
• Write secure, stable, testable code with minimal defects and automate manual processes
• Use analytics tools to deliver actionable insights to stakeholders
• Invent and refine BI solutions to meet business needs
• Troubleshoot data, analyses, and code and propose solutions

Skills

Data analysis

SQL

Python

Data visualization

ETL pipelines

Statistics

Redshift

Education

Bachelor's degree or 2+ years Amazon RME experience

Tools

Tableau

Quicksight

Excel

PowerBI

Redshift

Job description

DescriptionDo you enjoy translating data into actionable insights? Are you excited by the opportunity to troubleshoot features and products at the world's most customer-centric company? Are you passionate about mining data, developing models, using statistical and visualization techniques, and helping leaders make data-driven decisions? Do you want to be a part of a fast-paced, ambiguous environment and contribute to one of the most visited sites on the Internet?

DescriptionDo you enjoy translating data into actionable insights? Are you excited by the opportunity to troubleshoot features and products at the world's most customer-centric company? Are you passionate about mining data, developing models, using statistical and visualization techniques, and helping leaders make data-driven decisions? Do you want to be a part of a fast-paced, ambiguous environment and contribute to one of the most visited sites on the Internet? At Amazon, we hire the best minds in technology to innovate on behalf of our customers. The focus we have on our customers is why we are one of the world’s most beloved brands – customer obsession is part of our company DNA. Business intelligence Engineers use innovative technology to solve complex problems and get to see the impact of their work first-hand. NOTE: By applying to this position, your application may be considered for all Business Intelligence Engineer roles at all locations we hire for in the United States including but not limited to: Greater Seattle Area (Seattle, Bellevue, Redmond), Greater Bay Area (San Francisco, Sunnyvale, Santa Clara), Greater DMV (DC, MD, VA), Austin (TX), New York City (NY), Minneapolis (MN).

Key job responsibilities

As a Business Intelligence Engineer, You Will/may

• Build small- to mid-size business intelligence (BI) solutions – data sets, queries, reports, dashboards, analyses – or components of larger solutions to answer business questions with data
• Use well-defined requirements to build a solution that enables effective, data-driven business decisions. Deliver end product on schedule
• Create and populate data structures using one or more schema definition languages (e.g. DDL, SDL, XSD, RDF)
• Write secure, stable, testable, and maintainable code with minimal defects, and automate manual processes where possible
• Use one or more industry analytics visualization tools (e.g. Excel, Tableau, QuickSight, MicroStrategy, PowerBI) and, as needed, statistical methods (e.g. t-test, Chi-squared) to deliver actionable insights to stakeholders
• Invent, refine, and develop BI solutions to ensure they meet the needs of the business and team goals
• Troubleshoot data, analyses, and code, research root causes, propose solutions, and take ownership in next steps for their resolutions

A day in the life The challenges Business Intelligence Engineers solve for at Amazon are big and impact millions of customers, sellers, and products around the world. Our path is not always simple, so we are selective about who joins us on this journey. There is a certain kind of person who takes on this role at Amazon – someone who is excited by the idea of creating new products, features, and services from scratch while managing ambiguity and the pace of a company whose ship cycles are measured in weeks, not years. We’re on the lookout for the curious, those who think big and want to define the world of tomorrow. At Amazon, you will grow into the high impact individual you know you’re ready to be. Every day will be filled with exciting new challenges, developing new skills, and achieving personal growth. How often can you say that your work changes the world? At Amazon, you’ll say it often. Join us and define tomorrow.

Basic Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• 2+ years of Tableau Desktop, Quicksight or other relevant data visualization software experience
• Bachelor's degree or above in business administration, finance, economics, computer science, data science, engineering, or other related field, or 2+ years of Amazon RME (BB/3P) Full Time Exempt experience
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• 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 using SQL (Structured Query Language) to pull data from a database or data warehouse
• Experience using Python scripting to process data for modeling

Preferred Qualifications

• Master's degree or above in BI, finance, engineering, statistics, computer science, mathematics or equivalent quantitative field
• Knowledge of Microsoft Excel at an advanced level, including: pivot tables, macros, index/match, vlookup, VBA, data links, etc.
• 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
• Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business

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

The 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, BC, Vancouver - 76,400.00 - 127,600.00 CAD annually

Company - Amazon Development Centre Canada ULC Job ID: A10576100