Business Analyst

MALABAR GOLD & DIAMONDS; Kozhikode district; On-site; INR 600,000 - 900,000; Full time

Job summary

MALABAR GOLD & DIAMONDS in India seeks a data analytics professional to turn store-level data into actionable insights. You will analyze sales, margin, inventory turnover, and pricing effects to improve profitability and financial stability.

Design MIS reports and dashboards, ensure data consistency across ERP/POS/BI, and partner with Retail Operations, Merchandising, Finance, Marketing, and Supply Chain to drive strategic decisions.

Qualifications

• Experience in retail analytics and MIS reporting.
• Translate data into actionable insights for decision making.
• Strong proficiency in Excel, BI tools and data validation.
• Experience with ERP/POS data and large datasets.

Responsibilities

• Analyze sales performance by category, design, collection, store, region.
• Track gross profit margin, contribution margin, profitability and EBITDA.
• Evaluate impact of gold price movements on pricing, charges, discounts and schemes.
• Monitor inventory metrics: stock turns, ageing, dead stock, replenishment.
• Design and maintain MIS reports, dashboards and KPIs for management.
• Collaborate with Retail Operations, Merchandising, Finance, Marketing and Supply Chain.
• Present insights in a structured, business-friendly manner to senior stakeholders.

Skills

Advanced Excel

PowerPoint

Pivot Tables

Power Query

Advanced Formulas

Power BI

Tableau

Qlik

Data Extraction

Data Validation

ERP Systems

POS Systems

Tools

ERP/POS Systems

Job description

With strong expertise in analytical tools and retail data analysis, the role transforms complex data into actionable insights to improve sales performance, optimize inventory turnover, monitor gold and diamond price fluctuations, track budgets and expenses and deliver accurate financial performance reporting to support the companys financial stability.

Primary Responsibilities

Sales, Inventory, Margin & Overall Profitability Analysis

• 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

Data, Reporting & Dashboards

• 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

Expense & Cost Analysis

• 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

Business Partnering & Decision Support

• Collaborate with Retail Operations, Merchandising, Finance, Marketing, and Supply Chain teams
• Provide analytical support for store performance reviews, expansion evaluations, and strategy discussions
• Present insights in a structured, business-friendly manner to senior stakeholders
• Support ad-hoc analysis for management and leadership reviews