BI Engineer II, OpsTech Analytics & AI Insights

Amazon; Austin (TX); On-site; USD 100,000 - 160,000; Full time

Benefits offered by this job

Health insurance

RSUs

Paid time off

Parental leave

Job summary

Amazon in Austin, Texas seeks a Business Intelligence Engineer II to build data pipelines, models, dashboards, and AI-assisted analytics that help Field IT leaders understand performance and make informed decisions. You will work across the analytics lifecycle, from raw data to executive scorecards, emphasizing accuracy, clarity, and scalable reporting.

You will design data models, optimize Redshift transformations, and deliver dashboards using QuickSight for leadership reviews.

Qualifications

• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or related field.
• 3+ years of SQL, ETL or Oracle experience.
• 3+ years handling large, multi-dimensional datasets from multiple sources.
• Experience with data modeling, warehousing and building ETL pipelines.
• Experience with data visualization using Tableau, Quicksight, or similar tools.
• Experience using SQL to pull data from a database or data warehouse and scripting (Python) to process data for modeling.

Responsibilities

• Write and optimize advanced SQL and Redshift transformations across large operational datasets.
• Design data models and staging layers that convert Field IT data into reliable metrics.
• Build and maintain Weekly Operational Review and Quarterly Business Review dashboards and scorecards in Amazon QuickSight and Quick Suite.
• Validate and reconcile metrics before they are included in leadership reporting.
• Investigate metric discrepancies by reviewing definitions, transformation logic, and upstream source systems.
• Translate operational questions into clear, consistent, and defensible measurements.
• Apply generative AI and LLM-assisted methods to support anomaly investigation, metric analysis, and self-service reporting.
• Partner with analysts, engineers, and program leaders to define new metrics and retire unused metrics.

Skills

SQL

ETL

Oracle

Data modeling

Warehousing

Tableau

Quicksight

Python

AWS

Redshift

S3

EC2

DynamoDB

Education

Bachelor's degree in CS/Engineering/Math

Tools

Tableau

Quicksight

Python

Job description

Amazon in Austin, Texas seeks a Business Intelligence Engineer II to build data pipelines, models, dashboards, and AI-assisted analytics that help Field IT leaders understand performance and make informed decisions. You will work across the analytics lifecycle, from raw data to executive scorecards, emphasizing accuracy, clarity, and scalable reporting.

You will design data models, optimize Redshift transformations, and deliver dashboards using QuickSight for leadership reviews.