Locus Technologies 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 inventory, transportation, and warehouse operations. Day to day, they analyse demand forecasts, track key performance indicators like on-time delivery and cost per shipment, and build models to reduce costs and improve service levels. At fast-growing tech-enabled logistics firms, they often work with product and engineering teams to translate business problems into data-driven solutions.

Role and Technical Knowledge

1. 1

   What are the key differences between demand forecasting and demand planning?

   Explain that forecasting is statistical prediction, while planning includes adjusting for promotions, seasonality, and business rules. Mention collaboration with sales and marketing.

2. 2

   How would you calculate and interpret inventory turnover ratio?

   Define it as cost of goods sold divided by average inventory. Discuss what a high or low ratio indicates about efficiency and potential stockouts or overstock.

3. 3

   What is the bullwhip effect and how can it be mitigated in a supply chain?

   Describe how small demand fluctuations amplify upstream. Suggest solutions like information sharing, shorter lead times, and vendor-managed inventory.

4. 4

   Explain the concept of safety stock and how you determine the right level.

   Cover demand variability, lead time variability, and desired service level. Mention using formulas like z-score times standard deviation of demand during lead time.

Practical Scenarios and Data Analysis

1. 5

   A client's on-time delivery rate has dropped from 95% to 85% in the last quarter. How would you investigate and improve it?

   Break down by carrier, route, warehouse, and order type. Check for changes in lead times, carrier performance, or order volume. Propose corrective actions like carrier renegotiation or process changes.

2. 6

   You have a dataset of shipment costs, distances, and delivery times. How would you identify opportunities to reduce costs without hurting service levels?

   Mention segmenting by lane, using regression to find cost drivers, and simulating alternative routes or consolidation. Highlight trade-offs and pilot testing.

3. 7

   How would you use SQL to find the top 5 routes with the highest average delay?

   Describe writing a query with GROUP BY route, AVG(delay), ORDER BY average delay DESC, and LIMIT 5. Mention filtering by date range and joining tables if needed.

4. 8

   If you had to build a dashboard to monitor warehouse performance, what metrics would you include and why?

   List metrics like order accuracy, pick rate, dock-to-stock time, and inventory accuracy. Explain how each helps identify bottlenecks and improve efficiency.

Behavioural and Situational Questions

1. 9

   Tell me about a time you used data to solve a problem. What was the outcome?

   Use STAR format. Focus on the data analysis, the insight, and the measurable impact. Even academic projects count.

2. 10

   Describe a situation where you had to work under 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

   Give an example of a time you had to explain a complex idea to someone non-technical.

   Highlight simplifying without losing key points, using visuals, and checking for understanding. Relate to explaining supply chain metrics to stakeholders.

4. 12

   Tell me about a time you made a mistake in an analysis. How did you handle it?

   Emphasise ownership, quick correction, and learning. Show you communicated transparently and implemented checks to prevent recurrence.

HR and Company Fit

1. 13

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

   Connect personal interest in data and logistics, and mention the company's innovative approach. Show you understand their business model.

2. 14

   Where do you see yourself in three years?

   Align with growth in analytics and supply chain. Mention developing deeper expertise and taking on more complex projects.

3. 15

   How do you handle working in a fast-paced environment with changing priorities?

   Give an example of adapting quickly, staying organised, and communicating with team members. Show flexibility and a positive attitude.

4. 16

   What are your salary expectations?

   Research industry standards for freshers in India. Give a range and express flexibility, focusing on learning and growth opportunities.