बैक ऑफिस MIS एग्जीक्यूटिव

## CITY MOTOR WORKS – MIS EXECUTIVE

Location: 49 United Compound Dewas Naka, Indore

Department: Operations / Workshop

Employment: Full Time

### Job Summary

City Motor Works is looking for a smart, detail-oriented and Excel-savvy MIS Executive to manage workshop data, prepare daily MIS reports and provide management with accurate information for decision-making.

The role will primarily focus on Workshop, Service, Parts, Billing, Customer, Technician Productivity and Attendance MIS. Automotive workshop/DMS experience will be an advantage.

### Key Responsibilities

• Prepare Daily, Weekly & Monthly MIS Reports

• Maintain workshop Job Card / RO data

• Track Vehicle In / Vehicle Out / Pending Jobs / TAT

• Monitor Labour Billing & Parts Billing

• Track Technician Productivity & Efficiency

• Prepare Parts Consumption & Stock Reports

• Maintain Customer & Vehicle Data

• Track Workshop Sales vs Target

• Maintain Employee Attendance & Working Hours

• Prepare Pending Payment / Billing reports

• Reconcile data between DMS, Excel, Job Cards & Billing

• Identify data errors and coordinate with concerned teams for correction

• Prepare management dashboards, charts and performance reports

• Provide any special reports required by management

### 💻 Skills Required

Must Have:

• Strong knowledge of MS Excel / Google Sheets

• VLOOKUP / XLOOKUP

• SUMIF / SUMIFS / COUNTIF / COUNTIFS

• Pivot Tables

• Filters & Conditional Formatting

• Basic Dashboard & Charts

• Good data-entry speed and accuracy

• Strong analytical & follow-up skills

Good to Have:

• Automobile workshop experience

• Knowledge of DMS / ERP

• Power BI / Excel Macros

• Understanding of workshop operations

Advanced Excel, dashboards, DMS/ERP knowledge and data reconciliation are commonly requested in current automotive MIS/EDP roles. ([Glassdoor][2])

### 🎯 Key KPIs

1. 100% accuracy in MIS data

2. Daily reports submitted on time

3. Zero/Minimum data-entry errors

4. Timely tracking of pending Job Cards

5. Accurate Technician Productivity Report

6. Accurate Parts & Labour reconciliation

7. Daily management dashboard updated

8. Timely follow-up on missing data

### 👤 Candidate Profile

• Graduate: B.Com / BBA / BCA / Any Graduate

• 1–3 years MIS experience preferred

• Freshers with excellent Excel skills can also be considered

• Automobile/workshop experience preferred

• Good communication and coordination skills

• Should be comfortable working with numbers, data and deadlines

• इस फुल टाइम बैक ऑफिस / डेटा एंट्री Job में बैक ऑफिस / डेटा एंट्री में 3 - 6+ वर्षो का अनुभव वाले उम्मीदवारों की जरुरत है।