The role involves preparing accurate MIS reports, analyzing business performance, dashboard creation and supporting management with actionable insights.
Key Accountabilities
Sales Reporting & MIS :
- Prepare Daily, Weekly & Monthly Sales MIS reports
- Analyze Primary, Secondary Sales and offtake data
- Track Distribution, Productivity metrics
- Create automated dashboards using Excel & Power BI
- Monitor sales performance against targets and forecast
- Maintain data accuracy and validation checks
- Maintain account-wise and region-wise performance dashboards
- Support management with ad-hoc data requirements
- Work closely with Sales and cross-functional Finance & Marketing teams
Business Analytics :
- Analyze sales trends, growth drivers and gaps
- Generate actionable insights to improve business performance.
- Support monthly and quarterly business reviews
Internal Stakeholders:
- Customer Marketing Team
- Regional Sales MT Team
- Key Account Managers
- Finance & Supply Chain Team
Skills Required
Technical Skills :
- MS Excel VLOOKUP, XLOOKUP, INDEX + MATCH, SUMIFS, COUNTIFS, Pivot Tables & Pivot Charts, Data Validation, Conditional Formatting, Dashboard creation, Power Query
- Power Query (Data Cleaning & Transformation)
- Power BI (Basic Dashboard & Data Modeling knowledge)
- Strong understanding of sales concepts like Primary Sales, Secondary Sales, Offtakes, Market Share, Assortment, Distribution metrics
Analytical / Behavioral Skills:
- Data management & interpretation
- Trend Analysis
- Detail Oriented
Qualification:
- Bachelor's degree
- 2-5 years in sales MIS, Business Analytics
- Experience in FMCG Modern Trade is highly preferred
- Certification in Power BI, Advanced Excel or Data Analytics is an advantage
