The Collection MIS (Management Information System) Executive is responsible for managing, analyzing, and reporting data related to the collections process. This role ensures that collection activities are monitored effectively, trends are identified, and actionable insights are provided to improve collection efficiency. The individual will work closely with the collections team & internal stakeholders to ensure accurate and timely reporting.
What youll be doing:
Data Management & Reporting:
- Collect, compile, and maintain accurate data related to collections from various sources.
- Prepare daily, weekly, monthly, and ad-hoc reports on collection performance, outstanding payments, recovery rates, and other key metrics.
- Develop dashboards and visualizations to present data in a clear and actionable format.
Performance Monitoring:
- Track and analyze collection KPIs & Identify trends, patterns, and areas of concern within the collection data.
- Preparing & presenting Collection PPT slides to the management.
- Automate repetitive tasks and develop tools/templates to enhance reporting efficiency.
- Ensure compliance with internal policies and external regulations in all reporting activities.
- Collaborate with cross-functional teams such as finance, sales, and operations to gather relevant data and align on collection strategies.
Technical Skills:
- Proficiency in MS Excel (advanced level), including pivot tables, VLOOKUP, macros, and data visualization tools.
- Experience with reporting tools such as Power BI, Tableau, or similar platforms.
- Familiarity with ERP systems (e.g., SAP, Oracle) and CRM software.
-
Analytical Skills:
- Strong ability to analyze large datasets and extract meaningful insights.
- Attention to detail and accuracy in data management and reporting.
- Ability to prioritize tasks and meet deadlines in a fast-paced environment.
What youll need:
-
- 4-6 years of experience in MIS reporting, preferably in a collections or finance-related role. Experience with MS Office & excel is a must.
- Knowledge of financial concepts and collection processes is an advantage
- Experience with automation tools (e.g., VBA, Python, Power BI) is a plus.