Business Intelligence Engineer, Amazon Autos

DESCRIPTION

We're on a journey to build something new! Come join our team and build new discovery and shopping products that connect customers with their vehicle of choice. We're looking for a talented Business Intelligence Engineer (BIE) to join the fast growing team.

This high-visibility role will be responsible for supporting local data management, report creation, and strategic analytic needs for our day to day operation and decision making.

A successful candidate will be a self-starter, comfortable with ambiguity, and be able to create and maintain automated processes efficiently. They will set the vision, define the roadmap, and work alongside stakeholders across organizations to deliver results. They know and love working with business intelligence tools, can model multidimensional datasets, and can collaborate effectively with business and tech leaders to answer key business questions in a fraction of the time that it takes their peers.

This role will have an immediate and lasting impact on both internal and external customers, and provides a unique opportunity to impact Amazon’s Advertising and Retail business.

Key job responsibilities

• Partner with stakeholders: Gather requirements and deliver end-to-end BI solutions (dashboards, data models, reporting) that address key business needs.

• Build scalable data solutions: Design and maintain ETL pipelines and data models using SQL and scripting languages to integrate data from multiple sources (e.g., Redshift, Oracle).

• Insights & decision support: Analyze performance trends, identify key drivers, and deliver actionable, data-driven recommendations to inform strategy and planning.

• Ensure data quality & rigor: Apply best practices in data integrity, validation, experiment design, and documentation to maintain a trusted data source.

• Innovate with data & AI: Evaluate and implement new data technologies and AI-driven approaches to automate insights and improve decision-making efficiency.

A day in the life

• This role supports the Ads Autos strategic finance and business leadership teams to drive informed decision making.

• You will support the Ads Autos Store with robust data needs that span various business domains which are all related to a new line of business for Amazon

• Our team supports multiple reporting mechanisms, including development of systems on AWS, micro services, and pipelines

BASIC QUALIFICATIONS

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience

• Experience with data modeling, warehousing and building ETL pipelines

• Experience in writing complex, highly-optimized SQL queries across large datasets

• Experience with statistical analytics and programming languages such as R, Python, Ruby, etc.

• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

• Experience visualizing data in Tableau or other relevant data visualization software

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.

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