Business Intelligence Engineer II, AWS DC Central Operations
About The Position
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. We are looking for a Business Intelligence Engineer to design and own customer-facing analytics products and to drive analytics adoption across our customer teams. You will partner with operations leaders to translate business questions into measurable KPIs, build dashboards and metric layers in QuickSight, and increasingly leverage GenAI tools — Amazon Q, natural language query interfaces, and retrieval-augmented analytics — to multiply your impact across thousands of users. Successful BIEs on this team are customer-obsessed, comfortable with operational ambiguity, and equally interested in building great dashboards and in teaching customers to build their own. They write strong SQL, communicate clearly with non-technical leaders, and treat GenAI as a tool they actively use rather than a topic to read about.
Requirements
- 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
Nice To Haves
- 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
- Experience using analytical specific tools such as Google analytics, SQL or HTML
- Experience with developing machine learning and natural language processing products
- Experience working in an operations, supply chain, transportation, project management or management consulting role
- Experience building data pipelines or automated ETL processes
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
- Design Amazon Q topics and supporting datasets that enable customer analysts to self-serve on questions previously requiring a CIAT engagement
- 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
Benefits
- 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
- parental leave
- sign-on payments
- restricted stock units (RSUs)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
