MIS Executive

MIS Executive

Wercatalyst Ventures Pvt Ltd

Surat, Gujarat

Job Summary

Wercatalyst Ventures Pvt Ltd seeks a proficient MIS Executive to handle data analysis, report

generation, and insights for logistics operations. This role leverages advanced Excel for

process optimization and decision support, following MNC standards for accuracy and

efficiency.

Key Responsibilities

• Prepare MIS reports using advanced Excel functions like VLOOKUP, HLOOKUP,

PivotTables, charts, and data validation for HR, operations, and finance metrics.

• Conduct data analysis, trend identification, reconciliations, and dashboard creation to

support management decisions and performance tracking.

• Automate reporting processes, clean datasets, and collaborate with teams for timely

data-driven insights and ad-hoc analysis requests.

Required Qualifications & Experience

• Bachelor’s degree in commerce, IT, or related field (B.Com/BBA); 1-3 years in

MIS/reporting, preferably in logistics/services.

• Location: Ahmedabad; reports to Finance/Operations Manager. Full-time, Mon-Sat.

Essential Skills & Competencies

• Advanced Excel mastery (VLOOKUP, HLOOKUP, PivotTables, INDEX-MATCH,

Power Query, slicers) for complex data manipulation and visualization.

• Proficiency in data analysis, report automation, and tools like Google Sheets or basic

Power BI/Tableau.

• Strong analytical mindset, attention to detail, accuracy, and ability to handle large

datasets under deadlines.