Geoffrey Mcewen

Geoffrey Mcewen Email and Phone Number

Real Estate Appraiser | Business Intelligence analyst | Data analytics | Data Reporting @ City of Calgary
calgary, alberta, canada
Geoffrey Mcewen's Location
Calgary, Alberta, Canada, Canada
Geoffrey Mcewen's Contact Details

Geoffrey Mcewen work email

Geoffrey Mcewen personal email

About Geoffrey Mcewen

I am an analyst with 10 years progressive experience in asset valuation. I use data analytics (SQL, R, Python, VBA, PowerBI and SPSS) and big data for real-estate appraisal. Currently I am working as an intelligence analyst on a multi-year project replacing our core database system. Prior to this I specialized in commercial appraisal, working on large office buildings and large retail centres at different times. The new system is web-based enabling remote work whileOn my own initiative I taught myself several programming languages (R, Python, SQL, VBA) and created tools which are in widespread use throughout the business today. Some of these tools have seen ten years of continuous use and improvement. For example, an early work on my own initiative was converting a complicated paper-based form for amending valuations to an electronic form with built-in logic. The new form immediately reduced the number of email chains between managers and employees requesting additional info or needing clarification from several per week to almost none.I am constantly looking for ways to improve the business. Asides from the tools I have developed I have been in many other projects ranging from small ad-hoc data analysis to large year-long team efforts. Some of these have been things like a review of how parks affect the valuation of the houses around them, a project that resulted in a 2% drop in the standard deviation of those houses valuation. I do not work in isolation. From the beginning I identified a group of like-minded innovators and, with myself as a "founding" member, we have formed an informal team. This small community of practice bounces ideas off each other, troubleshoots, and helps everyone develop new ideas and communicate them out. This team has done things like build a second parallel modelling process for a portfolio to validate our traditional model. I enjoy being part of an energetic and forward looking team. We have been so successful we have enjoyed formal recognition and resources, while trusted enough to leave self-managed.I have also helped develop people, mentoring 10 new hires as they came on board as the most senior data analyst at the time. Some of these people have gone on to join the innovation group mentioned above, while others have moved up elsewhere in the business.Finally there is my formal education. Asides from two undergraduate degrees (B.Sc Physics and B.A Economics) I have completed a Master's in Finance, one level of the CFA, and a Certificate in Real Property Appraisal.

Geoffrey Mcewen's Current Company Details
City of Calgary

City Of Calgary

View
Real Estate Appraiser | Business Intelligence analyst | Data analytics | Data Reporting
calgary, alberta, canada
Website:
calgary.ca
Employees:
7063
Geoffrey Mcewen Work Experience Details
  • City Of Calgary
    Assessor
    City Of Calgary Jun 2018 - Present
    Calgary, Canada Area
    I have spent the last four years working on updating our core database and modelling system, working with stakeholders to createdevelopment requirements, identify fit-gaps and defects, and adapt business processes.I did process analysis, policy analysis, and SQL database design forall core business functions. One example of many, I guided the GIS (mapping) team in integrating the GIS server and third-party data pulls with our database. This was not mechanically churning out code, my role was to give understanding of how the data was used in actual financial analysis, and helping design the presentation to users.Users have created many of their own tools for our database. I am leading a team in recreating these tools/dashboards to work with the new system. For instance, four teams have programmed PowerBI dashboards to help organize their work.
  • The City Of Calgary
    Assessment Data Officer
    The City Of Calgary Sep 2015 - Jun 2018
    Calgary, Canada Area
    I co-founded the data analytics and reporting group. We had many projects, one of which was developing an improved report for identifying sales which did not fit the model, monitoring changes in the portfolios, and enabling collaboration between team members. The report and its descendants have been heavy in use for over 7 years and currently have 4 teams using them.
  • The City Of Calgary
    Assessment Assistant
    The City Of Calgary May 2013 - Aug 2015
    Calgary, Canada Area
    I cleaned, verified, and entered real-estate and leasing data for a portfolio of downtown and core commercial real estate.

Geoffrey Mcewen Skills

Microsoft Office Data Analysis Public Speaking Statistics Research Social Media Time Management Visual Basic For Applications Sql

Geoffrey Mcewen Education Details

Frequently Asked Questions about Geoffrey Mcewen

What company does Geoffrey Mcewen work for?

Geoffrey Mcewen works for City Of Calgary

What is Geoffrey Mcewen's role at the current company?

Geoffrey Mcewen's current role is Real Estate Appraiser | Business Intelligence analyst | Data analytics | Data Reporting.

What is Geoffrey Mcewen's email address?

Geoffrey Mcewen's email address is ge****@****ail.com

What schools did Geoffrey Mcewen attend?

Geoffrey Mcewen attended University Of Aberdeen, University Of Calgary, St. Francis Xavier University.

What skills is Geoffrey Mcewen known for?

Geoffrey Mcewen has skills like Microsoft Office, Data Analysis, Public Speaking, Statistics, Research, Social Media, Time Management, Visual Basic For Applications, Sql.

Who are Geoffrey Mcewen's colleagues?

Geoffrey Mcewen's colleagues are Heidi Bilben, Jennifer Johnson, Nasser Umar, Csm, Pmp, Sonny Leonel Magarro, Durairaj Mohanraj, Jesse Aylward, Anusha Anusha.

Not the Geoffrey Mcewen you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.