Business Intelligence Engineer, North America Transportation Services

Amazon Inc.; Irving (TX); On-site; USD 82,000 - 144,000; Full time

Job summary

Amazon is seeking a proactive Business Intelligence Engineer in North America Transportation Services to help improve delivery cost, customer experience, and performance across our transportation systems.

You will build dashboards using SQL, Redshift/S3, and visualization tools such as Tableau or QuickSight, collaborate with data engineers, and automate reporting with Python or R in a fast-paced, collaborative environment.

Qualifications

• 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL, etc.
• Experience with data visualization using Tableau, QuickSight, or similar tools
• Experience with 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)

Responsibilities

• Build and maintain reports, dashboards, and data sets using SQL, AWS Redshift/S3, and visualization tools
• Support the creation and monitoring of transportation metrics related to delivery cost and customer experience
• Perform data gathering, analysis, and validation to answer business questions from program owners
• Conduct ad hoc analyses to investigate transportation issues and present recommendations
• Contribute to automating manual reporting processes by writing scripts in Python or R
• Collaborate with data engineers and BI engineers to learn data architecture best practices

Skills

SQL & querying

Redshift data handling

Data visualization

Scripting (Python/R)

Education

Master's degree or advanced technical degree

Tools

Tableau

QuickSight

Excel

PowerBI

Job description

Business Intelligence Engineer, North America Transportation Services

Job ID: 10563750 | Amazon.com Services LLC

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.

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.

Basic Qualifications

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

Preferred Qualifications

• Master's degree, or Advanced technical degree
• Knowledge of data modeling and data pipeline design
• Experience with statistical analysis, co-relation analysis

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

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.

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.

Preferred Qualifications

• Master's degree, or Advanced technical degree
• Knowledge of data modeling and data pipeline design
• Experience with statistical analysis, co-relation analysis

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

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.

USA, TX, Irving - 82,300.00 - 144,000.00 USD annually

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status. Veterans, military spouses, and people with disabilities are encouraged to apply.