Business Intelligence Engineer, North America Transportation Services

Amazon • Irving, TX

23h • Onsite

About The Position

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

Requirements

• Bachelor's degree or above in computer science, engineering, mathematics or equivalent, or Bachelor's degree and 2+ years of a quantitative field such as statistics, mathematics, data science, business analytics, economics, finance, engineering, or computer science experience
• Experience with data analysis and SQL
• Experience with one or more analytics visualization tools (e.g., Excel, Tableau, QuickSight, MicroStrategy, PowerBI)
• Experience with scripting language (e.g., Python, Java, or R)

Nice To Haves

• Master's degree, or Advanced technical degree
• Experience with cloud-based data warehouses such as Amazon Redshift, Snowflake, or BigQuery
• Experience with statistical methods (e.g., t-test, regression analysis, A/B testing)
• Knowledge of data modeling concepts and data pipeline design
• Experience working with large data sets in a business or academic setting
• Familiarity with the AWS data ecosystem (S3, Redshift, Glue)

Responsibilities

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

Benefits

• sign-on payments
• restricted stock units (RSUs)
• 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
• parental leave

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level