Business Analyst, Middle Mile Capacity Planning

Amazon; India; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Amazon in India is seeking a Business Analyst for Middle Mile Capacity Planning to help shape the long-term logistics network. You will unite cross-functional teams to evolve the network, optimize cost, speed, and reliability, and support capacity solutions for current and future demands.

The role requires strong analytical, planning, and communication skills, with hands-on experience in SQL, Python, and MS Excel.

Qualifications

• 3+ years of analyst, associate program manager, or similar experience.
• Knowledge of SQL/Python/R, scripting, MS Excel, table joins, and aggregate analytical functions.
• Ability to influence without authority using data and facts.

Responsibilities

• Support long-term forecasting efforts for the Middle Mile network, focusing on Quarterly Guidance Numbers Validation.
• Support forecasting models to predict capacity requirements 1-3 years in advance.
• Collaborate with cross-functional teams to gather data and insights for long-term forecasting.
• Analyze historical data, market trends, and business strategies to refine forecasting methods.
• Oversee the Plan of Record (POR) planning process, aligning with objectives and financial targets.
• Contribute to long-term strategy programs balancing speed, efficiency and cost.

Skills

Analytical skills

SQL queries

Python

MS Excel

Data analysis

Tools

SQL

Python

R

MS Excel

Table joins

Job description

Business Analyst, Middle Mile Capacity Planning

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 Transportation network topology over a 1-3 year horizon. As a Business Analyst, you will be at the forefront of uniting cross-functional teams to evolve our network, continuously optimizing for cost, speed, and reliability while maintaining a strong customer focus.

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

You will leverage your expertise in supporting for long-term forecasting and capacity planning to make data-driven decisions that shape the future of our Middle Mile operations. This position requires a strategic mindset, strong analytical skills, 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 logistics network.

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, able to think big, and enjoy working in a fast-paced environment.

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

Key Skills Required:

• You should be very analytical and be able to justify your decisions and approaches with data
• Proficiency in handling large data sets, hands on experience must in running SQL queries and Quick Suite automation.
• You should be able to take a complex problem and break it down to smaller digestible chunks
• You should be able to define a logical and step by step approach to achieving a lofty goal
• You should be comfortable with processes and process design/analysis
• You should have the ability to influence without authority and do so by using data and facts
• You should be able to deal with varied stakeholders and earn their trust.

Key job responsibilities

• Support long-term forecasting efforts for the Middle Mile network, focusing on Quarterly Guidance Numbers Validation
• Support in running the forecasting models to predict network capacity requirements 1-3 years in advance
• Collaborate 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
• Oversee the Plan of Record (POR) planning process, ensuring alignment with company objectives and financial targets
• Contribute to long-term strategy programs that prepare Amazon's logistics 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.

- 3+ years of analyst, associate program manager, or similar roles experience

- Knowledge of SQL/Python/R, scripting, MS Excel, table joins, and aggregate analytical functions

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.