"Alerted.org

Description

Role Summary

We are seeking a Business Intelligence Engineer to join our Customer Service Engineering Services team at Ring & Blink. This role focuses on delivering reliable reporting and analytics today, while gaining exposure to and contributing toward the team’s evolution into next-generation analytics and data consumption patterns beyond traditional static dashboards.

You will build and maintain analytics solutions using tools such as Tableau and Amazon QuickSight, while also partnering with senior BI and Data Engineers to support emerging approaches to analytics, automation, and AI-enabled insights as the data platform matures. This role is execution-focused, with strong opportunities for learning, growth, and increasing ownership over time.

Role Context

The team is migrating customer support data to a new, dedicated Redshift cluster as part of a broader effort to establish full ownership of our data platform. Core data designs and migration plans are already defined. This role will support migration execution and data validation as needed, while maintaining a primary focus on ongoing reporting, analytics delivery, and documentation before, during, and after the migration.

Key job responsibilities

• Build, maintain, and enhance analytics solutions, including dashboards and reports using Tableau, QuickSight, and other reporting or analytics interfaces, to support operational and business decision-making

• Partner with senior BI Engineers to translate reporting requirements into clear, accurate, and maintainable analytics outputs

• Support the data migration effort by executing defined migration or backfill tasks, validating migrated data, and helping ensure reporting continuity during the transition to the new Redshift cluster

• Perform data validation and reconciliation to ensure accuracy and consistency between source systems and the new data platform

• Write and maintain SQL queries to support reporting, ad-hoc analysis, migration validation, and data quality checks

• Partner with senior BI and Data Engineers to support and learn emerging analytics patterns, such as automated insights, AI-assisted analysis, or alternative data consumption experiences, as the team evolves beyond static reporting

• Create and maintain clear, structured documentation for datasets, reports, migration steps, validation results, and known data caveats

• Help identify data quality issues, inconsistencies, or reporting gaps and escalate findings with clear context and proposed next steps

• Follow established data governance, security, and access guidelines when handling customer support data

• Support post-migration reporting updates, including updating dashboards, queries, and data sources to align with the new platform

About the team

The CS Engineering Services team powers customer service operations for Blink and Ring, unifying expert Salesforce developers, software engineers, BI engineers, and data scientists. We deliver innovative solutions that enhance customer experience and agent effectiveness through advanced solutions and data-driven insights. Our culture emphasizes rapid prototyping, creative problem-solving, and continuous learning through cross-training. Team members are empowered to think strategically and propose innovative approaches to complex problems.

Basic Qualifications

- 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience

- Experience with data visualization using Tableau, Quicksight, or similar tools

- Experience with scripting language (e.g., Python, Java, or R)

- Knowledge of data warehousing and data modeling

- Experience that includes strong analytical skills, attention to detail, and effective communication abilities

- Experience working with code repositories (e.g., Git), including reviewing, updating, and maintaining analytics or data-related code

Preferred Qualifications

- Knowledge of data modeling and data pipeline design

- Experience with AWS services including S3, Redshift, Sagemaker, EMR, Kinesis, Lambda, and EC2

- Experience using Salesforce

- Experience working in a fast-paced, team environment

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 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 $74,100/year in our lowest geographic market up to $165,600/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.