Sales Coordinator

JOB DESCRIPTION – SALES COORDINATOR/MIS EXECUTIVE

Designation: Sales Coordinator
Department: Marketing & Sales
Reporting To: Marketing Head
Location: Corporate Office, Nagpur
Experience: 1–3 Years
Salary Range: 20K to 25K

1. Job Purpose

To manage and maintain accurate sales data, prepare daily/weekly/monthly MIS reports, monitor sales performance, and provide timely analytical information to the Sales Management Team for effective decision-making and business planning.

2. Key Responsibilities

A. Sales MIS & Reporting

• Prepare and circulate daily, weekly, and monthly sales MIS reports.
• Maintain sales data related to targets, achievements, orders, billing, collections, and outstanding amounts.
• Prepare sales performance reports region-wise, territory-wise, product-wise, customer-wise, and salesperson-wise.
• Track actual sales against targets and highlight deviations.
• Prepare monthly sales dashboards and management reports.
• Ensure timely submission of all scheduled MIS reports to management.

B. Data Management

• Collect sales data from the sales team and ensure accuracy and completeness.
• Maintain and regularly update sales databases, master data, customer records, product information, and sales trackers.
• Verify data received from different sources and identify discrepancies.
• Coordinate with Sales, Finance, Dispatch, and other departments for data reconciliation.
• Maintain proper documentation and records of MIS reports.

C. Sales Analysis

• Analyze sales trends and prepare reports highlighting key variations.
• Monitor achievement against monthly, quarterly, and annual sales targets.
• Prepare reports on product-wise and territory-wise sales performance.
• Track new customer additions, repeat business, sales growth, and order status.
• Identify data gaps, unusual variations, and pending actions and escalate them to the concerned team.

D. Order & Business Tracking

• Maintain order booking and order execution reports.
• Track pending, cancelled, and completed orders.
• Coordinate with Sales and Dispatch teams regarding order status.
• Prepare reports on order conversion and pending orders.
• Monitor customer-wise outstanding sales/order information as required.

E. Dashboard & Management Support

• Develop and maintain Excel-based MIS dashboards.
• Prepare management presentations and analytical reports whenever required.
• Provide accurate data for monthly/quarterly business review meetings.
• Support the Sales Head in preparing sales review presentations and performance analysis.
• Maintain confidentiality of sales and business information.

3. Required Skills

• Advanced knowledge of MS Excel.
• Good knowledge of Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IF formulas, conditional formatting, and charts.
• Good analytical and numerical skills.
• Strong data management and reporting skills.
• Good communication and coordination skills.
• High level of accuracy and attention to detail.
• Ability to manage multiple reports and deadlines.
• Knowledge of ERP/CRM/Sales software will be preferred.

4. Educational Qualification

• Graduate in Commerce, Management, Business Administration, Statistics, or a related discipline.
• MBA/PGDM in Sales, Marketing, Finance, or Business Analytics will be an added advantage.

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

Work Location: In person