Business Intelligence Engineer II, ORBIT - Capacity Planning BI

About the role

Are you passionate about turning complex data into clear, actionable insights that drive business decisions? Amazon is looking for a Business Intelligence Engineer II to design and build scalable analytics solutions that empower teams to make smarter, faster decisions.

In this role, you will own mid-to-large BI solutions, creating robust data models, performant pipelines, and intuitive visualizations that directly influence how the business operates. You will collaborate with cross-functional partners-including data engineers, scientists, and business stakeholders-to translate ambiguous problems into well-structured deliverables.

If you thrive on solving challenging data problems and want your work to have measurable impact at scale, we would love to hear from you.

Key job responsibilities

• Design and build scalable data models, ETL pipelines, and curated datasets that form the foundation of your team's analytics infrastructure, ensuring data quality, performance, and maintainability.
• Develop dashboards, reports, and self-service analytics tools using industry visualization platforms, enabling stakeholders to access timely insights and make informed decisions.
• Partner with business stakeholders, data engineers, and data scientists to refine requirements, recommend analytical approaches, and deliver BI solutions that address both current needs and anticipated future requests.
• Apply SQL expertise and basic statistical methods to conduct deep-dive analyses, identify root causes, and surface trends that inform strategic and operational priorities.
• Evaluate opportunities to integrate generative AI tools into analytics workflows, refining outputs for accuracy and applying responsible practices to augment productivity and solution quality.

A day in the life

You might start your morning reviewing pipeline health and data freshness before diving into a design session for a new data model that supports an upcoming business initiative. After lunch, you could pair with a data scientist to validate metric definitions or troubleshoot a data lineage question from a partner team. Later, you might refine a dashboard prototype based on stakeholder feedback, write documentation for a recently shipped dataset, or mentor a teammate on query optimization techniques.

Basic Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• 1+ years of SQL, ETL or Oracle experience
• 1+ years of processing large, multi-dimensional datasets from multiple sources experience
• 1+ years of performing statistical analysis experience
• 1+ years of developing automated reporting experience
• 3+ years of in the job offered or a related occupation experience
• 1+ years of using SQL, ETL (Extract, Transform, Load), or Oracle experience
• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience in Statistical Analysis packages such as R, SAS and Matlab
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

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

Additional information

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If the country/region you're applying in isn't listed, please contact your Recruiting Partner.

Pay and benefits

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.

USA, TX, Austin - 99,500.00 - 160,000.00 USD annually

USA, WA, Bellevue - 99,500.00 - 160,000.00 USD annually