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