Loan Portfolio Analyst

The Loan Administration department is responsible for the management of loan portfolio including customer services, payment processing, calculating loan amortization schedules, amending existing loans, calculating early payoffs, and post-closing collateral and insurance management to name a few. This is a specialized position that offers an excellent opportunity to learn and develop valuable skills in various positions within the department as you will be cross-trained for all three functions - Loan Administration, Portfolio and FP&A.

Responsibilities:

• Manage the integrity of loan records within the loan administration system: including data entry and auditing.
• Provide administrative support for the department as it relates to Loan Administration, Portfolio Analytics or FP&A modeling tasks.
• Prepare Portfolio performance reports, developed by KPI and trend analysis
• Prepare monthly deck reporting, delinquency reports, overall loan status reports and terminal IRR reports.
• Conduct periodic review and analysis of underwriting expectations post-funding: categorize exception distribution, rationale and justifications; issue monthly executive-level exception reports to validate compliance with the underwriting policy and procedure.
• Provide comprehensive historical datasets to feed FP&A reports.
• Support the development of a multi-layer structured Portfolio Modelling and Forecasts creation.
• Provide supportive reports such as, break-even, scenario-based and modelling reports.
• Analyze and audit monthly financial results and update those in ongoing modelling phase.
• Conduct monthly forecast-actual analysis and prepare Executive reports for explaining discrepancies.
• Audit exiting Financial Models for accuracy, functionality, reporting, simpleness and transparency perspective with other FP&A principles.
• Support financial and functional due diligence requests for corporate transactions.
• Prepare cash flow forecasts and various long-term financial and statistical projections for strategic planning.
• Build annual budgets and forecasts for different business units and consolidate them into a master budget.
• Other projects and duties as assigned.