Business Intelligence Engineer II, Amazon Key

Amazon; Washington (District of Columbia); On-site; USD 89,000 - 185,000; Full time

Job summary

Join Amazon's Key team as a Business Intelligence Engineer II, where you'll transform customer delivery experiences through data analysis. You'll optimize data structures and identify business KPIs to drive strategic initiatives while collaborating with cross-functional teams. Ideal candidates have strong SQL skills and are comfortable with data visualization and statistical analysis.

Benefits

Health insurance

401(k) retirement plan

Employee discounts

Flexible schedule

Professional development

Qualifications

• 3+ years of data analysis with experience in Redshift, Oracle, NoSQL.
• Experience in building ETL pipelines and statistical analysis.
• Strong SQL skills and scripting experience (Python) required.

Responsibilities

• Design and support a platform for ad hoc data access.
• Collect and analyze data for business KPI reporting.
• Communicate findings to senior leadership.

Skills

Data Analysis

SQL

Data Visualization

Scripting

Tools

Tableau

Quicksight

R

Python

ETL tools

Job description

Business Intelligence Engineer II, Amazon Key

Job ID: 3006555 | Amazon.com Services LLC

Come join Amazon Key team and help drive the transformation of our customer delivery experience at scale. Key for Business, our patented building access technology, supports Amazon Last Mile in the US.

We are actively looking for a passionate Business Intelligence Engineer to join our start-up team to help inform the direction of Key for Business through data, at scale. Successful candidate will be comfortable creating and optimizing table structures, identifying KPIs that drive the business, generating reports for those KPIs that are consumed across the Key for Business organization, analyzing data to inform strategic and tactical initiatives, and writing up the findings from analyses for less-technical audiences. Strong SQL (any implementation) is a must. Scripting skills, and background in operations is extremely valuable. This is a highly visible role that partners with business, product management, operations, and the technical team.

This position is open in Austin, TX and Seattle,WA. Candidates must be based in or willing to relocate to one of these locations.

Key job responsibilities
Design, implement, and support a platform providing ad hoc access to large datasets.
Manipulate/mine data from database tables (ex. Redshift, MySQL, Oracle) using SQL and ETL
Manipulate/mine data from log files by writing scripts (ex. PERL, Python, UNIX)
Develop analytical tools: deep-dive tools, UIs, metrics, and dashboard
Perform deep-dives and root cause analysis to answer business questions.
Work with cross functional stakeholders in defining the source of truth and obsessively making sure the data fidelity is high.
Effectively communicate (written and verbal) solutions and methodologies to senior leadership.
Work with engineering teams to enable the appropriate capture and storage of data.
Complete ad hoc data retrieval and analysis.
Monitor existing metrics, develop and propose new metrics, and identify new, actionable risk signals.

A day in the life
Design, implement, and support a platform providing ad hoc access to large datasets.
Manipulate/mine data from database tables (ex. Redshift, MySQL, Oracle) using SQL and ETL
Manipulate/mine data from log files by writing scripts (ex. PERL, Python, UNIX)
Develop analytical tools: deep-dive tools, UIs, metrics, and dashboard
Perform deep-dives and root cause analysis to answer business questions.
Work with cross functional stakeholders in defining the source of truth and obsessively making sure the data fidelity is high.
Effectively communicate (written and verbal) solutions and methodologies to senior leadership.
Work with engineering teams to enable the appropriate capture and storage of data.
Complete ad hoc data retrieval and analysis.
Monitor existing metrics, develop and propose new metrics, and identify new, actionable risk signals.

About the team
Our team is actively seeking motivated and multi-talented individuals who are passionate about transforming the logistics and package delivery operations. We are inventing the next-generation smart delivery operation with technologies in IoT (Internet-of-Things). We develop technology-based solutions matching customer needs and delivery capacity with precision and efficiency, and expanding and transforming delivery experience with unprecedented quality, productivity and scale.

BASIC QUALIFICATIONS

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

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

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.

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits . This position will remain posted until filled. Applicants should apply via our internal or external career site.

Posted: June 12, 2025 (Updated 28 minutes ago)

Posted: May 27, 2025 (Updated about 1 hour ago)

Posted: June 12, 2025 (Updated about 8 hours ago)

Posted: June 12, 2025 (Updated about 8 hours ago)

Posted: June 6, 2025 (Updated about 17 hours ago)

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