Job Description

Contact No : 91578 08887 (Prashant)

Designation : MIS - Executive

Experience : 3 to 5 Yrs.

Location : Ahmedabad - Panchvati

CTC : Up to 5 LPA

- MIS Executive (Insurance Broking Company)

Key Responsibilities:

Prepare, maintain, and circulate daily/weekly/monthly MIS reports for business performance. Consolidate data related to policy issuance, renewals, claims, endorsements, and cancellations. Generate dashboards to track premium collections, brokerage income, and pending cases. Support sales and operations teams with branch/channel-wise performance reports. Maintain accurate records for regulatory reporting (IRDAI, GST, compliance audits). Analyze variances in targets vs. actuals for different business verticals (Life, General, Health, Motor). Coordinate with insurers and internal teams for reconciliation of premium and brokerage data. Maintain data accuracy, confidentiality, and adherence to audit requirements.

Key Skills:

Advanced MS Excel (Pivot Tables, VLOOKUP, HLOOKUP , XLOOKUP, Conditional Formatting , Count IF , Sum IF, Count IFS, Sum IFs, Data Duplicity ). Strong analytical and numerical ability. Good communication and coordination skills.
Job Type: Full-time

Pay: ?25,000.00 - ?40,000.00 per month

Work Location: In person