Mis Executive

Karara Impex; New Delhi; On-site; INR 350,000 - 650,000; Full time

Job summary

Karara Impex in Delhi seeks a meticulous MIS Analyst to prepare and maintain daily to monthly reports, consolidating data from Excel, Google Sheets, and trackers.

You will design automated dashboards, troubleshoot formulas, coordinate with Sales, Purchase, Accounts, and Operations, and document reporting processes. Strong Excel/Sheets skills and attention to accuracy are essential.

Qualifications

• Bachelor's degree in Commerce/Accounting/IT or related field.
• Proficient in advanced Excel; PivotTables, VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS.
• Experience consolidating data from multiple sources (Excel, Google Sheets, trackers).
• Ability to design automated dashboards and reporting systems.
• Strong data accuracy and troubleshooting formulas (#REF!, #VALUE!, #N/A).
• Excellent cross-functional coordination with Sales, Purchase, Accounts, Operations.
• Strong documentation of formulas and reporting processes.
• Training others on MIS formats and reporting systems.

Responsibilities

• Prepare and maintain daily, weekly, fortnightly, and monthly MIS reports.
• Consolidate data from multiple Excel files, Google Sheets, and trackers.
• Develop advanced Excel/Google Sheets systems with Pivot Tables, VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, etc.
• Design automated dashboards, trackers, and interconnected reporting systems.
• Identify and resolve data discrepancies, duplicates, missing information, and reporting errors.
• Troubleshoot broken formulas and errors (#REF!, #VALUE!, #N/A).
• Review reporting processes and implement improvements and automation.
• Manage data consolidation, migration, validation, access control, and backups.
• Coordinate with Sales, Purchase, Accounts, Operations to collect data.
• Follow up with teams for missing, incomplete, or delayed information; escalate when needed.
• Ensure 100% accuracy and timely submission of reports.
• Maintain documentation of formulas, reporting logic, processes, and system structures.
• Train employees on MIS formats, reporting systems, and new processes.

Skills

MIS reporting

Excel expertise

Google Sheets

Pivot Tables

VLOOKUP/XLOOKUP

INDEX-MATCH

Data consolidation

Automation

Cross-functional coordination

Documentation

Training

Error troubleshooting

Education

Bachelor's degree in Commerce/Accounting/IT

Tools

Excel

Google Sheets

Importrange

ARRAYFORMULA

Job description

• Prepare and maintain daily, weekly, fortnightly, and monthly MIS reports for management.
• Consolidate data from multiple Excel files, Google Sheets, and departmental trackers into accurate and structured reports.
• Develop and maintain advanced Excel/Google Sheets systems using Pivot Tables, VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIF, FILTER, IMPORTRANGE, ARRAYFORMULA, and inter-sheet linking.
• Design automated dashboards, trackers, and interconnected reporting systems to reduce manual work.
• Identify and resolve data discrepancies, duplicates, missing information, and reporting errors.
• Troubleshoot broken formulas and errors such as #REF!, #VALUE!, and #N/A using a systematic approach.
• Review existing reporting processes and implement process improvements and automation wherever possible.
• Manage data consolidation, migration, validation, access control, and backup systems.
• Coordinate with Sales, Purchase, Accounts, Operations, and other departments to collect accurate and timely data.
• Follow up with respective teams for missing, incomplete, or delayed information and escalates unresolved issues when required.
• Ensure 100% accuracy and timely submission of management reports.
• Maintain proper documentation of formulas, reporting logic, processes, and system structures.
• Train relevant employees on MIS formats, reporting systems, Excel/Google Sheets, and newly implemented processes. Role & responsibilities