BI Architect: AI-Driven Network & Capacity Forecasting

Amazon Inc.; Seattle (WA); On-site; USD 110,000 - 160,000; Full time

Job summary

Amazon Inc. in Seattle is seeking a Business Intelligence Specialist within the NS&I team of AMZL PSX to design, build, and maintain data intelligence solutions for the Brazil Last Mile network.

You will lead data pipelines, predictive models, and self-service tools to optimize capacity, inbound flow, and operational efficiency. You will partner with Operations, Capacity Planning, Finance, Technology, and global network teams to translate complex data into actionable insights and drive AI-driven

Qualifications

• Bachelor's degree in a related field.
• Strong SQL skills in large-scale datasets.
• Experience building data pipelines or ETL processes.
• Experience with BI tools such as QuickSight, Tableau or Power BI.
• Experience with data scripting languages (SQL, Python, R) or statistical software.
• Strong analytical skills, attention to detail, and effective communication.
• Experience in Portuguese & English communication.

Responsibilities

• Design, build, and maintain automated data pipelines and ETL processes for capacity planning and reporting across the AMZL Brazil network.
• Develop and maintain SQL-based queries, views, and stored procedures for large-scale datasets.
• Build dashboards and reporting mechanisms providing real-time visibility into volume, capacity, cost, and performance.
• Create automated monitoring to identify capacity constraints and anomalies.
• Develop self-service analytical tools for Operations, Capacity, and leadership teams.
• Deliver AI-driven automations for recurring reports and manual processes.
• Conduct capacity trend analyses and scenario modeling to support data-driven decisions.
• Build predictive models to forecast volume and capacity needs.
• Develop alerting and exception-handling mechanisms for potential issues.
• Collaborate with Technology and global teams to ensure data quality and integrity.
• Support network design decisions with historical analysis and impact projections.
• Document data solutions with detailed specifications and runbooks.
• Present findings and automation proposals to stakeholders.

Skills

SQL

Python

ETL pipelines

BI dashboards

Tableau/Power BI/QuickSight

Data modeling

Education

Bachelor's degree in Computer Science

Master's degree in Math/Stats/CS or related

Tools

AWS Redshift

Tableau

Power BI

QuickSight

SQL

Python

Job description

Amazon Inc. in Seattle is seeking a Business Intelligence Specialist within the NS&I team of AMZL PSX to design, build, and maintain data intelligence solutions for the Brazil Last Mile network.

You will lead data pipelines, predictive models, and self-service tools to optimize capacity, inbound flow, and operational efficiency. You will partner with Operations, Capacity Planning, Finance, Technology, and global network teams to translate complex data into actionable insights and drive AI-driven