Mis And Sales Coordinator

Role Summary

To provide timely and accurate MIS and coordination support to the Marketing function by ensuring proper receipt, validation, consolidation and reporting of field and marketing data, with clear visibility of activity execution, expenses and key marketing initiatives.

The role will coordinate with field teams for data submission, action closure and FFA compliance, support training on existing field applications, and deliver management-ready MIS, dashboards and trackers for effective decision-making.

Role and Responsibilities

1. Activity Coordination & Calendar Management

• Maintain the marketing activity calendar; track planned vs. executed status for Field Days, BFM/SFM, demos, farmer meetings, trade activities, campaigns and launches.
• Follow up with RDGM/ADGM/ZBM teams for pending activities, data, and action closures.

2. Data Collection & Database Integrity

• Collect field marketing data in standardized formats; screen for gaps, duplication, and inconsistency before compilation.
• Maintain consolidated master databases activities, digital assets, testimonials, branding, campaigns.

3. MIS & Reporting

• Prepare Daily/Weekly/Monthly Marketing Activity Reports (planned vs. actual, zone-wise/division-wise) from FFA and field data.
• Build simple, management-ready dashboards; ensure all reports meet agreed timelines.

4. FFA & Field App Compliance

• Drive proper FFA/field-app usage and reporting discipline across RDGM/ADGM/ZBM teams.
• Support TA/FA and TBM/new-joiner onboarding on FFA; escalate logging/compliance gaps.

5. Expense, Advance & Travel Report Tracking

• Consolidate monthly marketing expense/claims; track expense vs. approved budget by activity.
• Compile and follow up advance requirements for upcoming activities; maintain a live tracker of advances, expenses, and pending claims.
• Receive travel reports/expense claims from marketing field personnel; check for accuracy and completeness, and submit for further processing to Finance/Accounts.

6. Digital & Content Coordination

• Track collection, approval, and utilization of farmer testimonials, videos, and photographs.
• Maintain the digital asset database; support regional-language campaign content needs.

7. Market & Competitor Intelligence

• Collect competitor pricing, scheme, and launch data from field teams; compile into a structured monthly competitor report with trends and observations flagged for management.

Key Skills Required

• Excellent MS Excel — Pivot Tables, XLOOKUP/VLOOKUP, SUMIFS, dashboarding (mandatory)
• Strong data compilation, analysis, and interpretation ability
• High attention to detail and accuracy under recurring deadlines
• Strong coordination/follow-up skills across multiple field teams
• Ability to convert raw field data into clear, decision-ready reports
• Good written and verbal communication