| About our client |
| Our client is a leading property management firm. |
| Position |
Location |
| Corporate Analyst (MS Excel (Macros) /Access –Specialist) |
Toronto (Downtown), Ontario |
| Salary |
| $45K to $55K |
| Responsibilities |
1) To design and manage a central database of all
mortgage information (Using Excel Macros and Access) and assist the finance team
with monthly, quarterly and annual reporting.
2) Calculate effective interest rate and weighted average term to maturity for mortgage portfolio on a monthly basis (and other information as part of the mortgage package)
3) Calculate the fair value of mortgages on a quarterly basis
4) Ensure the validity and integrity of mortgage information with the underlying general ledger accounts
5) Calculate ratios and financial covenant tests (MFT, SIFT, interest coverage, etc.)
6) Assist the Finance Team with the preparation of quarterly analysis relating to the MD&A and financial statements
7) Calculate ratios by property and by lenders on a quarterly basis
8) Provide mortgage information required for financial statements and management discussion and analysis (MD&A)
9) Prepare quarterly reporting to banks
10) Calculate potential mortgage top-ups under various scenarios
11) Assist the Finance Team in preparation for auditors (including but not limited to preparing analytics)
12) Calculate sensitivity analysis for note disclosure to financial statements
13) Handle annual reporting to lenders and CMHC
14) Perform other duties and projects as assigned by the management |
| Requirements |
1) CMA/CGA designation (actively pursuing)
2) Financial/mortgage experience
3) Excellent communication skills (written and oral)
4) Good time management and organization skills
5) Superb computer skills including advanced macros for MS Excel and Access
6) Ability to independently analyze and resolve problems
7) Detail oriented and self-motivated with ability to take the initiative to learn new skills and enhance overall knowledge |
|
 | |
