Executive - Sales MIS Modern Trade (on Third Party Pay Roll)

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