Key Responsibilities
- Prepare, maintain, and deliver accurate daily, weekly, monthly, and annual MIS reports within defined timelines.
- Manage ad hoc reporting requests from various business functions, providing timely and actionable insights to support decision-making.
- Develop, automate, and optimize MIS reports and trackers using advanced Microsoft Excel and Google Sheets functionalities.
- Design and maintain interactive dashboards, performance trackers, and data visualization reports for management review.
- Ensure data integrity through regular validation, reconciliation, and quality checks across multiple data sources.
- Analyze large datasets to identify trends, patterns, KPIs, and business opportunities, and present meaningful insights to stakeholders.
- Collaborate with cross-functional teams to understand reporting requirements and implement scalable reporting solutions.
- Maintain comprehensive documentation of reports, data sources, reporting logic, and standard operating procedures (SOPs).




- Support process improvement initiatives by identifying opportunities to automate manual reporting and enhance operational efficiency.

Required Skill
- Solid proficiency in
Microsoft Exce
l and
Google Sheet
s
- Expertise in advanced Excel functions, including
XLOOKUP, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, FILTER, SORT, UNIQUE, IF/IFS, TEXT function
s, and
Pivot Table
s
- Hands-on experience in building dynamic dashboards using Pivot Tables, charts, slicers, and advanced formulas
- Working knowledge of
Google Apps Scrip
t or VBA for report automation is an added advantage
- Strong analytical, problem-solving, and numerical aptitude with exceptional attention to detail
- Ability to work with large datasets, ensure data accuracy, and deliver reports under tight deadlines
- Excellent communication and stakeholder management skills with the ability to understand business reporting requirements
- Strong organizational skills with the ability to manage multiple prio

📌 Management Information System Executive (Gurugram)
🏢 Housr
📍 Gurugram