Fashinza Supply Chain Supply Chain Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Supply Chain Analyst in logistics and supply chain uses data to improve how goods move from supplier to customer, focusing on demand forecasting, inventory planning, and cost reduction. In a fast-growing company like Fashinza Supply Chain, you would work with manufacturing partners, track orders, analyse supplier performance, and build dashboards that help teams make faster decisions. The role blends Excel, SQL, and business sense to solve everyday problems like stockouts, delays, and excess inventory.

Role and Technical Knowledge

1. 1

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

   Explain that forecasting predicts future demand using historical data and trends, while inventory planning decides how much stock to hold and when to reorder. Mention that forecasting feeds into inventory decisions.

2. 2

   How would you calculate and interpret OTIF (On Time In Full) for a supplier?

   Define OTIF as the percentage of orders delivered on time and in full quantity. Show how to calculate it (orders meeting both criteria divided by total orders) and what a low OTIF indicates about supplier reliability.

3. 3

   What is safety stock and how do you decide the right level?

   Safety stock is extra inventory to buffer against demand or supply variability. A strong answer mentions factors like lead time variability, demand volatility, and service level targets, and may reference a simple formula or trade-off between stockouts and holding costs.

4. 4

   Explain the bullwhip effect with an example from fashion or apparel supply chains.

   Describe how small changes in consumer demand cause larger fluctuations upstream. Use an example like a trend causing retailers to overorder, leading manufacturers to overproduce, resulting in excess inventory and markdowns.

Practical Scenarios and Data Skills

1. 5

   You have a dataset of orders with columns: order date, promised date, delivery date, quantity ordered, quantity delivered. How would you find the top 5 suppliers with the worst on-time delivery?

   Outline steps: calculate delay per order, aggregate by supplier, compute percentage of late orders, sort descending, and take top 5. Mention using Excel pivot tables or SQL GROUP BY and ORDER BY.

2. 6

   A key supplier for a fast-moving fashion brand is consistently late by 3-5 days. What steps would you take?

   Show a structured approach: quantify the impact, communicate with the supplier to understand root cause, explore alternatives like buffer stock or alternate suppliers, and set up a performance improvement plan with review milestones.

3. 7

   How would you use Excel to create a simple dashboard for monitoring inventory levels across 10 warehouses?

   Describe using pivot tables, charts, conditional formatting for low-stock alerts, and slicers for filtering. Mention linking data to a summary sheet and keeping it updated with new data.

4. 8

   You notice that one product category has high inventory but frequent stockouts of specific SKUs. How do you investigate?

   Suggest analysing SKU-level demand, lead times, and order patterns. Look for mismatches between forecast and actual sales, check if slow-moving SKUs are blocking working capital, and recommend SKU rationalisation or reallocation.

Behavioural and Situational Questions

1. 9

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

   Use the STAR method: describe the situation, the data you analysed, the method, and the outcome. Highlight any measurable improvement or learning.

2. 10

   Describe a situation where you had to work with a team to meet a tight deadline. How did you handle it?

   Focus on communication, task division, and prioritisation. Show that you stayed calm, helped others, and delivered on time.

3. 11

   If you had to explain a complex supply chain metric to a non-technical colleague, how would you do it?

   Emphasise simplicity, using analogies, and focusing on why the metric matters for the business. Avoid jargon and check for understanding.

4. 12

   Why do you want to work in supply chain analytics, and why at a fast-growing company like Fashinza Supply Chain?

   Connect your interest in problem-solving and data to the dynamic nature of supply chains. Mention eagerness to learn in a fast-paced environment and contribute to efficiency and growth.

HR and Company Fit

1. 13

   What do you know about Fashinza Supply Chain and its business model?

   Show basic research: it connects fashion brands with manufacturers, focuses on agile supply chains, and may use technology to streamline production and logistics. Avoid claiming insider knowledge.

2. 14

   How do you prioritise your work when you have multiple deadlines?

   Mention methods like Eisenhower matrix or to-do lists, assessing urgency and impact, and communicating with stakeholders if timelines conflict.

3. 15

   Where do you see yourself in three years in supply chain analytics?

   Show ambition to grow into a specialist or lead role, deepen skills in data analytics and supply chain strategy, and take on more responsibility.

4. 16

   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 software like advanced Excel, SQL, or Python as needed.