Backend Sales Coordinator / Sales MIS Coordinator

Sanjay Electricals; Kolkata District; On-site; INR 480,000 - 600,000; Full time

Job summary

Sanjay Electricals is seeking a Backend Sales Coordinator / Sales MIS Coordinator to support the sales team by tracking activities, managing MIS, and analyzing targets against achievements. The role requires a commerce background, advanced Excel skills, and experience with sales apps/CRM systems.

The candidate will coordinate with field sales teams and internal departments to ensure accurate data flow, generate periodic reports, and drive data-driven insights for sales performance reviews.

Qualifications

• Commerce background preferred (B.Com).
• Strong Advanced Excel skills and data analysis capability required.
• Experience with MIS reporting and sales analytics is essential.

Responsibilities

• Monitor daily sales activities and ensure timely updates in the Sales App / CRM.
• Prepare daily/weekly/monthly Sales MIS and dashboards.
• Analyze Target vs. Actual achievement and report variances to management.
• Develop and maintain advanced Excel-based dashboards for sales review meetings.
• Coordinate with field sales teams and internal departments for data accuracy.
• Maintain documentation of orders, customer details and sales communications.
• Support management reporting with accurate data and insights.

Skills

Advanced Excel

MIS analysis

Data analysis

Pivot Tables

CRM / Sales Apps

Education

B.Com / Commerce Background Preferred

Tools

Sales App / CRM / ERP

Excel dashboards

Job description

Position: Backend Sales Coordinator / Sales MIS Coordinator

Department: Sales / Commercial
Industry: Electrical Manufacturing / Electrical Sales
Location: Kolkata Head Office
Reporting To: Operation Head / Management
Experience: 25 Years
Qualification: B.Com / Commerce Background Preferred
Joining: Immediate / Early Joiner Preferred

Job Summary

We are looking for a Backend Sales Coordinator who will be responsible for supporting the sales team through sales activity tracking, app-based monitoring, MIS preparation, target analysis and coordination with field sales personnel.

The candidate should be comfortable working on a sales tracking/application-based system through which the activities of sales personnel can be monitored, including customer visits, calls, PJP, leads, orders, follow-ups and other sales activities.

The ideal candidate should have a Commerce background, strong Advanced Excel skills and good analytical ability, particularly in analysing Sales Target vs. Achievement.

Candidates with prior experience in the Electrical / Electrical Equipment / Electrical Manufacturing sales industry will be preferred.

Key Responsibilities

1. Sales App & Activity Tracking

• Monitor and track the daily activities of sales personnel through the company's Sales App / CRM / Activity Tracking Application.
• Track sales representatives' daily visits, calls, customer meetings, PJP and follow-up activities.
• Monitor whether sales team members are regularly updating their activities in the application.
• Identify gaps, deviations and inactive users and report them to the concerned reporting manager.
• Prepare daily activity tracking reports based on application data.
• Coordinate with sales personnel to ensure proper and timely updating of activities.

2. Sales MIS & Reporting

• Prepare daily, weekly and monthly Sales MIS.
• Maintain region-wise, state-wise, territory-wise and salesperson-wise sales reports.
• Track orders, billing, dispatch, collection and other relevant sales parameters.
• Consolidate data received from different sales teams and prepare management reports.
• Ensure accuracy and timely submission of MIS.

3. Target vs. Achievement Analysis

• Maintain salesperson-wise and territory-wise sales targets.
• Analyse Target vs. Actual Achievement on a daily, weekly and monthly basis.
• Calculate achievement percentage and identify shortfalls against assigned targets.
• Prepare variance analysis and highlight underperforming territories / sales personnel.
• Track month-on-month and year-on-year sales performance.
• Provide analytical inputs to management for sales review meetings.

4. Advanced Excel & Data Analysis

• Work extensively on Advanced Excel for sales analysis and reporting.
• Prepare Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IF formulas, data validation, filters and dashboards.
• Consolidate large volumes of sales data from multiple sources.
• Develop automated and structured MIS formats for management review.
• Identify trends, gaps and inconsistencies in sales data.

5. Backend Sales Coordination

• Coordinate with field sales teams regarding daily reporting, sales activities and pending updates.
• Follow up with sales personnel for missing information and reports.
• Coordinate with Accounts, Dispatch, Production and other departments wherever required for sales-related information.
• Maintain proper documentation of sales orders, customer details and sales activities.
• Ensure timely flow of information between the Sales Team and Head Office.

6. Sales Performance Monitoring

• Monitor salesperson-wise productivity and activity levels.
• Compare field activity with actual sales performance.
• Identify cases where activity levels are high but sales achievement is low and highlight the same to management.
• Track new customer additions, enquiries, leads, orders and conversions.
• Prepare performance reports for periodic sales reviews.

7. Management Reporting

• Prepare daily dashboards and management reports.
• Provide accurate data for sales review meetings.
• Highlight key observations, deviations and areas requiring management attention.
• Maintain confidentiality and accuracy of sales and customer data.

Key Performance Indicators (KPIs)

The performance of the candidate will be evaluated based on:

• Accuracy and timeliness of Sales MIS.
• Proper tracking of sales activities through the application.
• Timely identification of activity/reporting gaps.
• Accuracy of Target vs. Achievement analysis.
• Quality of sales dashboards and reports.
• Timely follow-up with field sales personnel.
• Data accuracy and reconciliation.
• Ability to provide meaningful sales performance analysis.

Candidate Profile

Qualification

• B.Com / Commerce Graduate preferred.
• Candidates with relevant experience and strong MIS/Excel knowledge may also be considered.

Experience

• 2–5 years of experience in Sales Coordination, Sales MIS, Backend Sales, Business MIS or similar roles.
• Candidates from the Electrical / Electrical Equipment / Electrical Manufacturing / Consumer Electrical sales industry will be strongly preferred.

Technical Skills

• Advanced Excel – Mandatory.
• Strong knowledge of Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IF formulas, filters and data analysis.
• Experience working with Sales Apps, CRM, ERP or Field Sales Tracking Applications.
• Good understanding of MIS and dashboard preparation.
• Knowledge of sales reporting and performance analysis.

Functional Skills

• Strong analytical and numerical ability.
• Good communication and coordination skills.
• Strong attention to detail.
• Ability to handle large volumes of data.
• Good follow-up and reporting skills.
• Ability to identify discrepancies and performance gaps.
• Ability to work independently and meet strict reporting deadlines.

Preferred Candidate

The ideal candidate should:

• Have a Commerce background, preferably B.Com.
• Have strong Advanced Excel and MIS skills.
• Have practical experience in Sales App / CRM-based activity tracking.
• Understand how to monitor field sales activities and salesperson productivity.
• Be capable of analysing Sales Target vs. Achievement.
• Preferably have experience in the Electrical Sales / Electrical Manufacturing industry.
• Be comfortable coordinating with a Pan-India Sales Team.
• Be available to join immediately or at the earliest.

Immediate Requirement

Immediate / Early Joiners will be given preference.

The candidate should be highly comfortable with data, Excel, sales applications, activity monitoring and performance analysis, and should have the ability to convert raw sales data into clear and actionable MIS for management.