Business Intelligence Engineer, NA Supply Chain Execution- Production Planning Team

Amazon; Factoria (WA); On-site; USD 82,000 - 144,000; Full time

Benefits offered by this job

Health insurance

RSUs

401(k) matching

Paid time off

Job summary

Amazon seeks a Business Intelligence Engineer for its NA Supply Chain Production Planning team. You will own the analytics backbone powering headcount and capacity decisions across a wide network, building pipelines and dashboards that planners rely on weekly.

Responsibilities include designing data pipelines with Python/SQL/AWS services, maintaining a centralized data lake, and delivering actionable insights.

Qualifications

• 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL experience.
• Knowledge of BI analytics, reporting or visualization tools (Tableau, AWS QuickSight, Cognos, or similar).
• Experience gathering business requirements and using BI tools to extract data, metrics and reports.
• Knowledge of improving code quality and optimizing BI processes (speed, cost, reliability).
• Knowledge of data modeling and data pipeline design.

Responsibilities

• Own dashboards and automated reports surfacing production planning metrics for NASC network stakeholders.
• Collaborate with NASC Operations, Workforce Staffing, Network Design and Planning, and Regional Planning to translate questions into analytics.
• Design, build, and deploy data pipelines using Python, SQL, AWS Lambda, Athena, and Redshift; monitor health.
• Build and maintain curated datasets serving as the single source of truth for capacity planning.
• Identify automation opportunities to reduce manual data processing and enable self-service.
• Maintain documentation of data sources, business logic, and dataset schemas.

Skills

Redshift/Oracle/NoSQL

BI tools (Tableau/QuickSight/Cognos)

Requirements gathering

Data modeling

Data pipelines

Education

Master's degree or higher in statistics/data analytics/computer science

Tools

Python

SQL

AWS Lambda

Amazon Athena

Amazon Redshift

Job description

Business Intelligence Engineer, NA Supply Chain Execution- Production Planning Team

Job ID: 10499850 | Amazon.com Services LLC

Amazon's North America Supply Chain moves millions of packages every day through a network of over 300 fulfillment and sort centers. The Production Planning team is responsible for deciding how many people we need, where we need them, and when — across every site, every shift, every week. Getting this right means customers get packages on time. Getting it wrong means millions in wasted labor or missed delivery promises.

We are looking for a Business Intelligence Engineer who will build the analytics backbone that powers these planning decisions. You will not just write queries and build dashboards. You will own the data infrastructure that hundreds of planners and operators rely on every single week to make headcount and capacity decisions across the network. Your work will directly influence how Amazon allocates tens of thousands of labor hours and millions of dollars in workforce spend.

This is a high ownership role. You will take ambiguous business questions, figure out where the data lives, build the pipeline to transform it, deliver it in a format stakeholders can act on, and then measure whether it actually drove better decisions. You will operate at the intersection of data engineering, business intelligence, and operational planning at a scale few companies can offer.

Key job responsibilities

• Own the development and maintenance of dashboards and automated reports that surface critical production planning metrics to stakeholders across the NASC network.
• Collaborate with cross functional business teams including NASC Operations, Workforce Staffing, Network Design and Planning, and Regional Planning to translate workforce planning questions into analytical frameworks and deliver actionable insights that drive real decisions.
• Design, build, and deploy data pipelines using Python, SQL, AWS Lambda, Athena, and Redshift. Monitor pipeline health proactively. Ensure reliable and timely data delivery aligned to weekly planning cadences where a one day delay means planners are flying blind.
• Build and maintain curated datasets that serve as the single source of truth for capacity planning across the network. This includes a centralized data lake with well defined schemas, partition strategies, lineage documentation, and freshness SLAs that multiple downstream consumers depend on.
• Identify and implement automation opportunities that reduce manual data processing. Every hour a planner spends pulling data manually is an hour they are not spending on strategic planning decisions. Your job is to eliminate that waste through scalable self service solutions.
• Maintain clear documentation of data sources, business logic, transformation rules, and dataset schemas.

A day in the life

• As a Business Intelligence Engineer, you'll monitor pipeline health and resolve data quality issues to keep analytics reliable. You'll partner with operations leadership to scope new requests, translating business questions into analytical solutions.
• You'll design and refine data products: dashboards, models, and self-service tools while iterating quickly on stakeholder feedback.
• You'll collaborate cross-functionally to validate the datasets that power planning decisions, ensuring accuracy and trust.
• And you'll continuously improve your work by documenting transformation logic, automating manual processes, and proactively surfacing recommendations that help business leaders make confident, data‑driven decisions.

About the team

The PPT BI team is the analytics function within North America Supply Chain's production planning organization. We build data pipelines, automated reports, and self service dashboards that help planners and operations leaders make workforce and capacity decisions across a large network of fulfillment and sort centers. We are a small team with high ownership where you operate end to end — from requirements to production. You will partner with operations, staffing, network design, and regional planning teams on work that directly influences how labor is allocated across the network.

Basic Qualifications

• 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Knowledge of BI analytics, reporting or visualization tools like Tableau, AWS QuickSight, Cognos or other third‑party tools
• Experience gathering business requirements, using industry standard business intelligence tool(s) to extract data, formulate metrics and build reports
• Knowledge of how to improve code quality and optimizes BI processes (e.g. speed, cost, reliability)
• Knowledge of data modeling and data pipeline design

Preferred Qualifications

• Master's degree or above in statistics, business analytics, data analytics, data science, computer science or related field
• Experience in designing and implementing custom reporting systems using automation tools
• Experience with statistical analysis, co‑relation analysis
• Knowledge of OLAP technologies and BI analytics

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, AZ, Tempe - 82,300.00 - 144,000.00 USD annually

USA, WA, Bellevue - 82,300.00 - 144,000.00 USD annually

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.