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

Brillon Consumer Products; Gurugram District; On-site; INR 450,000 - 750,000; Full time

Job summary

Brillon Consumer Products is seeking a skilled Sales MIS & Analytics professional to build and automate MIS reports, dashboards and insights for management.

You will analyze Primary/Secondary Sales, track distribution and productivity, and collaborate with Sales, Finance and Marketing to deliver actionable insights in a fast-paced FMCG environment.

Qualifications

• Bachelor's degree in a relevant field is required.
• 2–5 years of experience in sales MIS or business analytics.
• FMCG Modern Trade experience highly preferred.
• Power BI, Advanced Excel or Data Analytics certifications are an advantage.

Responsibilities

• Prepare Daily, Weekly & Monthly Sales MIS reports.
• Analyze Primary, Secondary Sales and offtake data to drive insights.
• Create automated dashboards using Excel & Power BI.
• Monitor sales performance against targets and support cross-functional teams.

Skills

Data analysis

Detail orientation

Trend analysis

Stakeholder communication

Dashboard storytelling

Education

Bachelor's degree

Tools

MS Excel

Power BI

Power Query

VLOOKUP

XLOOKUP

INDEX + MATCH

SUMIFS

COUNTIFS

Pivot Tables

Pivot Charts

Job description

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:

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