Analyst - Financial Planning & Analysis

MALABAR GOLD & DIAMONDS; Kozhikode district; On-site; INR 700,000 - 1,000,000; Full time

Job summary

MALABAR GOLD & DIAMONDS in Kozhikode district is seeking a data-driven analyst to sharpen sales insights, track margins, and drive profitability across categories, collections, stores and regions.

You will build MIS dashboards in Power BI/Tableau, validate data across ERP/POS, and translate findings into actionable recommendations for Finance and Operations.

Qualifications

• Expertise in advanced Excel features and PowerPoint for reporting.
• Hands-on experience with Power BI, Tableau or Qlik for dashboards.
• Experience with data extraction, validation and ERP/POS data.
• Ability to model large datasets and deliver actionable insights.

Responsibilities

• Analyze sales performance by category, design, collection, store and region.
• Track margins and profitability at product and store levels including EBITDA.
• Evaluate impact of price movements, making charges, discounts and schemes.
• Monitor inventory metrics such as stock turns, ageing, dead stock and replenishment.
• Identify fast movers, slow movers, and assortment gaps.
• Design and maintain MIS reports, dashboards and KPIs.
• Ensure data consistency across ERP, POS and BI systems.
• Translate data into actionable insights and business recommendations.
• Perform store-level and corporate expense analysis including rent, marketing, overheads.
• Analyze expense-to-sales ratios and cost efficiency trends by store/region/format.
• Support budget vs actual variance analysis and provide insights to management.
• Identify cost optimization opportunities without impacting sales or customer experience.
• Work with Finance and Operations to improve cost visibility and tracking.

Skills

Advanced Excel

PowerPoint

Pivot Tables

Power Query

Advanced formulas

Data extraction

Data modeling

Large datasets handling

Tools

Power BI

Tableau

Qlik

ERP/POS systems

Job description

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