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 rapid 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 clear, 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

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