Business Intelligence Engineer II, ORBIT - Capacity Planning BI

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.

About the team This role is within broader Amazon Logistics (AMZL) ORBIT (Operations Reporting, Business Intelligence, and Technology) team working under the WW Capacity Planning BIA team.

The WW Capacity Planning BI & Analytics team partners with the business and BI teams across AMZL Business to build analytical products and generate business insights that help these planning teams produce accurate and optimal capacity within the intra-week, short-term, and mid-term planning horizons. 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

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, TX, Austin - 99,500.00 - 160,000.00 USD annually USA, WA, Bellevue - 99,500.00 - 160,000.00 USD annually