We are looking for a detail-oriented and analytical MIS Executive with strong proficiency in Advanced Microsoft Excel to manage, analyze, and report critical business data. You will be responsible for maintaining data accuracy, building automated dashboards, and delivering timely daily, weekly, and monthly reports that drive strategic decision-making across departments.
Required Technical Skills (Advanced Excel)
- Advanced Formulas & Functions: Expert-level command over XLOOKUP, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IFERROR, OFFSET, INDIRECT, and dynamic array formulas.
- Data Summarization & Visualization: Mastery of Pivot Tables, Pivot Charts, Slicers, Timelines, Conditional Formatting, and energetic charting techniques.
- Data Transformation & Automation: Hands-on experience with Power Query (ETL), Power Pivot (DAX basics), and VBA / Macros for report automation.
- Additional Tools (Preferred):
Working knowledge of SQL, Google Sheets, MS Access, or BI tools like Power BI / Tableau is a strong advantage.
Qualifications & Soft Skills
- Education: Bachelor’s degree in Commerce (B.Com), Business Administration (BBA), Computer Applications (BCA), Statistics, Economics, or a related field.
- Analytical Mindset: Strong numerical aptitude with the ability to translate raw numbers into actionable business insights.
- Attention to Detail: High level of accuracy when handling large datasets under strict deadlines.
- Communication: Ability to coordinate effectively with multiple stakeholders to gather data and explain report findings clearly.
Pay: ₹15,000.00 - ₹25,000.00 per month
Work Location: In person
📌 MIS Executive (Advanced Excel Specialist) (Kanpur)
🏢 MY CAR
📍 Kanpur