Business Intelligence Engineer, Key

Come join the Amazon Key for Business 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 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 at scale. This role spans two high-impact business verticals Ring SMB and KfB NA-Multifamily and sits at the center of the teams 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 QuickSight 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 (QuickSight Tableau) Page 0 reporting surfaces and executive-ready metric visualizations.

Own and deliver weekly (WBR) monthly (MBR) and quarterly (QBR) 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 teams 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.

- 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

- 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.

Los Angeles County applicants: Job duties for this position include: work safely and cooperatively with other employees supervisors and staff; adhere to standards of excellence despite stressful conditions; communicate effectively and respectfully with employees supervisors and staff to ensure exceptional customer service; and follow all federal state and local laws and Company policies. Criminal history may have a direct adverse and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above as well as the abilities to adhere to company policies exercise sound judgment effectively manage stress and work safely and respectfully with others exhibit trustworthiness and professionalism and safeguard business operations and the Companys reputation. Pursuant to the Los Angeles County Fair Chance Ordinance we will consider for employment qualified applicants with arrest and conviction records.

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 for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience qualifications and location. Amazon also offers comprehensive benefits including health insurance (medical dental vision prescription Basic Life & AD&D insurance and option for Supplemental life plans EAP Mental Health Support Medical Advice Line Flexible Spending Accounts Adoption and Surrogacy Reimbursement coverage) 401(k) matching paid time off and parental leave. Learn more about our benefits at CA Sunnyvale - 114500.00 - 185000.00 USD annually
USA WA Bellevue - 99500.00 - 160000.00 USD annually