Key Responsibilities

- Prepare and maintain daily, weekly and monthly MIS reports related to loan disbursements, repayments, collections, overdue accounts, DPD, NPA and portfolio performance.
- Manage large datasets related to customers, loans, repayments, collections and credit bureau information.
- Prepare and validate data for regular submission to Credit Information Companies (CICs) such as:

- CIBIL / TransUnion CIBIL

- CRIF High Mark

- Experian

- Equifax
- Assist in preparation and submission of regulatory/RBI-related data and reports as required by the organisation.
- Ensure timely uploading of credit information and other required datasets on relevant portals.
- Perform data reconciliation between internal LMS/core systems, accounting records, bank/collection data and bureau submission files.
- Identify and rectify data discrepancies, missing records, duplicate entries and incorrect customer/loan information.
- Maintain proper records of all submissions, acknowledgements, corrections and resubmissions.
- Coordinate with Credit, Collections, Accounts, Operations, Compliance and Technology teams for data requirements and corrections.
- Generate management reports and dashboards to track key portfolio and operational metrics.
- Maintain proper data documentation, trackers and audit trails for regulatory and internal requirements.
- Support data extraction and transformation from LMS/LOS/CRM and other internal systems.
- Assist in responding to internal/external audit requirements related to MIS and data reporting.
- Continuously improve existing MIS formats and reporting processes through automation and standardisation.





Required Skills

Must Have:

- Strong knowledge of MS Excel Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IF functions, conditional formatting, data validation, filtering and data cleaning.
- Valuable understanding of MIS preparation and reporting.
- Ability to work with large datasets with a high level of accuracy.
- Strong data reconciliation and analytical skills.
- Experience in preparing/uploading data on CIBIL, CRIF, Experian, Equifax or similar platforms will be highly preferred.
- Good understanding of loan/credit data, DPD, overdue, repayment and customer-level loan information.
- Strong attention to detail and ability to meet strict reporting deadlines.
- Good communication and coordination skills.

Good to Have:

- Basic knowledge of SQL.
- Exposure to Power BI / dashboarding.
- Knowledge of NBFC/Lending MIS.
- Experience working with LMS/LOS/CRM systems.
- Familiarity with RBI/regulatory reporting requirements.
- Basic understanding of data automation using Excel/Power Query.

Candidate Profile We are looking for someone who is:
- Highly detail-oriented and comfortable handling financial/credit data.
- Strong in Excel and data management.
- Comfortable working with repetitive but accuracy-critical regulatory reporting.
- Able to independently prepare reports and identify inconsistencies in data.
- Comfortable coordinating with multiple departments to resolve data issues.
- Capable of working under monthly/periodic reporting deadlines.
- Interested in developing into a Data Analyst / MIS Manager / Regulatory Reporting professional within the NBFC/financial services sector.

📌 MIS Executive / Junior Data Analyst (Pune)
🏢 Mayur Deep Ornaments
📍 Pune