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.