Business Intelligence Engineer, North America Transportation Services
ExternalPrepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
About the role
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.
Requirements
- 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
- Master's degree in an advanced technical degree field
- 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)
- Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.
Additional Information
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. Key job 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. 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.
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at Amazon.com Services LLC? Share your experience