Job Description
Business Intelligence Engineer
II, AWS DC
Central Operations Amazon Web Services, Inc. - 3.4 Seattle, WA Job Details Full-time $99,500 - $160,000 a year 4 hours ago Benefits AD&D insurance Health insurance Dental insurance Flexible spending account RSU Paid time off Adoption assistance Parental leave Employee assistance program Vision insurance 401(k) matching Qualifications Data model design Commercial use (data warehousing systems) Data visualization software proficiency Data Integration (Data management) Cloud data warehouses Data modeling projects Business intelligence report generation Schema design SQL ETL process automation Business intelligence tools Redshift Query management Python Data analytics technologies Full Job Description DESCRIPTION
Are you passionate about turning operational data into the decisions that run a global data center fleet? Do you want to do that work on a platform that pairs traditional BI with the GenAI capabilities that are reshaping the field? 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. Key job 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 A day in the life Most days mix a few hours of focused build work — SQL development, dashboard iteration, metric validation — with stakeholder time. You might join a working session with a Logistics or Capacity Optimization team to walk through a metric definition, then sit with one of their analysts to review a query they wrote against CIAT's datalake. After lunch you might pair with a Data Engineer on the data model behind a new WBR metric, draft the narrative for that week's review, and review another BIE's pull request before logging off. On a different day, the focus is an Amazon Q topic for a domain that has been generating repeat ad-hoc requests — designing the supporting dataset, configuring synonyms, and testing answers against real questions customers have asked. You will be in front of customers regularly — not constantly, but enough that you should enjoy that side of the work. The team partners closely with Data Engineers and Systems Development Engineers, so you will rarely be the only person on a problem. About the team CIAT gathers, transforms, and analyzes data for inventory, change-of-state, system health, safety, security, workload, and resource efficiency across AWS's global data center fleet. Our customers are the operations leaders who run rack install, decommission, repair, logistics, capacity optimization, and network operations. We are investing heavily in self-service and GenAI-powered analytics to expand the reach of the team beyond what any one BIE can deliver alone. BASIC 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 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 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 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, WA, Seattle - 99,500.00 - 160,000.00 USD annually
