Description

Are you interested in a high-impact role with exposure to senior leaders? The EU Network Flow and Technologies (NFT) team is seeking a Business Intelligence Engineer II with strong analytical and technical skills to independently own end-to-end BI deliverables that drive performance measurement, innovation, and execution in network operations and fulfillment center flow management.

Operating with minimal guidance, you will refine ambiguous business requirements into actionable specifications and drive loosely structured problems to resolution. You will own analytical datasets, data pipelines, and reporting assets used by NFT, Process Engineering, and EU Central Flow teams, partnering with Amazon Fulfillment Center Operations, Transportation Services, and data teams to optimize end-to-end network flows.

Key job responsibilities
As a Business Intelligence Engineer II, your responsibilities include:

Owning end-to-end BI solutions of moderate to high complexity, typically spanning multiple data sources, cross-functional stakeholders, and measurable impact on network performance, cost, or customer experience.
Translating ambiguous business questions into well-scoped analytical deliverables, recommending alternatives, and anticipating follow-on needs across NFT, PE, and EU Central Flow.
Designing and building testable, maintainable, performant ETL pipelines, dimensional datasets, and reporting layers in Redshift, applying CI/CD practices and the right level of complexity to minimize technical debt.
Making deliberate trade-offs across performance, scalability, cost, and dependencies, and applying basic statistical methods (with a clear understanding of their limitations) to support intraweek capacity management, risk mitigation, and automation across EU fulfillment centers.
Producing design and usage documentation (architecture diagrams, runbooks, wikis) to support long-term ownership of the artifacts you build.
Contributing to team design discussions, scoping, and prioritization; supporting onboarding and knowledge sharing; and providing informal mentorship to BIE I and junior team members.
Ideal candidate: Strong in complex SQL and query optimization, dimensional modeling on Redshift, ETL and pipeline development, and dashboarding in QuickSight or Tableau. Hands-on with AWS data services (S3, Glue, Lambda, Step Functions, CloudWatch, QuickSight). Python proficiency required; JavaScript preferred. Excels in translating customer needs into BI solutions, and in mentoring others as the team scales.

A day in the life
You'll start by reviewing network flow metrics across EU fulfillment centers, identifying capacity risks needing immediate attention. Throughout the day, you'll partner with operations teams to translate pain points into technical solutions, building ETL pipelines, refining dashboards, and automating manual processes.

Expect to move between SQL/Python coding sessions, stakeholder meetings, and data quality troubleshooting. You might present findings to operations managers one hour, then collaborate with data engineers on pipeline optimization the next. During peak periods, you'll respond to urgent requests while balancing long-term scalable solutions.

Beyond core responsibilities, you'll influence the NFT tech roadmap, propose automation initiatives, and shape how the European network uses data for capacity decisions.

About the team
The EU Network Flow and Technologies (NFT) team optimizes end-to-end network operations across European fulfillment centers, partnering with operations to balance cost, service, and speed. We manage intraweek capacity, performance, and labor across all volume flows, driving tech solutions and automation as trusted partners to local teams.

Our focus spans network flow management through real-time signals, BI analytics and dashboards for FC operations, risk management tools to identify performance and capacity defects, and continuous automation innovation. We embrace data-driven evolution, refusing the status quo to deliver network execution excellence through iterative improvements and scalable solutions.