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.

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

- 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 for more information. If the country/region youre applying in isnt 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 TX Austin - 99500.00 - 160000.00 USD annually