Business Analyst II, Relay Product & Tech, Relay Product and Tech

Job summary

DESCRIPTION Amazon Relay is the technology backbone connecting carriers to Amazon's middle-mile freight network, moving millions of loads weekly across North America. The Carrier and Load Lifecycle team owns the analytics that power how carriers are acquired, onboarded, activated, assigned loads, execute shipments, and get paid.

Benefits

Qualifications

• 3+ years of tax, finance or a related analytical field experience
• 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization
• and using data and metrics to draw business insights
• Experience with Excel
• Experience with SQL
• Experience making business recommendations and influencing stakeholders
• PREFERRED
• 3+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization
• and location.
• Amazon also offers comprehensive

Responsibilities

• You will own carrier engagement metrics, load execution KPIs, and churn diagnostics end-to-end.
• You will write complex SQL against petabyte-scale datasets, design interactive dashboards in Tableau and QuickSight, and maintain production-grade reporting systems that leadership relies on daily.
• Own carrier lifecycle analytics across all stages.
• Build acquisition funnel metrics, onboarding conversion rates, activation timelines, engagement scoring, and churn prediction frameworks as new solutions.
• Develop load execution analytics covering acceptance rates, on-time performance, dwell time, disruption rates, and payment cycle health.
• Build interactive dashboards in QuickSight and Tableau that provide visibility into carrier and load health across lifecycle stages.
• Design calculated fields, parameters, filters, and drill-downs to enable independent exploration by stakeholders.
• Maintain existing dashboards and reporting systems (weekly, monthly, and quarterly business reviews, anomaly alerts), ensuring data accuracy, timely refresh, and alignment with evolving business definitions.
• Optimize SQL queries for performance and validate data quality across production pipelines.
• Partner with Product Managers to define success metrics for carrier-facing features.
• Translate product hypotheses into measurable experiments and provide data-driven recommendations on prioritization.
• Collaborate with Operations to diagnose root causes behind carrier drop-off and load failures.

Skills

Degrees

Industry

Company size