Sr Tax Data Analyst

<strong style="color: inherit; font-style: normal; text-align: start; text-indent: 0">GENERAL STATEMENT OF DUTIES</strong><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0">Position is responsible for professional and technical expert data analysis of residential, commercial, industrial, and land property appraisal data. The Sr Tax Data Analyst provides validation of data, reporting, trend analysis, sales analysis, review of and publishing of data as needed to be used in the appraisal and appeal systems.</p><br><strong style="color: inherit; font-style: normal; text-align: start; text-indent: 0">DISTINGUISHING FEATURES OF THE CLASS</strong><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0">An employee in this class is responsible for the collection, analysis, validation of data, data analytics and reporting of appraisal work in support of the determination of the monetary value of residential, commercial, industrial, and land properties in the county.  Work involves gathering data from various sources like CAMA, Power BI, City/County planning, permits, government websites, and market information from other locations where the data may be available. Creates reports to communicate tax data, develops analytical models and provides timely accurate analysis to influence and inform decision makers. Role requires strong technical abilities in managing and analyzing large amounts of data, understanding relationships between various databases and ability to identify discrepancies or variations. Considerable independent judgment and initiative must be exercised in correctly evaluating a wide variety of data. Assists Appraisal division in maintaining appraisal neighborhoods in preparation for countywide reappraisals. Reviews market data and sets new values for countywide reappraisals. This position does not exercise supervision of staff.  This position reports to the Assistant Tax Director. Work is performed under limited supervision and is reviewed for compliance with current departmental appraisal methods and procedures.</p><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0"><strong style="font-weight: 700">DUTIES AND RESPONSIBILITIES</strong></p><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0"><strong style="font-weight: 700">Essential duties and responsibilities include, but are not limited to:</strong></p><ul style="padding-left: 2rem; margin-top: 0; margin-bottom: 3pt; color: inherit; font-style: normal; text-align: start; text-indent: 0"><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Uses Power BI to design, build and test interactive dashboards, integrating with new data sources to visualize property tax data and trends.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Build and optimize queries to extract and analyze data from appraisal and tax management systems. </div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Gather and validate property data from various sources to include property records, sales data and SQL database tables.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Review data from reports on the Appraisal System to develop values to be used in reappraisals and to identify patterns that may impact property values and tax revenues to inform policy decisions and tax strategies</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Implements quality control measures to ensure that data used for tax assessments complies with relevant regulations and standards, minimizing errors and discrepancies in property valuations. </div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Identify weaknesses in appraisal data that may affect reappraisal outcomes, proactivity addressing issues to enhance data integrity.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Assists in developing appeal presentations for the Board of Equalization & Revie, BOCC & other entities</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Prepare comprehensive reports on property valuations and tax assessments, effectively communicating findings to senior tax management, Budget, DOR, and individual jurisdictions.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Assists in training staff on software changes.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Assist in developing schedule of values for reappraisals.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Keeps abreast of the reappraisal and ongoing work cycles to plan and facilitate upcoming data analysis needs.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Identifies holes or weaknesses in the appraisal data that may be affecting reappraisal outcomes.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Identifies potential new data sources for elements like water/sewer, traffic counts, contamination sites, and zoning plans that may assist with the valuation of property.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Produces data files for the statistician employed by the County to improve valuation modeling.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Provides quality control over the sale records through analysis of the data and review of the business processes.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Assists with development, testing, and quality control of the CAMA software. Assists with documentation and staff training as needed.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Assists the Assessor in producing appraisal reports and maps for the public and the County Commissioners.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Discusses appeals with taxpayers, providing supporting documents to reach resolution.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Respond to help requests on technical issues from appraisal staff.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Performs other duties as assigned.</div></li></ul><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0"><br></p><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0"><strong style="font-weight: 700">RECRUITMENT STANDARDS</strong></p><span style="color: inherit; font-style: normal; text-align: start; text-indent: 0; text-decoration: none"><strong style="font-weight: 700">Knowledge, Skills, and Abilities</strong></span><ul style="padding-left: 2rem; margin-top: 0; margin-bottom: 3pt; color: inherit; font-style: normal; text-align: start; text-indent: 0"><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Advanced skills on Excel are required for use in analyzing data.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Advanced knowledge of GIS relationship to real estate appraisal.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Knowledge of real estate, tax and statutes.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Knowledge and ability to use on-line meeting platforms such as MS Teams.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Ability to communicate effectively orally and in writing; Ability to read and interpret deed descriptions and maps.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Ability to compose presentations using PowerPoint for Board of E&R meetings.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Ability to relate GIS software applications to enhance understanding of sales information.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Ability to establish and maintain effective working relationships with other employees.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Ability to work with databases, build queries and reports.</div></li><li><div style="margin-top: 0; margin-right: 0; margin-bottom: 0">Ability to gather and work with large amounts of data.</div></li></ul><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0"><strong style="font-weight: 700">MINIMUM QUALIFICATIONS</strong></p><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0">Bachelor’s degree in Business Administration, Data Science/Data or Business Data Analytics, Accounting, Finance, GIS or related degree and five years of experience in real estate appraisal including commercial real estate OR Associates’ degree in Business Administration, Data Science/Data or Business Data, Accounting, Finance, GIS or related degree and seven years of experience in real estate appraisal including commercial real estate OR High School Diploma or G.E.D. and nine years of experience in real estate appraisal including commercial real estate. </p><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0"><br></p><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0"><strong style="font-weight: 700">Preferred Qualifications:</strong> </p><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0">Experience in the appraisal of commercial, industrial, residential properties and experience with mass appraisal. Experience working with Power BI, CAMA, NCPTS, Excel and/or creating data dashboards and writing SQL queries. </p><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0"><br></p><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0"><strong style="font-weight: 700">Special Qualifications:</strong> </p><p style="margin: 0; color: inherit; font-style: normal; text-align: start; text-indent: 0">Must be able to obtain certification as a real property appraiser from the NC Department of Revenue within one year of employment.</p><p style="margin: 0"><br></p><p style="margin: 0"><br></p><span style="text-decoration: none"><strong style="font-weight: 700">Physical Demands and Work Conditions</strong></span><ul style="padding-left: 2rem; margin-top: 0; margin-bottom: 3pt; margin-left: -0.25in"><li>Must possess the visual acuity to prepare and analyze data and statistics, operate a computer terminal, and use measuring devices; may perform repetitive motions.</li><li>Must be able to exert up to 20 pounds of force occasionally, and/or up to 10 pounds of force frequently, and/or a negligible amount of force constantly to move objects. </li><li>Must be able to express or exchange ideas by means of the spoken word.  Those activities in which they must convey detailed or important spoken instructions to other workers accurately, loudly, or quickly.</li></ul><p style="margin: 0"><br></p><p style="margin: 0"><strong style="font-weight: 700">Driving is Essential </strong></p><p style="margin: 0">Driving is an essential requirement of this position whether driving a County owned or personal vehicle to conduct county business.  Motor Vehicle Reports may be verified for valid driver’s license and that the driving record is compatible with the county’s driving criteria. If a personal vehicle is operated for county business proper insurance is maintained as per Guilford County’s vehicle use policy. </p><p style="margin: 0"><br></p><p style="margin: 0"><strong style="font-weight: 700">Special Note: </strong></p><p style="margin: 0">This generic class description gives an overview of the job class, its essential job functions and recommended job requirements.   However, for each individual position assigned to this class, there is available a completed job description with physical abilities checklist which can be reviewed before initiating a selection process.  They can provide additional detailed information on which to base various personnel actions and can assist management in making legal defensible personnel decisions.</p>