Analyst - Financial Planning & Analysis

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 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