Data Reporting Analyst (12-Month Contract)

GWL Realty Advisors; Toronto; On-site; CAD 63,000 - 94,000; Full time

Benefits offered by this job

3 weeks vacation

3 personal days per year

Half-day every Friday before a long;

Health benefits plan

Up to $5,000 annual mental health

Friendly, welcoming culture

Many social and team events

Job summary

GWL Realty Advisors in Toronto manages commercial and multi-residential real estate portfolios and seeks a data management and reporting professional to support consolidated financial statements, operating results, and budgeting across properties.

This role partners with the Manager, operations, asset management and accounting to deliver analytics, dashboards and insights; you will contribute to resource planning, variances, and capital reporting, while maintaining data accuracy and process

Qualifications

• 1–3 years in financial modeling and reporting, ideally in real estate.
• Advanced Excel and intermediate Power BI skills.
• Able to work with large data sets and under pressure.
• Yardi 7S experience is an asset; collaborative team player with an interest in real estate.

Responsibilities

• Maintain and update consolidated financial models and statements for the property portfolio.
• Generate weekly, monthly, quarterly and annual reports with variances and KPI insights.
• Partner with operations, asset management and accounting to support analyses and budgeting.
• Communicate results via visual dashboards and allocate shared expenses per management agreements.

Skills

Analytical skills

Data management

Financial reporting

Dashboard modeling

Problem solving

Education

Post-secondary education with accounting designation (asset)

Tools

Excel

Power BI

Yardi 7S

Job description

GWLRA is a leader in both the commercial and multi-residential real estate industries. We believe in generating value by creating vibrant, sustainable communities that engage, excite, and inspire. Our people live our values through the work they do and the results they deliver. Our core values are keeping our word, working better together and embracing diversity.

Responsibilities

Data Management and Reporting

• Maintain and update financial consolidation model producing consolidated financial statements for property portfolio
• Generate weekly, monthly, quarterly, and annual reports that include, among others, operating and capital results, vacancy and lease reports, pooled-cost expense allocations, and operations resource planning models
• Provide insight into financial variances and operating results

Modeling And Analysis

• Work closely with Manager to provide consolidated reporting and analysis and support ad hoc request
• Work closely with the Operations and Asset Management teams to provide data analytics to support business initiatives, business result improvements and strategic initiative decision support
• Work closely with operations team to support resource planning models and labour allocations including variance analysis

Collaboration + Business Partnering

• Support operations team and asset management team with reporting and analysis as required
• Support senior management requests for information and analysis
• Ability to communicate and share information in visual dashboard presentations
• Work with accounting team to allocate pooled expenses to applicable properties in accordance with management agreements
• Other duties as required

Requirements

• 1-3 years experience in financial modeling and reporting (ideally in real estate)
• Self-starter with exceptional analytical, data management, financial dashboard modeling and reporting skills including advanced knowledge of Excel and intermediate knowledge of Microsoft Power BI
• Ability to work with large amounts of data and work well under pressure
• Post-secondary education: accounting designation is an asset
• Accurate and detail-oriented; ability to interpret information and present it in simple manner; strong problem-solving skills
• Yardi 7S experience is an asset
• A collaborative team player with strong initiative and a passion for real estate

The base salary for this position is between $62,800.00 to $94,200.00 This represents base salary only and does not represent other variable compensation components of our total compensation (i.e. annual bonus, commission etc).

What We Offer

• 3 weeks of vacation per year
• 3 paid personal days per year
• Half-day every Friday before a long weekend
• A comprehensive health benefits plan that supports you and your family
• Up to $5,000 annual mental health coverage
• A friendly, welcoming, and supportive culture
• Many social and team events!

Our Business

Learn more about our commercial and residential businesses, our values, and careers at GWLRA.

Our Commitment to Diversity

GWL Realty Advisors is an equal opportunity employer. It prohibits discrimination based on age, color, disability, national origin, race, religion, gender, sexual orientation, and any other legally protected class in accordance with applicable federal, provincial and local laws. We are committed to creating and maintaining an inclusive and accessible workplace. If you are contacted for an interview and require accommodation during the interviewing process, please let us know.