16 Nov
|
Nathani Constructions
|
Raipur
16 Nov
Nathani Constructions
Raipur
- FMS and Google Sheets upkeep
- Run and monitor all FMS sheets: Leave, Hiring, Labour Kharchi, Material Indent, Vehicle Requirement and Unloading Charges.
- Track each step against its planned time and follow up with the person responsible when a step is delayed.
- Maintain Google Forms, sheet formulas and Apps Script automations; add new sites, staff and items as needed.
- Attendance and HR data
- Check the daily staff attendance (check-in, check-out, geo-tagged photo) and flag missing or late entries.
- Match leave requests against attendance and prepare the monthly attendance and leave report for HR and payroll.
- Keep the Staff Master updated with joiners, leavers and site transfers.
- Site reports
- Compile the daily site-wise labour count and the Weekly Machine Check responses.
- Follow up with site engineers when a site has not submitted its report by the cut-off time.
- Material, purchase and inventory data
- Enter purchase orders in the PO register and keep the site stock register (Inventory Master) current.
- Make sure every stock sheet uses the item codes from the Material Checklist.
- Billing and payment tracking
- Track contractor bills through checking and approval, and keep the urgent fund clearance log.
- Maintain a pending-payments and receivables list (client dues, retention) for the MD.
- MIS reporting and dashboards
- Prepare the daily MIS summary and weekly and monthly dashboards for the MD.
- Highlight exceptions: absenteeism, delayed FMS steps, stock shortages, overdue bills.
- Data quality and records
- Remove duplicate and wrong entries, standardise names and site names, and keep backups of key sheets.
- Control sheet access and keep records ready for audits and client submissions.
Reports and deliverables
Report
Frequency
Due by
Sent to
Daily MIS summary (attendance, labour count, FMS delays)
Daily
11:00 AM
MD
Site-wise labour report
Daily
12:00 PM
MD, GM-Projects
Pending FMS steps list
Daily
5:00 PM
Step owners, MD
Weekly machine check dashboard
Weekly
Monday
GM-Projects
Weekly attendance and late-arrival report
Weekly
Monday
HR, MD
Stock and material status by site
Weekly
Tuesday
Purchase, MD
Contractor bills and pending payments
Weekly
Saturday
Accounts, MD
Monthly attendance and leave report
Monthly
3rd of next month
HR, Accounts
Monthly MIS dashboard
Monthly
5th of next month
MD
Qualifications and skills
Education: Graduate in any discipline (B.Com, BBA, BCA, B.Sc preferred). A diploma or degree in Civil Engineering is an advantage.
Experience: 1–3 years in an MIS, data or back-office role, preferably in construction, infrastructure or manufacturing.
Must have
- Advanced Excel and Google Sheets: VLOOKUP/XLOOKUP, IF, SUMIFS, COUNTIFS, pivot tables, data validation, conditional formatting.
- Google Forms and Google Drive: building forms, linking responses, sharing and access control.
- Accurate, rapid data entry with attention to detail.
- Clear written and spoken Hindi and English for follow-ups by phone and WhatsApp.
Good to have
- Google Apps Script or basic macros to automate sheets.
- Looker Studio or Excel dashboards.
- Familiarity with construction terms: BOQ, RA bills, indents, labour reports.
- Basic knowledge of Tally or other accounting software.
Pay: ₹15,000.00 - ₹20,000.00 per month
Benefits
- Cell phone reimbursement
- Internet reimbursement
- Paid sick time
- Provident Fund
Work Location: In person
📌 MIS Executive (Raipur)
🏢 Nathani Constructions
📍 Raipur