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>

Back to blog

Other Jobs To Apply

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...