Amazon
Business Intelligence Engineer II, OpsTech IT, OTS Anchor Team
Austin, Texas, USA · Mid
Sponsorship not specified$100k-$160kDetected 1 day ago
PythonSQLDynamoDBRedshiftAWSData EngineeringData VisualizationNLPLLMsStatisticsOnboardingLeadership
> stay_score
odds of building a lasting career here
59Sponsors, lottery-bound
Cap-exempt (no lottery)0
Sponsors this role100
Entry-level history0
PERM / green-card track0
Lottery odds (Level III)83
Fits your clock70
Sponsors, but it's cap-subject — you still face the weighted lottery (~45% per draw at Level III). Good if you win; have a cap-exempt backup on your list.
Lottery odds assume a STEM candidate.
Personalize to your clock →> community_outcomes
No reports yet — be the first to help the next applicant.
About the role
- 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.
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.
- 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.
- Later, you might optimize a Redshift transformation, publish an updated data model, and improve QuickSight visuals for a nontechnical audience.
Requirements
- 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
Nice to have
- Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift.
Compensation
- $100k-$160k
This listing is sourced directly from Amazon's careers page and normalized into a canonical job model.