Financial Analyst II – Housing Financial & Business Strategy

The Financial Analyst II position is responsible for providing development analytics to optimize the use of the City’s real estate assets, supporting the development of a transformative business & financial strategy for the City’s real estate portfolio, and conducting complex business case analyses to influence high-profile business decisions.

Requirements

• Post-graduate degree in Finance or Economics, and/or CA or CFA designation
• Extensive experience in real estate or asset management
• Experience in deployment of SOTP, DCF & ABC methodologies; real estate acquisition & business case due diligence (pre-M&A) highly advantageous
• Exceptional Excel skills (advanced aggregation modelling (SOTP, ABC), DATA Tables, Goal Seek, Pivot Tables, etc.)
• Superior analytical skills, a data-driven mindset with excellent problem-solving skills
• Advanced Dashboarding, Data Visualization & Data Extraction experience (SAP, VBA, Cliq Sense, Power BI, QlikView, Tableau etc.) highly advantageous
• Impeccable track record of converting raw data into optimization strategies
• Ability to identify issues, gather data and develop solutions
• Ability to ‘connect the dots’ and understand and apply broad corporate context in individual tasks
• Critical thinking, ability to analyze complex situations and determine appropriate courses of action where there is little or no precedent
• Strong sense of accountability, take considerable initiative in leading and completing assignments, and take ownership of challenges to the point of resolution
• Ability to work independently with high degree of maturity, experience and sophistication
• Embrace and encourage team work, collaboration and intellectual curiosity
• Strong verbal and written communication skills, ability to effectively convey complicated analyses to senior management through reports and/or presentations

Benefits

• Comprehensive health and dental benefits
• Retirement plan
• Paid time off