Business Intelligence Engineer II, OpsTech IT, OTS Anchor Team

Operations Technology Solutions builds and operates the technology that keeps Amazon operations sites connected and running. The OTS Ops Tech Analytics team develops the metrics and reporting used in Weekly Operational Reviews and Quarterly Business Reviews.

As a Business Intelligence Engineer II, you will 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.

Key job 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.

A day in the life You may begin the day validating the metrics prepared for an operational review and investigating an unexpected change in a Field IT measure. Later, you might optimize a Redshift transformation, publish an updated data model, and improve QuickSight visuals for a nontechnical audience. You may also work with a program leader to define a new quarterly metric or prototype an LLM assisted workflow that drafts initial explanations for recurring anomalies.

About the team OTS Ops Tech Analytics builds and operates the metrics layer for Operations Technology Solutions. The team produces Weekly Operational Review and Quarterly Business Review scorecards used by Field IT Operations leaders. We are investing in AWS native data pipelines and AI assisted analytics to improve the scale, accuracy, and clarity of our reporting.

Basic 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

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.

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

USA, TX, Austin - 99,500.00 - 160,000.00 USD annually