Business Intelligence Analyst

About the job

About the Role The Business Intelligence Analyst will play a critical role in driving data-backed decision-making across sales, inventory, marketing, and channel operations. This role requires strong analytical capability, deep understanding of sales patterns (ROS), forecasting, discount modelling, and the ability to extract insights that support revenue growth and profitability optimization. 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. 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.

Requirements

• Data extraction
• Sales Analytics
• Forecasting
• Excel
• Data visualization

Qualifications

• Bachelor’s degree in Business Analytics, Statistics, Commerce, Engineering, Economics, or similar fields

Preferred Technologies

• Data extraction
• Sales Analytics
• Forecasting
• Excel
• Data visualization