Business Intelligence Analyst

About the Role

Business Intelligence Analyst

The ideal candidate will be highly detail-oriented, comfortable working with large datasets, and capable of converting raw data into meaningful business recommendations.

Key Responsibilities

1. Data Extraction & Reporting

• Pull, clean, consolidate, and analyse data from multiple sources including Excel files, CRM, ERP, and sales dashboards.
• Automate periodic reports and trackers to ensure accuracy and timeliness.
• Build structured MIS reports for leadership and cross-functional teams.

2. Rate of Sale (ROS) & Performance Analytics

• Analyse Rate of Sale at granular levels including channel-wise, SKU-wise, region-wise, and partner-wise performance.
• Identify trends, gaps, and opportunities to support business planning and corrective actions.
• Provide actionable insights to sales teams for accelerating movement at key outlets or channels.

3. Forecasting & Inventory Planning

• Build demand forecasts based on sales history, seasonality, ROS, and market inputs.
• Recommend optimal stock replenishment quantities and timelines for each channel.
• Flag potential stockouts, overstock risks, and suggest corrective strategies.

4. Discount & Pricing Mechanism Creation

• Design and model

  margin discount structures

  ,

  volume-based discounts

  , and

  incentive frameworks

  for partners.
• Evaluate the business impact of proposed discount schemes on margins, profitability, and cash flow.
• Ensure discount mechanisms align with brand guidelines and market strategy.

5. Festive & Ad-Hoc Offer Impact Modelling

• Create pre- and post-performance analyses of festive offers, market promotions, and ad-hoc schemes.
• Predict the effect of festive / seasonal campaigns on

  toplined (sales uplift)

  through data-driven models.
• Assess the resultant impact on

  bottom-line (profitability)

  and report findings to management.

6. Brand Coordination & Liaison

• Act as a central point of contact between internal teams and external brand principals.
• Share periodic reports, market trends, inventory updates, and business insights with brand partners.
• Align BI outputs with brand expectations, reporting formats, and market intelligence needs.

Required Skills & Qualifications

Education

• Bachelor’s degree in

  Business Analytics, Statistics, Commerce, Engineering, Economics

  , or similar fields.
• MBA in Business Analytics or Operations (preferred but not mandatory).

Experience

• 3 – 6 years of experience in

  Business Intelligence, Sales Analytics, Planning, or MIS roles

  .
• Experience working with FMCG, retail, electronics, consumer durables, or multi-channel distribution preferred.
• Strong exposure to CRM and large datasets is essential.

Technical Skills

• Advanced proficiency in

  MS Excel

  (Pivot tables, Power Query, VLOOKUP/XLOOKUP, macros advantageous).
• Experience with

  CRM tools

  (ZOHO, Salesforce, HubSpot, or similar).
• Comfort with

  data visualization tools

  : Power BI, Tableau, or Google Data Studio.
• Strong quantitative, modelling, and forecasting skills.

Key Competencies

• Strong analytical and problem-solving capability
• High accuracy and attention to detail
• Ability to convert data into clear business recommendations
• Excellent communication & presentation skills
• Proactive, structured, and deadline-oriented working style
• Ability to work cross-functionally with sales, finance, supply chain, and marketing