Business Intelligence Engineer, Key

Description

Come join the Amazon Key for Business team and help drive the transformation of our customer delivery experience  for Business, our patented building access technology, supports Amazon Last Mile across the US. Ring SMB extends this ecosystem to small and medium businesses with security, access control, and subscription-based services.

We are looking for a Business Intelligence Engineer to join our Key Data & BI team and help inform the direction of Ring SMB and Key for Business through data, s role spans two high-impact business verticals - Ring SMB and KfB NA-Multifamily - and sits at the center of the team's AI-first transformation, where production AI agents, automated ETL workflows, and AI-assisted analytics are how work gets done today.

Successful candidates will be comfortable creating and optimizing table structures, identifying KPIs that drive the business, generating reports consumed across the organization, analyzing data to inform strategic and tactical initiatives, and writing up findings for less-technical audiences. Strong SQL is a must. AI fluency, scripting skills, and a background in operations or product analytics are extremely valuable.

This is a highly visible role that partners with business, product management, operations, finance, marketing, and engineering teams across Key for Business and Ring SMB

Key job responsibilities

-  Design, implement, and support data platforms providing ad hoc and scheduled access to large datasets

-  Manipulate and mine data from database tables (Redshift, MySQL, Quick Sight SPICE) using SQL and ETL pipelines; write scripts (Python, UNIX) to process log files and telemetry data at scale.

-  Develop and own analytical tools including deep-dive tools, dashboards (Quick Sight, Tableau), Page 0 reporting surfaces, and executive-ready metric visualizations.

-  Own and deliver weekly (W ), monthly (M ), and quarterly (Q ) executive reporting with data pulls, narrative insights, and metric deep dives

-  Monitor existing metrics, develop and propose new metrics, and identify actionable risk signals

-  Lead LTV analyses to inform promotional strategy, campaign measurement, and business decisions

-  Perform deep-dives and root cause analysis to answer business questions; complete ad hoc data retrieval and analysis for product, finance, marketing, and operations stakeholders.

-  Work with cross-functional stakeholders to define the source of truth for business metrics and obsessively ensure data fidelity across verticals.

-  Effectively communicate (written and verbal) analytical findings, solutions, and methodologies to senior leadership and less-technical audiences.

-  Work with engineering teams to enable appropriate capture and storage of data, including PII/non-PII data governance and compliance.

- Create and contribute to the team's production AI agent ecosystem by feeding accurate datasets, metric definitions, and knowledge base content to agents

-  Support metric framework development and provide foundational BI signals

-  Leverage and extend AI-assisted workflows for automated ETL, TextQL for ad-hoc analysis, and the Skill Markdown Methodology for encoding domain knowledge into AI agents.

Basic Qualifications

- 3+ years of analyzing and interpreting data with Redshift, Oracle, No

SQL 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

-…