Executive - MIS

Zebronics India Pvt Ltd; Chennai District; On-site; INR 350,000 - 650,000; Full time

Job summary

Zebronics India Pvt Ltd in Chennai seeks an experienced MIS Executive to analyze Sales, Service, Inventory and Management data and automate reporting processes using Advanced Excel and VBA.

The role focuses on preparing MIS reports, dashboards and templates, ensuring data accuracy, and coordinating with Sales, Service, Warehouse and Logistics teams to deliver timely insights. 2–5 years' MIS experience and fluency in Hindi, Tamil, and English are required.

Qualifications

• 2-5 years of relevant experience in MIS, Reporting, Business Operations, Sales MIS, or Service MIS.
• VBA & Macro Automation experience is mandatory.
• Hindi, Tamil, and English language proficiency is mandatory.

Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports for Sales, Service, Inventory, Logistics, and Management.
• Develop automated reports, trackers, dashboards, and templates using VBA and Macros.
• Handle large volumes of data and ensure accuracy, consistency, and timely reporting.
• Perform data analysis using Advanced Excel, Pivot Tables, VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, and Conditional Formatting.
• Consolidate data from multiple departments and prepare management reports.
• Track and monitor sales performance, service data, inventory, stock movement, logistics, pending reports, and targets/achievements.
• Coordinate with Sales, Service, Warehouse, Logistics, and other teams to collect and validate data.
• Identify data discrepancies and ensure timely correction.
• Automate repetitive MIS processes and improve reporting efficiency.
• Prepare customized reports and dashboards as required by management.

Skills

Advanced Excel

Data Analysis

Pivot Tables

VLOOKUP/XLOOKUP

Dashboard Creation

Data Validation

Attention to Detail

Time Management

Problem-Solving Skills

Process Automation

Coordination Skills

Tools

VBA

Excel Macros

CRM Tools

Job description

We are looking for an experienced MIS Executive with strong expertise in Advanced Excel, VBA, and Macro Automation. The candidate will be responsible for handling and analyzing Sales, Service, Inventory, and Management data, preparing MIS reports, and automating reporting processes to improve efficiency and accuracy.

Required Skills

Advanced Excel, Excel Macros (VBA), MIS Reporting, Data Analysis, Pivot Tables, VLOOKUP/XLOOKUP, Dashboard Creation, Data Validation, CRM Tools, Attention to Detail, Time Management, Problem-Solving Skills, Process Automation, Coordination Skills

Detailed Description

Role & responsibilities:

• Prepare and maintaindaily, weekly, and monthly MIS reportsfor Sales, Service, Inventory, Logistics, and Management.
• Developautomated reports, trackers, dashboards, and templates using VBA and Macros.
• Handle large volumes of data and ensure accuracy, consistency, and timely reporting.
• Perform data analysis usingAdvanced Excel, Pivot Tables, VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, and Conditional Formatting.
• Consolidate data from multiple departments and prepare management reports.
• Track and monitorsales performance, service data, inventory, stock movement, logistics, pending reports, and targets/achievements.
• Coordinate with Sales, Service, Warehouse, Logistics, and other teams to collect and validate data.
• Identify data discrepancies and ensure timely correction.
• Automate repetitive MIS processes and improve reporting efficiency.
• Prepare customized reports and dashboards as required by management.

Preferred candidate profile:

• 2 - 5 yearsof relevant experience in MIS, Reporting, Business Operations, Sales MIS, or Service MIS
• VBA & Macro Automation experience is mandatory.
• Hindi, Tamil, and English language proficiency is mandatory.

Learn more about working with us and our company culture.

Applications typically reviewed within 5-7 business days.

Similar Positions

Service SER-04-ST-SE-CHN-020

Service Trainee

Repair and rework of Defective/Malfunctioning Electronic products.