Looking for a company with over 50 years of success and no signs of slowing down?

If so, Morguard may be the perfect place for you.

As one of Canada’s leading real estate companies, with properties across North America, we’re proud of our history and excited about our future.

Our Purpose
At Morguard, people are at the centre of everything we do. We are committed to creating lasting value not only for our clients and communities, but for our employees as well. As a fully integrated real estate organization, we offer exposure to a diverse portfolio that includes office, industrial, retail, and multi‑suite residential properties across North America. Our team reflects a wide range of backgrounds, perspectives, and experiences, and we believe that diversity strengthens us.

Collaboration fuels our success. Through innovation, teamwork, and a shared commitment to sustainability, our professionals are empowered to build their careers, contribute meaningfully, and help shape the future of real estate.

Putting Our Purpose into Action
We support our people by offering:

• Access to experienced subject matter experts who provide mentorship and hands‑on learning.

• A wide range of career opportunities across the organization.

 Where You’ll Add Value

We are seeking a highly motivated Summer Student (Intern) with a strong interest in advanced Excel and data automation to support the modernization of legacy Excel files. This position lasts up to six months and sits within the Reporting & Analytics. The primary focus is upgrading older Excel workbooks to Microsoft Excel 365, with the aim of improving scalability, usability, and performance while ensuring that existing business logic is maintained. This opportunity is ideal for a student who enjoys problem-solving, structured data work, and process improvement.

How You’ll Make a Difference

Excel Modernization & Optimization

• Review and rework legacy Excel files that utilize older Excel functionality, such as Excel 2003 formulas.

• Replace outdated or hard-coded formulas with modern Excel 365 functions and more user-friendly approaches.

• Enhance file scalability, transparency, and maintainability, while ensuring that business outcomes remain unchanged.

VBA Review & Cleanup

• Read, understand, and refactor existing Excel VBA macros.

• Clean and optimize macro code while preserving the original intent and output.

• Identify opportunities to reduce reliance on VBA by utilizing Excel 365 features or Power Query when appropriate.

Power Query & Data Structuring

• Use Power Query and Excel Tables to streamline data sourcing and transformation processes.

• Contribute to standardizing data structures across files to minimize redundancy and errors.

• File Documentation & Dependency Tracking

• Document all changes made to files, including updates to formulas and structural modifications.

• Identify and track links between files, including dependencies that span across folders.

• Assist in identifying primary keys and connection logic used by formulas to improve consistency and uniformity.

Exposure to Data Systems & Validation

• Gain practical experience with systems such as Yardi, Yardi Data Connector (YDC), and SQL Server for data validation and sourcing.

• Support basic validation of Excel outputs by comparing results with system-generated data.

• Obtain exposure to Power BI for reporting and data modeling

• Use of AI & Productivity Tools - effectively leverage AI tools, such as Copilot, to assist with formula conversion, code review, documentation, and efficiency improvements

 The Expertise You’ll Bring

• Current enrollment in a post-secondary program related to Computer Science, Data Analytics, Finance, Accounting, Engineering, or a similar field.

• Strong working knowledge of Microsoft Excel, including advanced formulas.

• Ability to understand and analyze existing spreadsheets and the logic behind them.

• Comfortable working independently, demonstrating a high level of attention to detail.

• Strong documentation and organizational skills.

Core Competencies

• Current enrollment in a post-secondary program related to Computer Science, Data Analytics, Finance, Accounting, Engineering, or a similar field.

• Strong working knowledge of Microsoft Excel, including advanced formulas.

• Ability to understand and analyze existing spreadsheets and the logic behind them.

• Comfortable working independently, demonstrating a high level of attention to detail.

• Strong documentation and organizational skills.

Preferred Qualifications and Experience

• Experience or exposure to Excel VBA, with the ability to read and interpret macros.

• Familiarity with Power Query and Excel Tables.

• Basic understanding of databases, SQL, or relational data concepts.

• Exposure to Power BI.

• Familiarity with Yardi or similar ERP systems is considered an asset.

• Demonstrated ability to use AI tools productively for analysis and development.

Why You’ll Love Working at Morguard
At Morguard, we’re committed to creating an environment where our people can thrive. Here’s what you can expect when you join our team:

• A collaborative, inclusive workplace culture that prioritizes employee wellbeing and safety.

• Meaningful opportunities for professional growth and development.

• Exposure to a diverse portfolio of real estate assets across North America.

• Support for work–life balance, along with accessible employment practices that meet AODA requirements.

Inclusive by Nature
Diversity is one of our greatest strengths. At Morguard, we provide equal employment opportunities to all candidates and do not discriminate on the basis of race, color, religion, gender, sexual orientation, age, disability, or any other legally protected status. We believe in creating a workplace where everyone has the opportunity to grow, contribute, and make an impact.

Commitment to Accessibility
Morguard is dedicated to maintaining accessible employment practices in accordance with the Accessibility for Ontarians with Disabilities Act (AODA). If you require accommodation at any stage of the recruitment process, please contact Human Resources—our team is here to support you. Please contact Human Resources at (905) 281-3800.