Job Description – MIS Executive Position
MIS Executive – Construction Operations
Location
Haldwani, Uttarakhand
Reporting To
Management / Operations Head
Job Summary
We are looking for a detail-oriented and analytical MIS Executive to manage project and operational data, prepare daily/weekly/monthly MIS reports, maintain management dashboards, and provide accurate information to management for effective decision-making.
The candidate will work closely with Site Engineers, Accounts and Procurement teams to collect, verify, analyse and present project-related information.
Key Responsibilities1. MIS & Reporting
- Prepare daily, weekly and monthly MIS reports for ongoing projects.
- Consolidate data received from different project sites.
- Prepare management reports covering:
- Project progress
- Planned vs actual work
- Project costs
- Material consumption
- Labour deployment
- Contractor performance
- Procurement status
- Billing and collection status
- Project profitability
- Ensure reports are accurate, timely and properly documented.
2. Project Performance Tracking
- Maintain project-wise trackers for 05-10 ongoing construction sites.
- Track project milestones, planned completion dates and actual progress.
- Highlight delays, cost overruns and other deviations to management.
- Maintain Plan vs Actual dashboards.
- Follow up with site teams for pending or incomplete data.
3. Excel & Data Analysis
- Develop and maintain advanced Excel reports and dashboards.
- Use formulas, Pivot Tables, Power Query, charts and other Excel tools for data analysis.
- Analyse trends and identify important variances.
- Automate repetitive reporting wherever possible.
- Maintain master databases and ensure data integrity.
4. Management Dashboard
- Maintain dashboards for senior management covering key KPIs.
- Provide concise insights rather than only presenting raw data.
- Prepare reports highlighting:
- Red – Critical Issues
- Amber – Attention Required
- Green – On Track
- Support management in identifying problem areas and taking corrective action.
5. Coordination with Sites
- Coordinate with Site Engineers and Project Managers to collect required information.
- Ensure daily site reports are received on time.
- Verify submitted data for completeness and consistency.
- Follow up on discrepancies and missing information.
6. Cost & Commercial MIS
- Assist in monitoring project budgets against actual expenditure.
- Track material, labour and subcontractor costs.
- Prepare project-wise cost statements.
- Track work orders, purchase orders, bills and payments.
- Assist management in monitoring project margins and profitability.
7. Documentation & Data Management
- Maintain organized records of project reports and MIS data.
- Maintain master files and databases.
- Ensure proper version control of reports.
- Maintain confidentiality of company and project information.
Required Skills
Must Have:
- Excellent knowledge of MS Excel.
- Good analytical and numerical skills.
- Strong attention to detail.
- Ability to work with large datasets.
- Good communication and coordination skills.
- Ability to meet reporting deadlines.
Preferred:
- Knowledge of Power BI / Looker Studio.
- Knowledge of Power Query.
- Experience in construction/project management MIS.
- Understanding of project costing and construction processes.
- Experience with ERP/accounting software such as MARG ERP or similar systems.
Qualification
- Graduate in B.Com, BBA, BCA, Mathematics, Statistics, Economics, Engineering or a related field.
- Additional certification in Advanced Excel / Power BI / Data Analytics will be an advantage.
Experience
2–5 years of experience in MIS, data analysis, project coordination or reporting.
Candidates with experience in the construction, infrastructure, real estate or engineering industry will be preferred.
Key Performance Indicators (KPIs)
The performance of the MIS Executive will be evaluated on:
- Accuracy of MIS reports
- Timeliness of report submission
- Data completeness from project sites
- Quality of management dashboards
- Identification of project deviations
- Reduction of manual reporting
- Accuracy of project cost and progress reports
- Responsiveness to management requirements
Ideal Candidate
The ideal candidate should be someone who does not merely prepare Excel sheets, but can understand the numbers, identify what is going wrong, and clearly communicate the issue to management.
The person should be comfortable working with multiple projects simultaneously and should have a strong ownership mindset, attention to detail and analytical approach.
Pay: ₹10,000.00 - ₹25,000.00 per month
Work Location: In person
