Executive - Sales MIS Modern Trade

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