MIS Executive / Junior Data Analyst

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.
• Good 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.