Business Intelligence Engineer, North America Transportation Services

Are you excited about how information insights can bring value to our transportation team. We are looking for a self-driven, insightful, results-oriented Business Intelligence Engineer to join the North America Transportation team. Our team mission is to drive improvements to customer experience, performance, and cost across Amazon’s transportation systems, from initial delivery promise to final delivery to our customers.

This is a tremendous opportunity for Business Intelligence Engineers who want to develop new and innovative ways of interacting with and interpreting business key performance indicators, and shape the future of Amazon Transportation systems., * Build and maintain reports, dashboards, and data sets using SQL, AWS Redshift/S3, and visualization tools such as QuickSight or Tableau, with guidance from senior BI engineers.

• Support the creation and monitoring of transportation metrics related to delivery cost and customer experience, escalating anomalies and findings to senior team members.
• Perform data gathering, analysis, and validation to answer specific business questions from program owners, following established analytical approaches.
• Conduct ad hoc analyses to investigate transportation issues, documenting findings and presenting recommendations to your immediate team and manager.
• Contribute to automating manual reporting processes by writing scripts in Python or R under the direction of senior engineers.
• Collaborate with data engineers and other BI engineers to learn data architecture best practices and support data pipeline improvements.

A day in the life

As a Business Intelligence Engineer on the North America Transportation Planning and Forecasting team, you’ll start your day reviewing existing dashboards and checking for data quality issues. You’ll work with your manager and senior BI engineers to prioritize analytical requests from program owners. Your day may include writing SQL queries to pull data for a specific business question, updating a dashboard to reflect new metrics, or investigating a data anomaly flagged by a stakeholder. You’ll participate in team meetings where you’ll share your findings and learn from more experienced team members. You’ll have opportunities to develop your skills across the AWS data ecosystem and grow your understanding of Amazon’s supply chain.

About the team

We are the central planning and forecasting team for North America Transportation. We integrate end-to-end customer fulfillment analytics across both the short term (13 weeks) and long term (3-5 years) horizon. You’ll work alongside operations specialists, data scientists, and senior BI engineers who are committed to using data to improve how we serve our customers.

• 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with one or more industry analytics visualization tools (e.g. Excel, Tableau, QuickSight, MicroStrategy, PowerBI) and statistical methods (e.g. t-test, Chi-squared)
• Experience with scripting language (e.g., Python, Java, or R), * Master’s degree, or Advanced technical degree
• Knowledge of data modeling and data pipeline design
• Experience with statistical analysis, co-relation analysis
• Advanced technical degree, or Master’s degree
• Experience with AWS data warehouse and reporting technologies like Redshift, Athena, S3, etc.
• Experience with statistical methods (e.g., A/B Testing, Regression)
• Knowledge of data warehousing and data modeling
• Experience working with large, complex data sets
• Knowledge of AWS tech stack (e.g., AWS Redshift, S3, EC2, Glue)

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits .

USA, WA, Bellevue - 82,300.00 - 144,000.00 USD annually