BI Engineer II: AI-Powered Analytics & Dashboards

Amazon; Austin (TX); On-site; USD 120,000 - 155,000; Full time

Benefits offered by this job

RSUs

Health insurance

401(k) matching

Paid time off

Parental leave

Job summary

Amazon's OTS Ops Tech Analytics team 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 operational data through executive scorecards, with a strong focus on accuracy, clarity, and scalable reporting.

You will design data models, validate metrics, and collaborate with analysts, engineers, and program

Qualifications

• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field.
• 3+ years of SQL, ETL or Oracle experience.
• 3+ years of processing large, multi-dimensional datasets from multiple sources experience.
• 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 experience (Python) to process data for modeling.

Responsibilities

• Write and optimize advanced SQL and Amazon Redshift transformations across large operational datasets.
• Design data models and staging layers that convert Field IT data into reliable, well documented metrics.
• Build and maintain Weekly Operational Review and Quarterly Business Review dashboards and scorecards in Amazon QuickSight and Amazon 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 large language model assisted methods to support anomaly investigation, metric analysis, and self service reporting.
• Partner with analysts, engineers, and program leaders to define new metrics, improve existing measurements, and retire metrics that no longer provide meaningful insight.

Skills

SQL proficiency

ETL

Data modeling

Data visualization

Python scripting

Education

Bachelor's degree in CS/Engineering/Math/Statistics or related

Tools

Tableau

Quicksight

Job description

Amazon's OTS Ops Tech Analytics team 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 operational data through executive scorecards, with a strong focus on accuracy, clarity, and scalable reporting.

You will design data models, validate metrics, and collaborate with analysts, engineers, and program