MIS Executive (Management Information System Executive)

Aimn Projects; Ahmedabad District; In loco; INR 400.000 - 700.000; Tempo pieno

Descrizione del lavoro

Aimn Projects is seeking an MIS Executive to collect, analyze, and report project and business data to support management decisions. The role requires strong Excel skills, data management, dashboarding, and coordination with multiple departments for timely information.

The ideal candidate will maintain MIS trackers, generate daily to quarterly reports, ensure data accuracy, and assist in audits and presentations for management reviews.

Competenze

• Graduate in Commerce, CA, Statistics, Mathematics or related field.
• BCA, BSc(IT), B.Com, MBA preferred.
• Certification in Advanced MS Excel, MIS, Data Analytics, or Power BI will be an added advantage.

Mansioni

• Collect, compile, and maintain project, operational, and business data.
• Prepare daily, weekly, monthly, and quarterly MIS reports.
• Generate management reports and dashboards.
• Coordinate with Survey, GIS, Finance, HR and Operations for data collection.
• Maintain digital records and project documentation; assist audits.

Conoscenze

MS Excel

Data analysis

Dashboarding

Reporting

Data management

Formazione

Bachelor's degree in Commerce, Computer Applications, Statistics, Mathematics, Business Administration

Strumenti

Power BI

Excel

Descrizione del lavoro

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

• 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.