Data Analyst

About You:
You are a high achiever looking to thrive in a fast-paced environment. You take pride in your own work but are comfortable collaborating with a team of highly motivated individuals. You can communicate clearly and concisely with teammates and clients, and you enjoy strong company culture and camaraderie. You can navigate multiple corporate functions, including global lines of service and corporate centers of excellence. You possess strong interpersonal skills and are willing to take on diverse tasks to achieve the team's common goal. You value personal and professional growth and are ready to take the next step in advancing your career.

If this sounds like you, well, then you will love the culture at Avison Young

About Us:
Avison Young is a global commercial real estate brokerage and advisory firm, offering transaction, management, financial and consulting services. We've designed our corporate structure to best serve our clients by enhancing collaboration across our organization.

Real estate can have an enormous positive impact on people's lives – and we're in the business of making spaces and places work better for people. Our purpose is to create real economic, social and environmental value as a global real estate advisor, powered by people.

We care about each other and we have each other's backs. This makes Avison Young a great place to be a client, and a great place to work. We support the whole person and their complete wellness – economic, mental and physical – because what's best for our business comes from our people bringing their whole selves to work.

Of course we love it here, but outsiders think we're pretty great too Avison Young has been recognized as one of Canada's Best Managed Companies for the 13th year in a row, with a Platinum Club designation 

As a Data Analyst, you will be part of the Market Intelligence team and responsible for maintaining, validating, manipulating, and analyzing data and data processes within our Avison Young Technology platforms. This includes the management of real estate data, as well as real estate adjacent data. Position entails daily and weekly data tasks, data sprints that support regional teams, as well as national product goals, in addition to longer term projects aimed at enhancing the platform through data. The technical expertise in data storage structures, data mining, and data cleansing you provide to the Marke Intelligence team will enable the group to provide data-driven decisions to internal and external stakeholders.

The base salary is aligned with market data and is estimated between $50,000 to $55,000. Within this range, individual pay is determined by work location and other factors, including relevant education/training, experience, and internal equity.

*This contract role will cover an 12-month maternity leave*

• Regularly inputting data into our proprietary database and analytics platform. This includes lease and sales availabilities, lease comps, sales comps, company data and more.
• Reviewing ThoughtSpot dashboards and Availability Manager daily and ensure that core real estate data recently added to platform including properties, images, documents, companies, leases, sales and availabilities appear complete, consistent, high quality and are displaying correctly.
• Actively monitor and track the real estate market for relevant data which includes new developments, deals, availabilities, tenant activity, trends and infrastructure projects that will be used to provide market intelligence.
• Conduct a variety of advanced searches (availability, vacancy/sale, tenant information, transaction information, title information, zoning/planning restrictions, demographics, etc.) utilizing internal and external resources.
• Reading, abstracting and adding data from industry specific websites, newsletters and publications and company and investor websites, newsletters, public filings and investor presentations
• Updating status of properties under construction and enhancing data on property, tenants and ownership
• Adding/updating data on platform utilizing publications, public filings, public records and third-party data providers
• Execute and optimize SQL queries within Snowflake to validate data accuracy and ensure alignment with business logic and reporting requirements

• Bachelor's Degree required
• 1+ year experience in commercial real estate or real estate course work preferred
• Passionate about cities and real estate
• Must be able to handle flexibility in task management while having a keen eye for detail 
• Advanced knowledge of Microsoft excel
• Working knowledge of SQL for data querying and transformation, and Python for data manipulation, automation, is preferred

Avison Young practices as an equal opportunity employer in all services locations around the world.  We are committed to building and maintaining a workforce diverse in experience, skills and knowledge with uniformity in service excellence, commitment and integrity. 

The firm maintains a strict policy to ensure employment opportunities are equal and do not discriminate based on race, color, religion, creed, age, sex, gender, gender identity or expression, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, protected veteran or military service status, or any other elements protected by law.

Avison Young welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates during the recruitment process. For those requiring assistance, information relating to the need for accommodation and accommodation measures will be addressed confidentially. 

Avison Young is committed to employing the best talent with the most fair and equitable recruitment practices. Apply with us TODAY