BI Engineer II: Data Insights & Dashboards

Amazon Inc.; Seattle, Northern (WA, KY); Hybrid; USD 100,000 - 160,000; Full time

Benefits offered by this job

Health insurance

RSUs

401(k) matching

Paid time off

Job summary

Amazon.com Services LLC in Seattle, WA, is seeking a Business Intelligence Engineer II to design and own analytical solutions turning large datasets into actionable insights. You will build data models, ETL pipelines, dashboards, metrics, and reporting tools while working across engineering, science, product, and business teams.

You will own mid to large scale BI solutions, translating loosely defined problems into analytical deliverables with strong SQL, data modeling, and visualization skills,

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• 1+ years of SQL, ETL or Oracle experience
• 1+ years of processing large, multi-dimensional datasets from multiple sources experience
• 1+ years of performing statistical analysis experience
• 1+ years of developing automated reporting 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

Responsibilities

• Design, build, and maintain BI solutions including data models, ETL workflows, dashboards, and reports that serve your team and its stakeholders, ensuring solutions are testable, performant, and well-documented.
• Collaborate with business partners and technical teams to refine ambiguous problems into specific deliverables, recommend alternatives, and anticipate future analytical needs based on a deep understanding of the business context.
• Apply SQL expertise and data engineering best practices to extract, transform, and load data at scale, while optimizing query performance and minimizing resource usage across the team's data infrastructure.
• Create compelling data visualizations and self‑service reporting tools that enable stakeholders to interpret results independently and make informed decisions quickly.
• Mentor peers on the team's BI architecture and data lineage, contribute to design and scoping discussions, and apply basic statistical methods to support analytical rigor in solving business problems.

Skills

SQL

Data modeling

ETL

Python

Data visualization

Tableau

Quicksight

Big data

Tools

AWS (EC2, S3, Redshift)

Tableau

Quicksight

Job description

Amazon.com Services LLC in Seattle, WA, is seeking a Business Intelligence Engineer II to design and own analytical solutions turning large datasets into actionable insights. You will build data models, ETL pipelines, dashboards, metrics, and reporting tools while working across engineering, science, product, and business teams.

You will own mid to large scale BI solutions, translating loosely defined problems into analytical deliverables with strong SQL, data modeling, and visualization skills,