MIS Executive (Management Information System Executive)
Posted 4
views
Summary
MIS Executive in Ahmedabad who collects, consolidates, and analyzes project and business data, builds Excel-based trackers and dashboards, produces MIS/management reports, and monitors KPIs while coordinating with teams like Survey, GIS, Finance, and HR. Core tools: advanced MS Excel and Power BI.
The MIS Executive will be responsible for collecting, analyzing, maintaining, and reporting project and business data to support management decision-making. The role requires strong expertise in MS Excel, data management, reporting, dashboard preparation, and coordination with various departments for timely and accurate information.
Responsibilities Data Management Reporting
- Collect, compile, and maintain project, operational, and business-related data.
- Prepare daily, weekly, monthly, and quarterly MIS reports.
- Generate management reports and performance dashboards.
- Consolidate data received from various departments and project sites.
- Ensure accuracy, consistency, and completeness of data records.
- Monitor project progress and prepare status reports for management review.
- Prepare client-specific reports as per contractual requirements.
Excel Database Management
- Develop and maintain Excel-based MIS trackers and dashboards.
- Utilize advanced Excel functions such as VLOOKUP, HLOOKUP, Pivot Tables, XLOOKUP, Charts, Conditional Formatting, and Data Validation.
- Maintain project databases and ensure timely updates.
- Perform data analysis and identify trends, gaps, and performance indicators.
- Generate automated reports and improve reporting efficiency.
Project Coordination Support
- Coordinate with Survey, GIS, Liaison, Finance, HR, and Operations teams for data collection.
- Track project milestones, deliverables, approvals, and timelines.
- Maintain records of work orders, invoices, project progress, and client communications.
- Support management in project planning and resource allocation through data analysis.
Documentation Compliance
- Maintain digital records and project documentation.
- Ensure proper filing and archiving of reports and project data.
- Prepare presentations and summaries for management meetings.
- Assist in audits and internal reviews by providing required reports and records.
Performance Monitoring
- Monitor key performance indicators (KPIs) across projects.
- Identify data discrepancies and coordinate corrective actions.
- Provide actionable insights through data analysis and reporting.
- Support management in strategic decision-making processes.
Requirements - Collect, compile, and maintain project, operational, and business-related data.
- Prepare daily, weekly, monthly, and quarterly MIS reports.
- Generate management reports and performance dashboards.
- Consolidate data received from various departments and project sites.
- Ensure accuracy, consistency, and completeness of data records.
- Monitor project progress and prepare status reports for management review.
- Prepare client-specific reports as per contractual requirements.
Excel Database Management
- Develop and maintain Excel-based MIS trackers and dashboards.
- Utilize advanced Excel functions such as VLOOKUP, HLOOKUP, Pivot Tables, XLOOKUP, Charts, Conditional Formatting, and Data Validation.
- Maintain project databases and ensure timely updates.
- Perform data analysis and identify trends, gaps, and performance indicators.
- Generate automated reports and improve reporting efficiency.
Project Coordination Support
- Coordinate with Survey, GIS, Liaison, Finance, HR, and Operations teams for data collection.
- Track project milestones, deliverables, approvals, and timelines.
- Maintain records of work orders, invoices, project progress, and client communications.
- Support management in project planning and resource allocation through data analysis.
Documentation Compliance
- Maintain digital records and project documentation.
- Ensure proper filing and archiving of reports and project data.
- Prepare presentations and summaries for management meetings.
- Assist in audits and internal reviews by providing required reports and records.
Performance Monitoring
- Monitor key performance indicators (KPIs) across projects.
- Identify data discrepancies and coordinate corrective actions.
- Provide actionable insights through data analysis and reporting.
- Support management in strategic decision-making processes.
- Graduate in Commerce, Computer Applications, Statistics, Mathematics, Business Administration, or related field.
- BCA, B.Sc. (IT), B.Com, MBA, or equivalent qualification preferred.
- Certification in Advanced MS Excel, MIS, Data Analytics, or Power BI will be an added advantage.
- BCA, B.Sc. (IT), B.Com, MBA, or equivalent qualification preferred.
- Certification in Advanced MS Excel, MIS, Data Analytics, or Power BI will be an added advantage.
Apply for this Role
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.