Business Intelligence Engineer, IT PnD Data & Analytics (DnA)
- Vancouver, BC, Canada
Applications open in a new tab.
Job details
- Posting language
- English
- Posted
Original job description
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.
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, BC, Vancouver - 76,400.00 - 127,600.00 CAD annually
More about this job
Responsibilities
Build and maintain business intelligence solutions including data sets, queries, and dashboards to enable data-driven decision-making. Troubleshoot data issues, automate manual processes, and deliver actionable insights to stakeholders using visualization tools.
Requirements
Requires 3+ years of experience in data analysis with SQL, Redshift, or Oracle, and 2+ years of experience with data visualization tools like Tableau or QuickSight. A bachelor's degree in a quantitative field or equivalent experience is required.
Skills
- SQL
- Python
- Tableau
- QuickSight
- Data modeling
- ETL pipelines
- Data warehousing
- Statistical analysis
- Redshift
- Oracle
- NoSQL
- Data visualization
- Business intelligence
- Scripting
- Data mining
- Problem solving
Benefits
- Health insurance
- Medical
- Dental
- Vision
- Prescription
- Basic life & AD&D insurance
- Deferred profit sharing plan
- Paid time off
- Restricted stock units
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Engineering
- Finance & Accounting
Keywords
- Business Intelligence
- Data Analytics
- SQL
- Python
- Tableau
- QuickSight
- Redshift
- Oracle
- NoSQL
- ETL
- Data Warehousing
- Data Modeling
- Statistical Analysis
- R
- SAS
- Matlab
- AWS
- EC2
- DynamoDB
- S3
- Data Mining
- Business Intelligence Engineer
- Visualization
- Dashboards
- Reporting
- Data Structures
- Scripting
- Metrics
- Quantitative Analysis
- Cloud Computing