Sales Data Analyst (TS24)
This Sales Data Analyst establishes real market value of real property in Benton County. Real Market Values are developed through a yearly project of statistically analyzing annual sales and other market data pertinent to the completion of the annual Assessor's Ratio Study, as required by State statute.
The Department of Assessment is responsible for the valuation of all real and personal property in Benton County as well as the calculation and extension of property taxes. As our Sales Data Analyst this position will have the opportunity to work independently while performing complex data extraction and analysis as well collaborative with the appraisal team, cartography and administrative staff. If you are a self-driven individual looking for a job that will challenge you with a variety of tasks, let you work independently and as a team, see the full job description listed below.
Compensation: $46,592.00 - $58,219.20 Annually
Sales Research, Data Analysis, and Calculation
- Prepares annual Ratio Study conforming to State statute.
- Compares previous Real Market Value with current sales to develop assessment ratios.
- Conduct yearly interviews with local contractors to determine cost increases or decreases associated with the external components of property development.
- Confirms unique sales through questionnaires, phone calls, and office interviews
- Reviews sales data for outliers, appraisal accuracy and unique attributes.
- Use statistical samples to perform multiple regression analysis and modeling.
- Establishes time adjustments, land values, depreciation tables, and local cost modifier schedules through sales data analysis and complex mathematical computations.
- Create review and set-up studies by writing SQL queries.
- Documents analysis decisions following established set up for ratio procedures.
- Updates valuation tables annually.
- Test valuation software upgrades and processes to assure accuracy. Troubleshoots issues and works with County technical staff and vendor for resolution.
- Performs multifaceted recalculation processes and transferring of property values from appraisal valuation system to tax administration system for annual tax roll completion.
- Extracts data for auditing reports and tracking progress by writing custom reports and performs studies linking criteria from the valuation software program into Excel and ArcGIS for special projects.
- Annually re-appraise all property types by on-site inspection. Properties may include residential dwellings, tracts of land, outbuildings, commercial and multi-family. Attributes such as style and quality of construction, property measurements, depreciation, land adjustments, income, cost, and other applicable information about the property is entered into the valuation system.
Public Relations and Customer Service
- Prepare and provide documentation internally and externally explaining ratio process, adjustments, and market movement throughout Benton County
- Assist property owners and other agencies on the phone, in the office or in writing responding to varied inquiries, which require a technical knowledge of assessment functions, procedures, ratio analysis, market sales data, assessed and real market values.
- Inspect and evaluate property to resolve valuation conflicts between taxpayers and the County Assessor's Office
- Compile appraisal data to support and defend the established real market value of real and personal property at the Board of Property Tax Appeals.
- Develop narrative appraisal reports, testimony and litigation strategy to present the case, or testify as an expert witness at Department of Revenue Hearings, Magistrate Court, and Regular Division Tax Court Appeals.
Continuing Education and Training
- Must maintain state required Appraisal Registration by successfully completing 30 hours of formal continuing education approved by the Department of Revenue.
- Attend technical education classes as needed or required.
- Provide internal training to appraisers and other staff as needed
- Work with the Department of Revenue, other county departments or other counties on technical teams or groups.
And other duties as assigned.
- Must have at least an Associates degree in Real Estate Technology, Business Administration, Finance, Economics, Math or related field; or Oregon Department of Revenue approved appraisal training program.
- At least 5 years of experience related to the essential duties of this position or a closely related field.
- Must be a Registered Appraiser through the State of Oregon per ORS 308.010 or have the ability to pass the test within 60 days of hire.
An equivalent combination of education and experience may be accepted.
The ideal candidates is an individual who meets or exceeds the listed minimum qualifications and will have a basic knowledge of Structured Query Language to extract data, the ability to understand and perform complex mathematical calculations and experience analyzing and manipulating data.
Physical requirements in the classification typically require: standing, walking on even or uneven surfaces such as concrete, dirt, grass, sloping, muddy, rocky ground. Working outdoors in heat, cold, rain, windy or muddy conditions. Ability to walk up and down stairs, ability to step over or around hazards such as nails or lumber, squatting, carrying boxes, reaching, talking, hearing, seeing. Ability to enter and exit a vehicle, driving a vehicle. Sedentary work typically requires repetitive motion using a keyboard, reaching and sitting.