Malabar Group - Business Analyst

Role Objective:

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 company financial stability.

Primary Responsibilities:

Expense & Cost Analysis:

- Perform store-level and corporate-level expense analysis, including:

1. Store operating costs (rent, manpower, utilities etc)

2. Marketing & promotion (ATL & BTL expenses)

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