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 agile 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
Solid 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 (India)
🏢 Housr
📍 India