GreenCell Mobility Supply Chain Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Supply Chain Analyst in logistics and supply chain tracks inventory, shipments, and demand data to keep goods moving efficiently and cost-effectively. Day to day, they pull data from transport management systems, build reports and dashboards, spot delays or stockouts, and suggest fixes to planners and operations teams. In a fast-growing company, they often work on route optimisation, vendor performance, and cost-per-kilometre or cost-per-delivery analysis.

Role and technical knowledge

1. 1

   What does a Supply Chain Analyst do in a logistics company, and how is that different from a pure operations role?

   Explain that the analyst works on data, reporting, and analysis to improve decisions, while operations executes the daily movement of goods. Mention that the analyst supports operations with insights on cost, speed, and reliability.

2. 2

   Which supply chain metrics would you track for a company that moves electric buses or fleet vehicles?

   Name metrics like vehicle utilisation, on-time departure and arrival, cost per kilometre, charging or fuel downtime, spare parts availability, and maintenance turnaround time. Show that you can link metrics to business goals.

3. 3

   Explain the difference between OTIF, fill rate, and inventory turnover.

   Define each simply: OTIF is on-time in-full delivery performance, fill rate is the share of customer demand met from available stock, and inventory turnover is how many times stock is sold or used in a period. Give a one-line example for each.

4. 4

   How would you use Excel or SQL to find which routes or vendors are causing the most delays?

   Describe pulling shipment data, grouping by route or vendor, calculating average delay and delay frequency, and ranking the worst performers. Mention cleaning the data first and validating with a small sample.

Practical scenarios and case questions

1. 5

   A key supplier of spare parts is delayed by two weeks. How would you handle it as a Supply Chain Analyst?

   Cover checking current stock and criticality, finding alternate suppliers or expedited freight, informing internal teams, and tracking the impact on maintenance or service schedules. End with a preventive recommendation like safety stock or dual sourcing.

2. 6

   You notice that delivery costs have risen 15 percent in one month. How would you investigate?

   Break cost into fuel, driver hours, route distance, tolls, and empty running. Compare route-level and vendor-level data, check for rate changes or detours, and isolate the biggest driver before suggesting a fix.

3. 7

   How would you decide the right safety stock level for a fast-moving spare part?

   Talk about demand variability, lead time variability, service level target, and holding cost. Mention a simple formula or a practical buffer based on past stockouts and criticality of the part.

4. 8

   Your manager asks you to reduce cost per delivery without hurting service levels. What is your approach?

   Start with data on cost drivers, then suggest route consolidation, better load planning, vendor negotiation, or reducing failed deliveries. Emphasise measuring service level before and after any change.

Tools, data, and problem solving

1. 9

   Walk me through how you would build a simple dashboard to track daily dispatch performance.

   Mention the data source, key columns like date, route, vehicle, planned vs actual dispatch time, and the chart types. Explain who will use it and how often it will refresh.

2. 10

   How comfortable are you with SQL? Give an example of a query you would write to find the top 5 delayed shipments.

   Be honest about your level. Describe selecting shipment ID, delay days, and route, filtering for delay greater than zero, sorting descending, and limiting to five. Mention joining tables if needed.

3. 11

   You find an error in a report you shared with the operations head. What do you do?

   Say you would verify the error, correct it quickly, inform the stakeholder with a clear note on what changed and why, and add a check to prevent it next time. Show ownership, not blame.

4. 12

   How would you handle missing or messy data in a shipment log?

   Describe checking for blanks, duplicates, and inconsistent formats, using a rule to fill or flag missing values, and documenting assumptions. Mention that you would confirm with the source team if the gap is large.

Behavioural and HR questions

1. 13

   Tell me about a time you used data to solve a problem in a college project or internship.

   Use the STAR method: situation, task, action, result. Pick a project where you cleaned data, found a pattern, and made a recommendation. Quantify the result if possible.

2. 14

   Why do you want to work in supply chain and logistics, and why a fast-growing company?

   Link your interest to real-world impact, problem solving, and the chance to build processes in a growing setup. Mention specific parts of the role like analytics, planning, or cost improvement.

3. 15

   This role may need you to work from a warehouse or plant location and coordinate across shifts. How do you feel about that?

   Show flexibility and willingness to learn from the ground. Mention that seeing operations firsthand helps you ask better questions and build more useful reports.

4. 16

   Where do you see yourself in three years in this role?

   Talk about growing into a planning or analytics lead role, deepening your knowledge of logistics and supply chain tools, and taking on more ownership of projects. Keep it realistic and tied to the company's growth.