Maersk India 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 flow of goods from origin to destination. Day to day, they analyse shipment data, track key performance indicators like on-time delivery and cost per container, and build reports or dashboards to support decisions. They work with operations, procurement, and customer teams to identify inefficiencies and recommend improvements.

Role and Technical Knowledge

1. 1

   What are the key performance indicators you would track for a container shipping line to measure supply chain efficiency?

   Mention metrics like on-time delivery, transit time, cost per TEU, vessel utilisation, and inventory turnover. Explain why each matters for a logistics company.

2. 2

   Explain the difference between inbound and outbound logistics, and give an example from the shipping industry.

   Inbound logistics brings goods into a company (e.g., empty containers to a port), while outbound logistics moves finished goods to customers (e.g., loaded containers to consignees). Use a port-to-door example.

3. 3

   How would you calculate inventory carrying cost, and why is it important in supply chain management?

   Cover components like storage, insurance, taxes, and opportunity cost. Explain that reducing carrying cost improves profitability without hurting service levels.

4. 4

   What is the bullwhip effect, and how can a logistics company help mitigate it for its customers?

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

Data and Analytical Skills

1. 5

   You have a dataset of 10,000 shipments with columns for origin, destination, transit time, and cost. How would you identify the most inefficient routes?

   Outline steps: clean data, calculate average transit time and cost per route, compare against benchmarks, and flag outliers. Mention using pivot tables or SQL queries.

2. 6

   Write a SQL query to find the top 5 destinations with the highest average shipping cost per kilogram.

   Show a query with GROUP BY destination, AVG(cost/weight), ORDER BY DESC, and LIMIT 5. Explain each clause briefly.

3. 7

   How would you use Excel to create a dashboard for monitoring daily shipment delays?

   Describe using pivot tables, charts, conditional formatting, and slicers. Mention linking to a data source and updating regularly.

4. 8

   What is the difference between correlation and causation in supply chain analytics? Give an example.

   Explain that correlation shows a relationship but not cause. Example: higher fuel prices correlate with higher shipping costs, but fuel price may not be the only cause.

Practical Scenarios

1. 9

   A key customer complains that their shipments are consistently delayed by 2-3 days. How would you investigate and resolve this?

   Start by pulling data to confirm the delay, identify the stage (e.g., port congestion, customs, last-mile), then collaborate with operations to find root cause and propose fixes like alternative routing or buffer time.

2. 10

   You notice that a particular warehouse has high inventory levels but frequent stockouts. What could be the reasons, and what would you do?

   Possible reasons: poor demand forecasting, inaccurate inventory records, or misaligned reorder points. Suggest improving forecast accuracy, cycle counting, and adjusting safety stock.

3. 11

   If you had to reduce transportation costs by 10% without affecting delivery times, what levers would you pull?

   Consider consolidating shipments, negotiating better rates, optimising routes, switching modes where feasible, and improving load utilisation. Emphasise data analysis to prioritise actions.

4. 12

   A supplier fails to deliver raw materials on time, impacting production. How would you handle this as a supply chain analyst?

   Assess impact, communicate with stakeholders, find alternative suppliers or expedite shipments, and analyse root cause to prevent recurrence. Mention using a risk management framework.

Behavioural and HR Questions

1. 13

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

   Use the STAR method. Focus on a project or internship where you analysed data, drew insights, and made a recommendation that led to a measurable improvement.

2. 14

   Why do you want to work in supply chain analytics, and why at a company like Maersk India?

   Show passion for solving logistics challenges with data. Mention Maersk's global reach, focus on digitalisation, and how you want to contribute to efficient trade.

3. 15

   Describe a situation where you had to work under pressure or with a tight deadline. How did you manage?

   Highlight prioritisation, time management, and communication. Give a concrete example from academics or an internship, and mention the result.

4. 16

   How do you handle conflicting priorities from different stakeholders, such as a customer wanting faster delivery and operations wanting lower costs?

   Explain that you would gather data on trade-offs, facilitate a discussion to align on goals, and propose a balanced solution. Emphasise communication and compromise.