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.
- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- 1+ years of SQL, ETL or Oracle experience
- 1+ year