Business Intelligence Analyst

About the Role

This position focuses on turning business data into practical decisions across sales, inventory, marketing, and channel operations. The analyst will need to study sales movement, rate of sale patterns, forecasting, and discount modelling to uncover opportunities that improve revenue and profitability.

The right candidate should be meticulous, comfortable handling large datasets, and able to translate raw numbers into clear business actions and recommendations.

Key Responsibilities

Data extraction and reporting

• Collect, clean, combine, and analyse information from Excel files, CRM systems, ERP platforms, and sales dashboards.
• Set up recurring reports and trackers so information stays accurate and delivered on time.
• Prepare structured MIS reports for leadership and cross-functional stakeholders.

Rate of sale and performance analysis

• Review rate of sale at detailed levels such as channel, SKU, region, and partner performance.
• Spot trends, gaps, and growth opportunities to support planning and corrective actions.
• Share practical insights with sales teams to improve movement at important outlets and channels.

Forecasting and inventory planning

• Develop demand forecasts using sales history, seasonality, rate of sale, and market inputs.
• Suggest the right replenishment quantities and timing for each channel.
• Highlight stockout risks, overstock situations, and actions to correct them.

Discount and pricing mechanism creation

• Design margin discount structures, volume-linked discounts, and partner incentive frameworks.
• Assess how proposed schemes affect margins, profitability, and cash flow.
• Keep discount structures aligned with brand rules and market strategy.

Festive and ad-hoc offer impact modelling

• Run pre- and post-campaign analysis for festive offers, promotions, and ad-hoc schemes.
• Estimate the likely sales uplift from seasonal campaigns using data-based models.
• Measure the effect on profitability and present findings to management.

Brand coordination and liaison

• Serve as the main point of contact between internal teams and external brand principals.
• Share regular reports, market trends, inventory status, and business insights with brand partners.
• Ensure BI outputs match brand expectations, reporting needs, and market intelligence requirements.

Requirements

• A bachelor’s degree in Business Analytics, Statistics, Commerce, Engineering, Economics, or a related discipline is required.
• An MBA in Business Analytics or Operations is preferred but not mandatory.
• At least 6 years of experience in Business Intelligence, Sales Analytics, Planning, or MIS is needed.
• Prior exposure to FMCG, retail, electronics, consumer durables, or multi-channel distribution is preferred.
• Strong experience working with CRM platforms and large datasets is essential.
• Advanced MS Excel skills are required, including pivot tables, Power Query, VLOOKUP/XLOOKUP, and ideally macros.
• Hands-on experience with CRM tools such as ZOHO, Salesforce, HubSpot, or similar platforms is needed.
• Comfort with data visualisation tools like Power BI, Tableau, or Google Data Studio is expected.
• Strong quantitative analysis, modelling, and forecasting ability is important.
• The role demands sharp analytical thinking, problem-solving, accuracy, attention to detail, communication, presentation skills, and a proactive, deadline-driven approach.
• Must be able to work effectively with sales, finance, supply chain, and marketing teams.

Additional Information

This role is based in New Delhi, Delhi, India and is a full-time, onsite position.

No salary, stipend, joining date, application deadline, or vacancy count was specified in the source.