LogiNext Solutions Supply Chain Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Supply Chain Analyst in logistics and supply chain uses data to optimise the movement and storage of goods, from demand forecasting to last-mile delivery. Day to day, they analyse shipment data, track key performance indicators like on-time delivery and cost per kilometre, and build reports or dashboards to help operations teams reduce costs and improve service levels. At fast-growing companies like LogiNext Solutions, they often work with large datasets, use SQL or Python, and collaborate with product and operations teams to solve real-world logistics problems.

Role and Technical Knowledge

1. 1

   What are the key differences between inbound and outbound logistics?

   Explain that inbound covers raw materials from suppliers to production, while outbound covers finished goods from production to customers. Mention cost and service level differences.

2. 2

   How would you calculate inventory turnover ratio and what does it indicate?

   State the formula (Cost of Goods Sold divided by Average Inventory) and explain that a higher ratio means faster stock movement, but too high can lead to stockouts.

3. 3

   What is the bullwhip effect and how can it be reduced?

   Describe how demand variability amplifies upstream in the supply chain. Suggest solutions like information sharing, shorter lead times, and vendor-managed inventory.

4. 4

   Explain the concept of last-mile delivery and why it is expensive.

   Last-mile is the final leg to the customer. It is costly due to low drop density, traffic, and failed deliveries. Mention route optimisation and locker solutions.

Practical Scenarios and Data Analysis

1. 5

   You have a dataset of shipments with delivery dates. How would you find the on-time delivery rate?

   Write a SQL query using COUNT and CASE WHEN to compare actual delivery date with promised date. Explain how to handle nulls and time zones.

2. 6

   A client complains that their logistics costs have increased by 15 percent in the last quarter. How would you investigate?

   Break down costs by fuel, labour, distance, and returns. Compare with volume changes. Suggest checking for route inefficiencies or higher return rates.

3. 7

   How would you forecast demand for a new product with no historical data?

   Use analogous products, market research, or pilot launches. Mention qualitative methods like Delphi and quantitative methods like moving averages once data is available.

4. 8

   You need to optimise delivery routes for 50 vehicles. What factors would you consider?

   Consider vehicle capacity, time windows, traffic patterns, and driver hours. Mention using route optimisation software or algorithms like vehicle routing problem.

Behavioural and Situational Questions

1. 9

   Tell me about a time you worked in a team to solve a problem. What was your role?

   Use STAR format. Highlight your specific contribution, how you collaborated, and the measurable outcome.

2. 10

   Describe a situation where you had to meet a tight deadline. How did you manage?

   Show prioritisation, time management, and communication. Mention tools like to-do lists or project management software.

3. 11

   How would you handle a disagreement with a senior colleague about a data analysis method?

   Emphasise respectful communication, presenting evidence, and being open to feedback. Focus on the best outcome for the project.

4. 12

   Why do you want to work in supply chain analytics, especially at a fast-growing company?

   Connect your interest in data-driven decision-making with the dynamic nature of logistics. Mention eagerness to learn and impact.

HR and Company Fit

1. 13

   What do you know about our company and why do you want to join us?

   Research the company's products, clients, and recent news. Align your skills with their focus on technology and innovation in logistics.

2. 14

   Where do you see yourself in three years?

   Show ambition to grow into a senior analyst or specialist role, contributing to larger projects and possibly leading a small team.

3. 15

   Are you comfortable working with large datasets and learning new tools on the job?

   Give examples of self-learning, such as online courses or projects. Express enthusiasm for picking up new technologies quickly.

4. 16

   What are your salary expectations?

   Research typical fresher salaries for supply chain analysts in India. Give a range and express flexibility based on overall compensation and growth opportunities.