Business Intelligence Engineer

Who you are

• 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
• Experience in analyzing and interpreting data with Redshift, Oracle, NoSQL etc
• 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 Python scripting to process data for modeling
• Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
• Experience writing complex SQL queries
• 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 opportunities employer. We believe passionately that employing a diverse workforce is central to our success. We make recruiting decisions based on your experience and skills. We value your passion to discover, invent, simplify and build

What the job involves

• 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
• 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
• 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