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 Up-to-date Trade is highly preferred
Certification in Power BI, Advanced Excel or Data Analytics is an advantage

📌 Executive - Sales MIS Modern Trade (Gurugram)
🏢 Brillon Consumer Products (Formerly known as SC Johnson
📍 Gurugram