Business Intelligence Analyst

About the RoleThe 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 Responsibilities1. Data Extraction & ReportingPull, 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 AnalyticsAnalyse 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 PlanningBuild 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 CreationDesign 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 ModellingCreate 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 & LiaisonAct 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 & QualificationsEducationBachelor’s degree in Business Analytics, Statistics, Commerce, Engineering, Economics , or similar fields.MBA in Business Analytics or Operations (preferred but not mandatory).Experience3 – 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 SkillsAdvanced 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 CompetenciesStrong analytical and problem-solving capabilityHigh accuracy and attention to detailAbility to convert data into clear business recommendationsExcellent communication & presentation skillsProactive, structured, and deadline-oriented working styleAbility to work cross-functionally with sales, finance, supply chain, and marketing