MIS Executive

Job Description: MIS Executive – Underwriting Team

Position: MIS Executive / MIS Analyst

Department: Underwriting

Location: Delhi

Reporting To: Underwriting Lead

Role Overview

The MIS Executive will support the Underwriting Team by managing data flows,

preparing accurate and timely reports, monitoring key metrics, improving data

quality, and providing analytical insights that help optimize underwriting decisions,

productivity, and compliance.

Key Responsibilities

1. Reporting & Dashboard Management

 Create, maintain, and automate daily/weekly/monthly underwriting MIS

reports.

 Prepare dashboards on productivity, decisioning, TAT, approval/rejection

trends, CPV status, and profile-based decisions.

 Ensure report accuracy by validating data from multiple systems (LMS, LOS,

CRM, CPV tracker, document collection tools, etc.).

2. Data Management & Process Automation

 Extract, clean, and structure large data sets using Excel/Google Sheets/SQL.

 Automate repetitive reporting tasks using formulas, scripts, or BI tools.

 Maintain data dictionaries and ensure consistent data definitions across the

team.

3. Underwriting Support

 Track file movement: Lead Creation → CPV Initiation → Doc Collection →

UW Decision → Disbursal/Reject.

 Monitor CPV TAT, missing-docs cases, profile deviations, return cases, and

rework trends.

 Support underwriters with quick data pulls to assist decision-making.

 Highlight anomalies such as same-day CPV initiation, cases without CPV

initiation, missing field verifications, etc.

4. Analytics & Insights

 Analyse trends in approval rates, rejection reasons, risk flags, repeat

applicants, and policy-based rejects.

 Identify bottlenecks in the underwriting workflow (e.g., call attempts dropping,

low doc collection, pending CPV).

 Provide insights to policy teams on process gaps and decision patterns.

5. Stakeholder Coordination

 Work closely with Underwriters, Policy Team, Ops Team, CPV vendors, and

Product/Tech.

 Share scheduled and ad-hoc reports with cross-functional teams.

 Maintain strong follow-ups to ensure data readiness for audits and

compliance.

6. Audit & Compliance Support

 Prepare files and MIS required for internal/external audits.

 Track adherence to underwriting guidelines and highlight non-compliance.

 Maintain audit trails and ensure version control of reports.

Skills & Qualifications

Education

 Graduate/Postgraduate (Preferred: Commerce, Business Analytics, Statistics,

or relevant field).

Technical Skills

 Advanced Excel/Google Sheets (Pivot, VLOOKUP/XLOOKUP, Array formulas,

Query, Automation).

 Basic to intermediate SQL preferred.

 Knowledge of BI tools (Power BI, Tableau, Looker Studio) is an advantage.

 Understanding of underwriting metrics and loan lifecycle.

Core Competencies

 Strong analytical and logical thinking.

 High attention to detail and data accuracy.

 Ability to handle multiple reports under tight deadlines.

 Problem-solving mindset with a process-improvement approach.

 Strong communication and coordination skills.

Experience

 1–4 years of MIS/Data Analyst experience (preferably in underwriting, credit,

risk, or lending operations).

 Experience in NBFC/Fintech underwriting processes is a strong advantage.

Key Performance Indicators (KPIs)

 Accuracy and timeliness of reports.

 Reduction in manual reporting efforts.

 Insights that improve approval % and reduce rework/rejects.

 TAT adherence for all MIS deliverables.

 Stakeholder satisfaction .