Job description

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 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, 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 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. - 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 Company’s 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 amazon.jobs 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. 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 amazon.jobs . USA, CA, Sunnyvale - 114,500.00 - 185,000.00 USD annually USA, WA, Bellevue - 99,500.00 - 160,000.00 USD annually

Requirements

Must-haves

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 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.
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.
USA, CA, Sunnyvale - 114,500.00 - 185,000.00 USD annually

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aisqlpythonaws

Platform: amazon
Effort: medium

Benefits

Benefits detected in the listing.

Health Insurance

Dental

Vision

401(K)

Paid Time Off

Parental Leave