Merchandising Production Analyst

Responsibilities:

Production Cash Flow & Payment Analysis :

• Build and maintain the production cash-out projection by collection and month, based on purchase order commitments and vendor payment terms (down payment, progress, and balance payments).
• Track actual production spend against the approved MDP budget and projection, and analyze variances by brand, vendor, and product category.
• Prepare the vendor payment schedule for Finance, flag payment timing risks and cash concentration, and reconcile MDP records with Finance disbursement data.
• Provide cost impact analysis for order changes, reorders, and cancellations to support MDP decision-making

Vendor Performance Analytics

• Consolidate vendor data on delivery timeliness, quality and reject rates, price movements, and capacity utilization into a standardized vendor database.
• Produce periodic vendor scorecards and cost comparisons across vendors to support allocation, negotiation, and vendor review decisions.
• Analyze cost breakdowns (fabric, accessories, CMT, and overhead) to identify cost drivers and savings opportunities across the vendor base.

Product Development & Costing Data

• Track product development pipeline data, including sample-to-bulk lead times, sample approval rates, and development calendar adherence.
• Maintain cost sheets and calculate landed cost and margin per style against target margin, and flag styles that fall outside costing guidelines.
• Analyze development and production data by collection to identify recurring delays, cost overruns, and quality issues for MDP review.

MDP Reporting, Dashboards Data Governance

• Design and maintain MDP dashboards and the monthly MDP performance report covering cash flow, vendor performance, and development status.
• Own MDP master data (vendor, style, purchase order, and costing records), and enforce data standards, validation, and update cadence with the MDP team.
• Deliver ad hoc analyses and data requests from MDP leadership, Finance, and brand teams accurately and on time.

Requirements :

• 3–5 years in a financial analyst, cost accounting, data analyst, or merchandising/production planning analytics role.
• Preferred Experience Experience in fashion, garment, or textile manufacturing or retail supply chain; hands-on exposure to vendor costing, purchase order and payment tracking, and building dashboards from ERP or operational data.
• Minimum Education Bachelor's degree in Finance, Accounting, Statistics, Industrial Engineering, Business, or related fields.
• Advanced Excel or Google Sheets, including financial modelling, cash flow projection, and large-dataset analysis.
• Solid understanding of product costing, margin analysis, and payment-term structures in a manufacturing or sourcing context.
• Proficient in English, written and verbal.