Sr. Business Intelligence Engineer, Long Term Planning

The Supply Chain, Transportation Planning & Operational Excellence (EU STEP) is a team responsible for the end-to-end flow of goods from our vendors and sellers to Amazon customers all over Europe, in order to ensure a speedy and reliable customer delivery in the cheapest way possible. The STEP organization is all about network design and tactical execution as well as cost and performance management of the full network, including long-term strategic planning and transportation contracts on a global platform.

As a Business Intelligence Engineer, you will enable the creation of products that drive ever-greater automation, scale-ability and optimization of every aspect of transportation, lowering cost and delivering speed of execution for our customers. You will also identify opportunities and implement changes to improve network’s performance, simplify processes, and leverage existing resources. As part of your responsibilities, you will help the design and implementation of state-of-the-art solution in transportation planning and network design, ensuring that end to end transportation strategies are streamlined and optimized. The impact of your work will be in the Amazon EU global network.

Key job responsibilities
• Design and develop tools to automate standardized processes and optimize trade-offs across the full decision space.
• Develop relationships with internal and external partner teams to enrich our collection of data.
• Take the lead on the design, implementation, and delivery of large-scale data solutions that have a long-term impact on our mid- and long-term strategic planning.
• Analyze historical data to identify trends and support decision making.
• Identify and tackle intrinsically hard problems. Deliver artifacts that set the standard in your organization for business intelligence excellence, from designs to data models to implementations.
• Improve upon existing methodologies by developing new data sources or architecture enhancements.
• Lead and actively participate in design reviews, aligning teams across your organization towards coherent architectural strategies.
• Conduct written and verbal presentations to share insights and recommendations to audiences of varying levels of technical sophistication.
• Collaborate with multiple teams and have cross-team impact.
• Research and benchmark our technology against other competing software in the industry.
• Actively mentor and educate the larger BIE community on trends, technologies, and best practices.

Basic Qualifications

- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Experience in analyzing and interpreting data with Redshift, Oracle, NoSQL etc.
- Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
- Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
- Experience with data modeling, warehousing and building ETL pipelines
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience writing complex SQL queries

Preferred Qualifications

- Experience with forecasting and statistical analysis
- Experience working as a BIE in a technology company
- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
- Experience with big data technologies such as: Hadoop, Hive, Spark, EMR
- Experience operating large data warehouses
- Bachelor's/ Master's degree in computer science, engineering, analytics, mathematics, statistics, IT or equivalent

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. Protecting your privacy and the security of your data is a longstanding top priority for Amazon. Please consult our Privacy Notice (https://www.amazon.jobs/en/privacy_page) to know more about how we collect, use and transfer the personal data of our candidates.

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.