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)
- Robust 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

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