Position: MIS Executive – Accounts Department
Industry: Construction
Department: Accounts & Finance
Location: Gota, Ahmedabad
Reporting To: Accounts Manager / Finance Manager
Job Summary
We are seeking a detail-oriented MIS Executive to support the Accounts Department by preparing accurate reports, maintaining financial data, and assisting in analysis using advanced Microsoft Excel. The ideal candidate should have strong Excel skills, excellent analytical ability, and experience handling accounting-related MIS reports in a construction environment.
Key Responsibilities
- Prepare daily, weekly, and monthly MIS reports for the Accounts Department.
- Maintain and update financial data in Excel and ERP/accounting software.
- Reconcile data related to invoices, payments, receivables, and project expenses.
- Generate reports on project-wise costs, vendor payments, and budget tracking.
- Analyze financial data and identify discrepancies.
- Coordinate with project teams and the accounts department to ensure timely data collection.
- Create dashboards, summaries, and management reports.
- Ensure data accuracy, confidentiality, and timely reporting.
- Support internal and external audit requirements by providing MIS reports.
Required Skills
- Strong knowledge of Microsoft Excel, including:
- Pivot Tables
- VLOOKUP/XLOOKUP
- HLOOKUP
- INDEX & MATCH
- IF, SUMIF, COUNTIF functions
- Good understanding of accounting concepts.
- Experience with ERP/accounting software (Tally, Busy, SAP, or similar) is an advantage.
- Strong analytical and problem-solving skills.
- Excellent attention to detail and time management.
Qualification
- Bachelor's degree in Commerce (B.Com), BBA, or a related field.
Experience
- 2–5 years of experience in MIS reporting, preferably in the construction or infrastructure industry.
Preferred Candidate Profile
- Experience handling project-wise accounting reports.
- Ability to work with large datasets and meet reporting deadlines.
- Good communication and coordination skills.
- Proactive, organized, and capable of working independently.
Pay: ₹18,000.00 - ₹25,000.00 per month
Work Location: In person
