Summary:

We are looking for a detail-oriented and analytical MIS Executive with strong expertise in Excel, data management, and reporting. The candidate should have experience in the FMCG industry and solid understanding of sales concepts like Primary Sales, Secondary Sales, ECO, Line Sold, Distribution metrics, etc.

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

Essential Duties and Responsibilities:

- Prepare Daily, Weekly & Monthly Sales MIS reports.
- Analyze Primary & Secondary Sales data.
- Track ECO (Effective Call Objective), Line Sold, Distribution, Productivity metrics.
- Create automated dashboards using Excel & Power BI.
- Data cleaning and transformation using Power Query.
- Maintain data accuracy and validation checks.
- Prepare region-wise, distributor-wise & product-wise performance reports.
- Support management with ad-hoc data requirements.
- Work closely with Sales,



Finance & Marketing teams.

Required Skills / Experience / Competencies:

- Atleast 2-5 years of relevant experience

- Experience in FMCG desirable

- High Energy, Self driven ,

Technical Skills Required :-

VLOOKUP, XLOOKUP, INDEX + MATCH, SUMIFS, COUNTIFS, Pivot Tables & Pivot Charts, Data Validation, Conditional Formatting, Dashboard creation

Data Tools :-

- Power Query (Data Cleaning & Transformation)
- Basic SQL (SELECT, JOIN, WHERE, GROUP BY)
- Power BI (Basic Dashboard & Data Modeling knowledge)

FMCG Knowledge Required:

- Primary & Secondary Sales understanding
- Distribution & Coverage
- ECO (Effective Call Objective)
- Line Sold
- Productivity Metrics
- Sales Target vs Achievement
- Scheme & Incentive calculations

Job Requirements:

- Contractual

Location : Noida

📌 MIS Executive (On Third Party Payroll) (Uttar Pradesh)
🏢 Brillon Consumer Products
📍 Uttar Pradesh