Business Intelligence Engineer, Amazon Autos

Socket.dev; Sunnyvale (CA); On-site; USD 114,500 - 185,000; Full time

Job summary

Socket.dev is seeking a skilled Business Intelligence Engineer (BIE) in Sunnyvale, CA to empower data-driven decisions across ads and retail initiatives. You will partner with stakeholders to design dashboards, data models, and automated reporting, turning complex data into actionable insights.

You will build scalable ETL pipelines using SQL and Python, work with Redshift/Oracle, and apply data visualization tools such as Tableau or QuickSight to drive strategy and measurable impact in our

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience.
• 3+ years of developing automated reporting experience.
• 3+ years of processing large, multi-dimensional datasets from multiple sources experience.

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

Skills

Data analysis

Business intelligence

SQL

Python scripting

Data visualization

Tools

SQL

Python

Tableau

Quicksight

Amazon Redshift

Oracle

NoSQL

Job 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
• 3+ years of developing automated reporting experience
• 3+ years of processing large, multi-dimensional datasets from multiple sources experience
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• 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
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
• Experience in Statistical Analysis packages such as R, SAS and Matlab

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

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 https://amazon.jobs/en/benefits [https://amazon.jobs/en/benefits].

USA, CA, Sunnyvale - 114,500.00 - 185,000.00 USD annually

USA, WA, SEATTLE - 99,500.00 - 160,000.00 USD annually