- Job Title: Data Management Analyst
- Work Unit: Centralized Industrial Assessment CIA)/Linear Property Assessment (LPA) Assessment Services Branch
- Ministry: Alberta Municipal Affairs
- Competition Number: 1050122
The mandate of the Government of Alberta's Business Plan is to have a well-managed and efficient assessment and property tax system in which stakeholders have confidence. This position exists as part of a multidisciplinary team of professionals responsible for ensuring that the processes and procedures, described in the Municipal Government Act and its Regulations for the valuation of Designated Industrial Property (DIP) are applied uniformly and consistently. The area also ensures the reporting of this information to taxpayers and municipal stakeholders is of superior accuracy and quality.
The Data Analyst provides advice and assistance in the acquisition, management, manipulation, and analysis of data. The position also reports quality-assured information resulting from their analysis to their supervisor and relevant stakeholders including industry and other government offices. The Data Analyst ensures the integrity of data, analysis, assembly, interpretation, and reporting of designated industrial property assessment inventory and information.
Responsibilities and Activities
Provide accurate quantitative, graphical, and textual assessment Information stored in the proprietary internal applications.
- Investigate. Analyze, and solve reported data issues or errors and advise the team on the best course of action to comet the data. Research and/or investigate other external sources to validate data reported by stakeholders.
- Provide technical and analytical support for branch initiatives.
- Prepare reports, publications, briefings, and action requests to support the use of evidence in policy development.
- Maintain and administer processes and applications developed by senior analysts.
Produce property assessment notices and assessment rolls efficiently and on time.
- Prepare, review and analyze stakeholder Request For Information (RFI) submissions for compliance and content.
- Review and evaluate the Municipal Government Act (MGA) and Designated Industrial Property Assessment Guidelines relative to legislated assessment requirements.
- Provide advice and assistance in the evaluation of the property assessment valuation models.
- Make changes to property assessment valuation model SAS programs to adjust for cost calculation factors and other changes.
- Review and include updates to the Minister's Guidelines related to Assessment and Property Tax Policy (APTP) changes or changes in the Alberta Energy Regulator (AER) and Alberta Utilities Commission (AUC) codes, information, or data structures.
- Contribute to assessment notice dry (mock assessment) runs.
Support the ongoing review and QA of assessment data.
- Conduct sensitivity and impact analysis as a result of a Municipal Government Board (MGB) decision or an Order in Council assessment's jurisdiction change.
- Review and compare property assessments to determine trends, movement, utilization, and variances in the data.
- Support Senior Analyst/s to develop, maintain and run the current applications such as allocation application, SAS MSP program applications, etc.
- Communicate issues and potential resolutions of data as necessary.
- Research on variances and obtain supporting data.
- Assist Senior Analyst/s with refresh testing and quality assurance testing of the assessment rolls/notices, browser testing etc. as required.
Collaborate with internal and external stakeholders in support of positive working relationships.
- Communicate and develop working relationships with industry representatives to improve the quality of reporting and the annual Request for Information (RFI) process.
- Advise stakeholders inquiring about Property Assessment Notices, Property Assessment Rolls, RFIs and relative legislation/regulation issues.
- Assist in the coordination, preparation of information, and presentation of stakeholder education and information seminars on Designated Industrial Property.
- Liaise with or advise municipalities on Designated Industrial Property assessment issues that may impact their assessment base.
The position exercises judgement when gathering internal and external data and then converting the data into meaningful information and reports in support of Designated Industrial Property assessment. The position is a full working level professional determining how objectives are achieved.
A major challenge of this position is to combine 'data management expertise with software programming expertise in an environment of changing priorities and time constraints. Other challenges include:
- providing data management expertise in reading and interpreting data model/entity relationship diagrams and in creating data management system tables and views;
- finding internet site(s) or establishing data contacts for related information;
- exercising good judgment and utilization of strong interpersonal skills to co-work with software development and maintenance vendor(s) (e.g. CGI);
- analyzing and developing solutions to existing data issues or new data requirements.
Knowledge, Skills and Abilities
Formal Education/Courses and Experience:
- The position requires a related undergraduate degree in Computer Science, Management Information Systems, Information Technology, Mathematics, Engineering, Geospatial Sciences, or an equivalent combination of education and experience augmented by SAS software certification (Base and/or Advanced). Equivalencies will be considered. Experience with industry such as oil, gas, electric power system/generation, telecommunication and/or designated industrial property fields such as machinery and equipment, railway, farm land, building, land etc. as well as courses and certifications related to ESRI, ArcGIS and project management are an asset.
- The position requires working level to intermediate computer knowledge including database management system (e.g. Oracle), expert knowledge of SAS, Microsoft Access, Excel spreadsheets, and communications software. Knowledge of OIS software and project management is an asset.
- An understanding of all the industries associated with designated industrial properties.
- The position requires a working knowledge of legislation and regulations surrounding property assessment and taxation with particular emphasis on designated industrial properties.
- Knowledge in the area of property assessment and taxation is an asset.
Skills and Abilities:
- Ability to ensure service and quality meet agreed upon timelines and deliverables in agreements and the ability to ensure quality checks performed on data files and obtain peer-review where required.
- Proven ability demonstrating significant communication skills (both written and verbal) within a team environment including ability to provide regular, frequent, and concise status reporting on multiple and concurrent projects:
- Experience in data mining techniques, procedures and their appropriate use.
- Technical expertise regarding data models and database design development. Strongly required for SAS Base Certification and recommended for SAS Advanced Certification.
- Knowledge of geospatial data management and the ArcGIS environment (including intermediate knowledge of Python) is recommended.
- Proficiency in MS Office software (Word, Excel, Access, and PowerPoint).
- Ability to present complex information in an understandable and compelling manner.
The position requires contact with a wide range of both internal and external stakeholders such as: owners/their representatives, municipal councils. municipal assessors, municipal and industrial stakeholder associations such as the Alberta Urban Municipalities Association (AUMA), Alberta Association of Municipal Districts and Counties (AAMD&C), Alberta Assessors' Association (AAA), Canadian Property Tax Association (CPTA), Canadian Association of Petroleum Producers (CAPP), National Energy Board (NEB), Alberta Utilities Commission (AUC) and the Alberta Energy and Utilities Board (BUB).
The position works with members of the unit in preparing assessment and advice to internal and external stakeholders (Minister, senior department officials, and officials from other ministries, municipal officials, industrial officials and general public).
The Government of Alberta is committed to a diverse and inclusive public service that reflects the population we serve to best meet the needs of Albertans. Consider joining a team where diversity, inclusion and innovation are valued and supported. For more information on diversity and inclusion, please visit the Diversity and Inclusion Policy.