Business Intelligence Specialist, AMZL PSX

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

Business Intelligence Specialist, AMZL PSX

Amazon is the most customer-centric company on Earth. We need exceptionally talented, bright, and driven people who are passionate about doing the right thing.

We are looking for a Business Intelligence Analyst to join the Network Strategy & Innovation (NS&I) team within Amazon’s Last Mile Brazil organization, as part of the Partner Strategy & Experience (PSX) organization. This role owns the design, development, and maintenance of data intelligence solutions, automated mechanisms, and analytical frameworks that help shape the future of the AMZL Brazil network, covering capacity planning, inbound optimization, network design, and operational efficiency.

As an Individual Contributor, you will be a core part of the data and automation engine behind NS&I. You will build pipelines, dashboards, predictive models, and self-service tools that eliminate manual processes, anticipate network constraints, and provide real-time visibility into volume, capacity, cost, speed, and partner performance. You will also help identify and deliver AI-driven automations for operational processes, turning repetitive work into scalable mechanisms.

You will partner closely with Operations, Capacity Planning, Finance, Technology, and global network teams to turn complex data into actionable intelligence and support strategic decisions for the Brazil Last Mile network.

This role reports directly to the Network Strategy & Innovation Manager and works cross-functionally across the PSX organization and AMZL Brazil leadership.

This position is based out of an AMZL office.

If you are passionate about building intelligent data solutions, automating complex processes with AI, and using analytics to design a more efficient network, come join our team.

Key job responsibilities

• Design, build, and maintain automated data pipelines and ETL processes that support capacity planning, inbound optimization, network design, and operational reporting across the AMZL Brazil network
• Develop and maintain SQL-based queries, views, and stored procedures to extract, transform, and analyze large-scale operational, volume, and cost datasets
• Build and maintain dashboards and reporting mechanisms (QuickSight, Tableau, or equivalent) providing real-time visibility into volume, capacity utilization, cost, speed, inbound alignment, and partner performance
• Create automated monitoring mechanisms that identify capacity constraints, inbound mismatches, and network anomalies before they impact operations and customers, reducing manual intervention
• Develop self-service analytical tools that enable Operations, Capacity, and leadership teams to access insights without ad-hoc requests
• Identify, prioritize, and deliver AI-driven automations for recurring reports and manual operational processes, driving efficiency gains across the AMZL Brazil network
• Conduct deep-dive analyses on capacity trends, inbound patterns, network design scenarios, and operational productivity (e.g., TPH, DPPH) to support data-driven decision-making
• Build predictive models and forecasting mechanisms that anticipate volume, capacity needs, and network bottlenecks
• Build alerting and exception-handling mechanisms that proactively flag issues (e.g., capacity overload, inbound misalignment, productivity drops, unusual volume shifts)
• Partner with Technology, Engineering, and global network teams to define data requirements, validate data sources, and ensure data quality and integrity
• Support network design and expansion decisions by providing historical analysis, scenario modeling, and impact projections
• Document all data solutions, pipelines, and mechanisms with clear technical specifications and operational runbooks
• Present analytical findings and automation proposals to stakeholders and leadership, translating technical solutions into business value

About the team

The Business Intelligence Analyst sits within the Pricing & Payments team, part of Amazon Logistics' Partner Strategy & Experience (PSX) organization. The Pricing & Payments function owns one of PSX's core pillars: "Pricing accuracy, incentive effectiveness, and payment reliability: ensuring financial health and trust across all delivery channels."

The team manages pricing models, payment cycles, incentive structures, and dispute resolution for +30 logistics partners across Brazil. The BI Analyst is the technical engine of this function — building the data infrastructure, automations, and intelligence that enable the team to operate at scale with precision and speed.

Basic Qualifications

• - Bachelor's degree in Computer Science, Information Science, Information Technology, Engineering, Mathematics, Physics, or a related field
• - Knowledge of writing and optimizing SQL queries in a business environment with large-scale, complex datasets
• - Experience building data pipelines or automated ETL processes
• - Experience with reporting and Data Visualization tools such as Quick Sight / Tableau / Power BI or other BI packages
• - Experience with data scripting languages (e.g., SQL, Python, R, or equivalent) or statistical/mathematical software (e.g., R, SAS, Matlab, or equivalent)
• - Experience translating customer needs into business requirements
• - Experience that includes strong analytical skills, attention to detail, and effective communication abilities, or experience in SQL Server/MySQL
• - Experience communicating technical concepts to non-technical audiences
• - Experience in communication and presentation skills, both written and verbal in Portuguese & English

Preferred Qualifications

• - Experience in Amazon Redshift and other AWS technologies
• - Experience with financial services, payments or e-commerce
• - Experience with creating automated alarms, reports and KPI metrics for plant management
• - Knowledge of finance, accounting, business or related field focused on analytics
• - Experience working with Git or an equivalent distributed version control system
• - Experience in program management, logistics, operations, supply chain, transportation, or equivalent
• - Experience automating routine tasks
• - Knowledge of data warehousing and data modeling
• - Master's degree in Math, Statistics, Computer Science, or related science field, or Master's degree or equivalent

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.

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status. Veterans, military spouses, and people with disabilities are encouraged to apply.