Business Intelligence Engineer II, ORBIT - Capacity Planning BI

Amazon.com

Jackson (TN)

On-site

USD 100,000 - 160,000

Full time

27 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health insurance
401(k) matching
Paid time off
Parental leave
RSUs

Job summary

Amazon seeks a Business Intelligence Engineer II for ORBIT - Capacity Planning BI. You will design scalable analytics solutions, build robust data models, and create dashboards that empower teams to make data-driven decisions.

Collaborate with data engineers, scientists, and stakeholders to translate problems into structured deliverables and influence planning and operations. You will apply SQL, ETL, and statistical methods to extract insights, and you may explore integrating generative AI tools

Qualifications

  • 3+ years analyzing and interpreting data with Redshift, Oracle, NoSQL etc.
  • 1+ years of SQL, ETL or Oracle experience
  • 1+ years processing large, multi-dimensional datasets from multiple sources
  • 1+ years performing statistical analysis
  • 1+ years developing automated reporting
  • 3+ years in the job offered or related occupation
  • 1+ years using SQL, ETL, or Oracle
  • Bachelor's degree or foreign equivalent in CS/Engineering/Math/Stats/Economics
  • 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 and scripting in Python for modeling

Responsibilities

  • Design and build scalable data models and ETL pipelines.
  • Develop dashboards and self-service analytics tools.
  • Partner with stakeholders to refine requirements and deliver BI solutions.
  • Apply SQL and basic statistics to conduct analyses and surface trends.
  • Evaluate opportunities to integrate AI tools into analytics workflows.

Skills

SQL
ETL
Data modeling
Data visualization
Python
Statistical analysis
Big data
AWS
Tableau
Quicksight

Education

Bachelor's degree in CS/Engineering/Math/Stats/Economics

Tools

Redshift
Oracle
Tableau
Quicksight
Python

Job description

Business Intelligence Engineer II, ORBIT - Capacity Planning BI

Job ID: 10600261 | Amazon.com Services LLC

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Engineer II, ORBIT - Capacity Planning BI
Business Intelligence Engineer II, ORBIT - Capacity Planning BI

Amazon Inc. • Bellevue (WA)

On-site
USD 100,000 - 160,000
Business Intelligence Engineer III, ORBIT - Capacity Planning BI
Business Intelligence Engineer III, ORBIT - Capacity Planning BI

Amazon.com • Austin (TX)

On-site
USD 130,000 - 176,000
Business Intelligence Engineer, Data Center Capacity Delivery Tooling
Business Intelligence Engineer, Data Center Capacity Delivery Tooling

Amazon Web Services (AWS) • Seattle (WA)

On-site
USD 100,000 - 160,000
Health insurance
401(k) matching
Paid time off
+1
Business Intelligence Engineer, Data Center Capacity Delivery Tooling
Business Intelligence Engineer, Data Center Capacity Delivery Tooling

Amazon Inc. • Omaha (NE)

On-site
USD 100,000 - 160,000
Sign-on payments
RSUs (restricted stock units)
Health insurance
+3
Senior Business Intelligence Engineer, ShipTech Analytics
Senior Business Intelligence Engineer, ShipTech Analytics

Amazon Inc. • Bellevue (WA)

On-site
USD 130,000 - 176,000
Business Intelligence Engineer II, R2L Analytics
Business Intelligence Engineer II, R2L Analytics

Amazon.com Inc. • Bellevue (WA)

On-site
USD 100,000 - 160,000
Medical, Dental, and Vision Coverage
Maternity and Parental Leave Options
Paid Time Off (PTO)
+1
Business Intelligence Engineer, Capacity Delivery Reliability
Business Intelligence Engineer, Capacity Delivery Reliability

Amazon Web Services (AWS) • Seattle (WA)

On-site
USD 120,000 - 180,000
Business Intelligence Engineer II, R2L Analytics
Business Intelligence Engineer II, R2L Analytics

Amazon Inc. • Bellevue (WA)

On-site
USD 100,000 - 160,000
Medical, Dental, and Vision
PTO
401(k) Plan
+1
Business Intelligence Engineer - AWS, AWS DC Construction
Business Intelligence Engineer - AWS, AWS DC Construction

Amazon Web Services (AWS) • Seattle (WA)

On-site
USD 100,000 - 160,000
Business Intelligence Engineer - AWS, AWS DC Construction
Business Intelligence Engineer - AWS, AWS DC Construction

Amazon Web Services (AWS) • Herndon (VA)

On-site
USD 100,000 - 160,000