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

Brillon Consumer Products Pvt Ltd (Formerly known as SC Johnson).; Gurugram District; On-site; INR 600,000 - 900,000; Full time

Job summary

Brillon Consumer Products Pvt Ltd (Formerly SC Johnson) is seeking a data-driven Sales MIS analyst to prepare and analyze MIS reports, build dashboards in Power BI, and provide actionable insights to drive sales performance. The role collaborates with Customer Marketing, Key Account Managers, Finance and Supply Chain, focusing on data accuracy, trend analysis, and ad-hoc requirements.

The ideal candidate will have 2–5 years of experience in sales analytics, proficiency in Power BI and Advanced

Qualifications

• 2-5 years in sales MIS or business analytics.
• Experience in FMCG Modern Trade preferred.
• Power BI / Advanced Excel certification a plus.

Responsibilities

• Prepare Daily, Weekly & Monthly Sales MIS reports.
• Analyze Primary, Secondary Sales and offtake data.
• Maintain account-wise and region-wise performance dashboards.
• Monitor sales performance against targets and forecast.
• Support management with ad-hoc data requirements.
• Work closely with Sales and cross-functional Finance & Marketing teams.

Skills

Power BI

Power Query

Sales analytics

Tools

Advanced Excel

Job description

The role involves preparing accurate MIS reports, analyzing business performance, dashboard creation and supporting management with actionable insights.

Key Accountabilities

• Prepare Daily, Weekly & Monthly Sales MIS reports
• Analyze Primary, Secondary Sales and offtake data
• Track Distribution, Productivity metrics
• 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
• Key Account Managers
• Finance & Supply Chain Team

Skills Required

Technical Skills :

• 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:

• 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