Appraisal Institute of Canada

Find an


Posted: 2019/04/11
Member type: Any
Employment type: Permanent Full Time
Province: Ontario
Closing Date: 2019/04/25
Website: View Website
Contact Email: ac.ca1555841975pm@sr1555841975eerac1555841975

Job Description:

Annual Salary: $65,339

The Municipal Property Assessment Corporation, Assessment Standards and Mass Appraisal branch in the Valuation and Assessment Standards department requires five (5) Data Analysts to conduct mass appraisal analysis and provide support in the determination of values for real properties within assigned market area or property type. The successful incumbents will also support the development and maintenance of computer mass appraisal systems, geospatial and mass appraisal analytics.


Mass Appraisal of Real Property

·        Develop valuation parameters using industry standard computer assisted mass appraisal (CAMA) techniques applying the direct comparison approach to value for assigned market areas and property types;

·        Apply valuation parameters to appropriate corporate database and valuation system to value the universe of properties in assigned market area and property type;

·        Identify the supply and demand factors that impact the value of real property through statistical analysis, reviewing local economic indicators, other geographical and spatial data;

·        Reconcile market rates for individual property features to ensure consistency with appraisal theory and market indicators;

·        Edit programming code (e.g., SPSS, R, Python) to document market analysis, maintain and create analytical data and associated output files;

·        Identify sales and property data for review, data cleansing and further validation by valuation staff;

·        Conduct and interpret sales ratio studies to ensure valuation parameters produce value conclusions that meet established internationally recognized standards and municipal service level agreements;

·        Evaluate the performance of valuation parameters using techniques that may include but are not limited to goodness- of-fit measures, hold-out samples, residual analysis or spatial analysis;

·        Identify and correct any systematic bias in values prior to application of analysis to value the universe of properties;

·        Review value estimates for the universe of properties at a macro or micro level for any further systematic bias and take corrective action as required;

·        Prepare narrative reports for internal and external use (e.g., Market Valuation Reports) as well as public information and reports for ratepayers under the Information and Data Sharing Policy and Freedom of Information (FOI) Programs; and,

·        Provide support for status update presentations to municipal officials on activities relating to mass appraisals and property values, respond to municipal inquiries relating to mass appraisals, and affected incentive programs.

Maintenance of Current Property Values

·        Extract and prepare sales database from corporate databases;

·        Value new parcels (e.g., urban plans of subdivision, condominiums) by reviewing sales data, property information, determining appropriate valuation approach, and developing and applying new market rates to the CAMA system;

·        Ensure new parcels are valued correctly by assigning proper valuation neighbourhoods and required site information is identified for Land Parcelization Unit (LPU) staff;

·        Perform quality checks on property data and value estimates for new parcels to ensure corporate quality standards have been met, identify issues, and develop recommendations to resolved;

·        Work with LPU and field office staff to ensure values for new parcels are activated; and,

·        Provide status updates on current projects and timelines.

Valuation Systems

·        Support research initiatives into ways to improve and enhance existing valuation systems and data, leveraging open source technologies and advanced spatial and mass appraisal analytics;

·        Analyze moderately complex issues and provide technical assistance in support of new and existing valuation systems including code writing (Python, R, etc.), documentation, debugging and testing using JSON/GeoJSON etc.; and

·        Maintain high quality and well-documented code following best practices ensuring that quality attributes (performance, scalability, extensibility) are met;

·        Maintain technical specifications for components, systems, sub-systems and valuation services, technical system documentation and templates; and,

·        Execute unit test strategies to validate design against business and performance requirements, platform interoperability and architectural standards.

Technical Support and Guidance

·        Respond to enquiries from internal staff, external clients and stakeholders to provide technical guidance and advice and regarding valuation system issues and determine source and scope of concern;

·        Provide ad-hoc technical one-on-one coaching to staff on mass appraisal techniques and tools including statistical and geographic information system software packages; and,

·        Liaise with internal staff and legal counsel in order to provide support in the preparation for appeals involving the mass appraisal process, interpreting sales ratio studies, and other statistical interpretations.


Location:  Location to be determined upon the close of the competition



·        Completion of post-secondary education in a related field;

·        A minimum of 3 years of progressively responsible combined experience in at least one of the following areas:  computer assisted mass appraisal and valuation; multiple regression and statistical analysis; data analytics and computer programming;

·        Progressing towards, or completion of, an appraisal designation/certificate such as UBC Real Property Assessment, Certificate, Member Institute of Municipal Assessors (MIMA), Accredited Appraiser Canadian Institute (AACI), Certified Assessment Evaluator from the International Association of Assessment Officers (CAE - IAAO), Mass Appraisal Specialist (MAS – IAAO) or Member, Royal Institution of Chartered Surveyors (MRICS) is an asset;

·        Knowledge and experience in the application of various valuation tools including data collection manuals, corporate databases and valuation systems, spatial analysis, and MPAC policy and procedures;

·        Knowledge of property valuation processes, policies and procedures, appraisal techniques and approaches to value, and familiarity with MPAC technology-based products and services;

·        General knowledge of market and economic factors affecting value across all affected property types;

·        Basic knowledge of property assessment and taxation-related legislation;

·        General understanding of ad valorem appraisal techniques and theory of the approaches to value for residential, farm/residential, and farm properties;

·        Demonstrated research, analytical, problem solving, and logic skills to undertake comprehensive market analysis associated with mass appraisal process and systems;

·        Proficient use of various software programs and databases including statistical, geospatial software programs (SPSS, R, Python, ArcView, QGIS), Microsoft Office (e.g. Word, Excel, PowerPoint), and databases including SQL and NoSQL;

·        Good verbal and written communication and interpersonal skills to effectively  prepare and communicate detailed valuation reports, briefing notes, and responses to client inquiries; and,

·        Good knowledge of statistics and probability, particularly their application in systems analysis and operations research.


AREA OF SEARCH:  Open           

To apply to this posting, click here. Please use the Applicant Tracking System to create your Candidate Profile, upload your Resume and Cover Letter and apply to the posting by April 25, 2019.  Please note, only applications submitted through the Applicant Tracking System will be accepted.

While MPAC thanks all applicants for their interest, only those under consideration will be contacted for interviews.  Please be advised successful incumbent(s) who are not presently permanent MPAC employees may be required to undergo a criminal and drivers abstract check. By applying to this job posting, you are also providing your consent to MPAC to share your name, email address and phone number with Mintz Global Screening (Mintz), a third party service contracted by MPAC, to conduct the criminal and driver abstract check and for Mintz to disclose the results to MPAC, should you be the successful incumbent.


The Municipal Property Assessment Corporation (MPAC) is an independent, not-for-profit corporation funded by all Ontario municipalities. Our role is to accurately assess and classify all properties in Ontario, and with more than 1,700 employees in offices across the province, our assessors are trained experts in the field of property valuation. At MPAC, we know that maintaining work life balance is the key to fostering employee health, happiness and productivity. We offer generous vacation allowances, a self-funded leave program and flexible work arrangements to help ensure employees’ unique needs are met both at work and at home. For more information visit or


In accordance with the Ontario Human Rights Code, Accessibility for Ontarians with Disabilities Act, 2005, and MPAC's Accessibility Standards for Ontarians with Disabilities Policy, accommodation will be provided in all parts of the hiring process. Applicants need to make their needs known in advance.

Job advertisements for positions that have been designated bilingual will be posted in both English and French on our website. Positions that are not designated bilingual are not translated and are only posted in English on the English version of our website.