Role & responsibilities

- Analyze sales performance by category, design, collection, store, region
- Track gross profit margin, contribution margin, and profitability at product and store levels including EBITDA analysis
- Evaluate the impact of gold price movements, making charges, discounts, and schemes
- Monitor inventory metrics such as stock turns, ageing, dead stock, and replenishment effectiveness
- Identify fast movers, slow movers, and assortment gaps
- Design and maintain MIS reports, dashboards, and KPIs for management
- Ensure data consistency across ERP, POS, and BI systems
- Translate data into transparent, actionable insights and business recommendations
- Perform store-level and corporate-level expense analysis, including:
- Store operating costs (rent, manpower, utilities etc)
- Marketing & promotion (ATL & BTL expenses)
- Overheads and support-function expenses

- Analyze expense-to-sales ratios and cost efficiency trends by store, region, and format
- Support budget vs actual expense variance analysis and provide insights to management




- Identify cost optimization opportunities without impacting sales or customer experience
- Work with Finance and Operations teams to improve cost visibility and tracking

Analytical Tools & Technical Skills (Mandatory)

- Advanced Excel & PowerPoint skills (Pivot Tables, Power Query, advanced formulas)
- Strong hands-on experience with Power BI / Tableau / Qlik
- Working knowledge for data extraction and validation
- Experience working with ERP/POS systems
- Ability to handle large datasets and create structured analytical models

Role: Analyst - Financial Planning & Analysis, Industry Type: Gems & Jewellery, Department: Finance & Accounting, Employment Type: Full Time, Permanent Role Category: Finance Education UG: B.C.A. in Any Specialization, B.Sc in Any Specialization, B.Tech / B.E. in Any Specialization read more

Key Skills Skills highlighted with ‘‘ are preferred keyskills Financial AnalysisPower BIExcelFinancial Planning and AnalysisRetail TableauData Analysis

📌 Analyst - Financial Planning & Analysis (Kozhikode)
🏢 MALABAR GOLD u0026 DIAMONDS
📍 Kozhikode