MIS Executive

Job Title: MIS – Sales Support Executive

Department: Sales / Sales Operations
Industry: Pharma / Medical Devices / FMCG
Location: Bangalore
Reporting to: National Sales Director

Job Summary:

We are looking for an experienced MIS – Sales Support Executive to assist in managing and analyzing sales data, preparing reports, and supporting the sales team with accurate and timely information. The role requires excellent Excel skills and a strong understanding of sales processes in the Pharma, FMCG, or Medical Device industry. The ideal candidate will be highly organized, analytical, and able to work independently with large volumes of data.

Key Responsibilities:

· Prepare and maintain daily, weekly, and monthly sales reports for management and field teams.

· Analyze primary and secondary sales data, stock movement, and distributor-level performance.

· Prepare region-wise, product-wise, and team-wise performance summaries.

· Maintain and update beat plans, target vs. achievement dashboards, incentive calculations, and product performance trackers.

· Consolidate field force data received through emails, Excel sheets, or other offline formats.

· Provide timely and accurate data to the sales team to support planning, forecasting, and reviews.

· Create and automate reports using advanced Excel functions to improve reporting efficiency and accuracy.

· Coordinate with regional sales teams for data collection and validation.

· Assist in preparing sales review presentations and supporting documentation.

Key Skills Required:

• Expert-level MS Excel: VLOOKUP, INDEX/MATCH, Pivot Tables, Charts, Data Validation, Conditional Formatting, Macros/VBA (optional).
• Strong analytical mindset with the ability to interpret numbers and trends.
• High attention to detail and accuracy.
• Good communication and coordination skills.
• Ability to work with large datasets from offline/distributor systems (non-ERP/CRM).

Qualifications:

• Bachelor’s degree in Commerce, Business Administration, Statistics, or any related field.
• 2–5 years of experience in an MIS or Sales Support role within Pharma / FMCG / Medical Devices.
• Experience in working with distributor data and offline sales reporting is essential.

Tools:

• Microsoft Excel (Advanced)
• Microsoft PowerPoint
• Email/Cloud-based file sharing (Google Sheets, OneDrive, etc.)

Job Type: Full-time

Pay: ₹20,000.00 - ₹25,000.00 per month

Benefits:

• Cell phone reimbursement
• Health insurance
• Leave encashment
• Life insurance
• Provident Fund

Schedule:

• Day shift

Supplemental Pay:

• Performance bonus

Application Question(s):

• Do you speak Hindi?

Work Location: In person