Business Intelligence Engineer II, AWS DC Central Operations

About the role

The Central Infrastructure Analytics Team (CIAT) is the unified source for Infrastructure Operations data and business intelligence solutions across AWS's global data center fleet. We support Central Operations leaders running rack install, decommission, repair, logistics, capacity optimization, and network operations.

Responsibilities

• Design, build, and maintain dashboards and analytical reporting solutions in QuickSight that support InfraOps decision-making
• Partner with business and technical stakeholders to translate operational questions into KPIs, data products, and Weekly and Monthly Business Review (WBR/MBR) narratives
• Develop and present recommendations to senior leaders, including written narratives and verbal walk-throughs of insights
• Use CIAT's GenAI tools — Amazon Q, natural language query interfaces, and retrieval-augmented analytics — as a primary part of the job
• Contribute to CIAT's analytics enablement programs that train Central Ops analysts on BI tools, query platforms, and GenAI capabilities
• Write SQL against the team's data warehouse and datalake to validate metrics, investigate data quality issues, and prototype analytics

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience writing complex SQL queries
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
• Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
• Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics or equivalent quantitative field