Sales MIS - Consultant

Job Title: MIS Consultant

Function: Sales / Commercial OTC, FMCG

Location: Mumbai

Reports To: SD Lead / Trade Marketing lead Role Overview

The MIS Consultant PAKS will support the sales business through accurate and timely sales reporting, dashboard creation, data management, and business analysis. The role involves consolidating primary, secondary, and tertiary sales data from Distributor Management System (DMS)/SFA platforms and field inputs, building MIS reports, analyzing team sales and distributor performance trends, and partnering with field sales teams and distributors to ensure a seamless flow of information. This role requires strong analytical skills, attention to detail, and the ability to present insights that help drive commercial decision-making in the PAKS channel.

Key Responsibilities

1. Reporting & Dashboarding

Develop and maintain daily/weekly/monthly MIS reports for the PAKS sales business.

Publish performance scorecards, KPIs, process health metrics, and variance reports covering primary, secondary, and tertiary sales.

Track and report distributor-wise, territory-wise, and SKU-wise sales performance for the channel.

2. Data Management

Collect, consolidate, clean, and validate data from DMS/SFA systems, distributor claims, and field inputs.

Ensure 100% data accuracy and integrity across all reporting systems.

3. Business Analysis

Analyse sales trends, distributor productivity, and market coverage; identify anomalies and highlight risks/opportunities.

Support ad-hoc business queries from PAKS sales leadership with quick turnaround analytics.

4. Stakeholder Collaboration

Work closely with field sales / field force teams and distributors to gather data and align on metrics.

Ensure timely and accurate delivery of all reports to PAKS sales leadership.

Assist in the preparation of monthly and quarterly business reviews.

5. Vendor & Claims Management

Manage vendor creation and payment processing.

Handle settlement of trade schemes, salesmen incentives, and gifts.

Qualifications & Experience

2–4 years of experience in Sales Reporting / MIS / Business Analytics, preferably within FMCG General Trade.

Proficiency in MS Office (Excel, Word, PowerPoint, Outlook).

Power BI – Must.

Experience with sales monitoring / DMS tools (e.g., Bizom) preferred.