Business Analyst II, Transportation Long Term Capacity Planning

Amazon; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Amazon is seeking a Last Mile Business Analyst II in Bengaluru to help strategically plan and optimize the Last Mile network over a 1-3 year horizon. You will develop forecasting models and capacity plans that balance delivery speed with cost, working across cross-functional teams to drive data-driven decisions.

You will design dashboards, analyze historical data, and present insights to senior leadership, helping ensure business continuity during peak periods.

Qualifications

• Bachelor's degree or equivalent.
• 3+ years of business/data analyst experience.

Responsibilities

• Develop and maintain long-term forecasting models for the Last Mile network over 1–3 years.
• Build and run analytical models to predict capacity requirements.
• Partner with cross-functional teams to gather data and insights for forecasting.
• Analyze historical data and market trends to refine forecasting methods.
• Present insights to senior leadership to support strategic decisions.
• Support POR planning with analytical inputs aligned to financial targets.
• Identify opportunities for network improvements and cost optimization.
• Design dashboards, reports, and automated tools to improve forecasting visibility.
• Develop capacity models for current and future demands to ensure business continuity.

Skills

SQL

Tableau

Forecasting

Capacity Planning

Stakeholder Mgmt

Excel

Education

Bachelor's degree

Tools

SQL

Excel

Tableau

QuickSight

Job description

Description Amazon.com strives to be Earth's most customer-centric company where people can find and discover virtually anything they want to buy online. By giving customers more of what they want - low prices, vast selection, and convenience - Amazon.com continues to grow and evolve as a world-class e-commerce platform. Amazon's evolution from Web site to e-commerce partner to development platform is driven by the spirit of innovation that is part of the company's DNA. The world's brightest technology minds come to Amazon.com to research and develop technology that improves the lives of shoppers and sellers around the world.

Description Amazon.com strives to be Earth's most customer-centric company where people can find and discover virtually anything they want to buy online. By giving customers more of what they want - low prices, vast selection, and convenience - Amazon.com continues to grow and evolve as a world-class e-commerce platform. Amazon's evolution from Web site to e-commerce partner to development platform is driven by the spirit of innovation that is part of the company's DNA. The world's brightest technology minds come to Amazon.com to research and develop technology that improves the lives of shoppers and sellers around the world.

We are looking for a good fit to join our Transportation Long Term Capacity Planning Team, part of the larger Supply Chain Team. This team plays a crucial role in strategically planning and executing Amazon's Last Mile Transportation network topology over a 1-3 year horizon. As a Last Mile Business Analyst II, you will be at the forefront of enabling cross-functional teams to evolve our delivery network, continuously analyzing and optimizing for cost, speed, and reliability while maintaining a strong customer focus.

In this role, you will be responsible for developing analytical frameworks and capacity models that address both current and future demands, ensuring business continuity even through peak periods. Your analysis will directly contribute to our long-term strategy programs, preparing Amazon's last mile delivery network for sustained growth while striking the delicate balance between delivery speed, operational efficiency, and cost-effectiveness.

You will leverage your expertise in data analysis, long-term forecasting, and capacity modeling to generate data-driven insights that shape the future of our Last Mile operations. This position requires strong analytical skills, a strategic mindset, and the ability to collaborate effectively with diverse teams across the organization. Your insights and recommendations will be instrumental in guiding senior leadership decisions and driving the continuous improvement of our vast delivery network.

As a key member of this team, you'll have the opportunity to make a significant impact on Amazon's ability to meet and exceed customer expectations in the years to come, playing a vital role in our mission to be Earth's most customer-centric company.

You are expected to have exceptional analytical, planning, and written/verbal communication skills. You know and love working with business intelligence tools, are comfortable accessing and working with big data from multiple sources, and are enthusiastic about partnering with the business to deliver results. You are a self-starter, comfortable with ambiguity, able to think big, and enjoy working in a fast-paced environment.

Join our team and help shape the future of Amazon's last mile delivery network, contributing to our mission of becoming Earth's most customer-centric company while balancing delivery speed with efficiency and cost-effectiveness!

Key job responsibilities

• Develop and maintain long-term forecasting models for the Last Mile network, focusing on Quarterly Guidance Numbers Validation
• Build and run complex analytical models to predict network capacity requirements 1-3 years in advance
• Partner with cross-functional teams to gather data and insights for accurate long-term forecasting
• Analyze historical data, market trends, and business strategies to refine long-term forecasting methodologies
• Present data-driven insights and recommendations to senior leadership, supporting strategic decision-making
• Support the Plan of Record (POR) planning process through analytical inputs, ensuring alignment with company objectives and financial targets
• Identify opportunities for network improvements and cost optimizations through deep-dive analysis of long-term forecasting data
• Design and maintain dashboards, reports, and automated analytical tools to improve forecasting accuracy and visibility
• Develop capacity models for current and future demands, ensuring business continuity through peak periods
• Contribute analytical frameworks to long-term strategy programs that prepare Amazon's last mile delivery network for growth, balancing delivery speed with efficiency and cost-effectiveness

About The Team

The Long Term Middle and Last Mile Capacity Planning Team strategically plans and executes Transportation network topology over a 1-3 year horizon. We unite teams to evolve the network, optimizing cost, speed, and reliability with customer focus. We develop capacity solutions for current and future demands, ensuring business continuity through peak periods. Our long-term strategy programs prepare Amazon's logistics for growth, balancing delivery speed with efficiency and cost-effectiveness.

Basic Qualifications

• Bachelor's degree or equivalent
• 3+ years of business analyst, data analyst or similar role experience

Preferred Qualifications

• 3+ years of experience working with data querying languages (e.g., SQL) and data visualization tools (e.g., QuickSight, Tableau, Excel)
• Experience with forecasting models and capacity planning methodologies
• Experience defining requirements and using data to back up assumptions and drive actions
• Experience making business recommendations and influencing stakeholders through data-driven insights

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.

Company - ASSPL - Karnataka

Job ID: A10578271