Functional Analyst I - Loudoun County Government : Job Details

The Commissioner of the Revenue is one of Loudoun's five elected constitutional officers. Our mission is to serve citizens and the business community by administering tax programs mandated by the Code of Virginia and local ordinance in a manner that is efficient, fair, equitable, and thorough, while protecting the confidential personal and business information entrusted to the office. The Loudoun County Office of the Commissioner of the Revenue is seeking qualified applications for the position of Functional Analyst. The Functional Analyst will play a crucial role within our technology team, addressing a wide range of technical challenges to support our TAX Assessment and CAMA (Computer assisted mass appraisal). The Functional Analyst should have previous experience as a SQL Data Analyst, experience managing complex programs, databases and enterprise systems and identify business requirements and translate them into functional system capabilities. This position will work closely with colleagues, developers, testers and a variety of end users to ensure technical compatibility and user satisfaction across Loudoun Countys tax assessment and commercial mass appraisal (CAMA) systems. Responsibilities include, but are not limited to: Manage complex programs, databases, and systems. Support department staff, vendors, and IT teams by analyzing workflows and assisting in the development of manual and automated systems. Maintain expertise in County-standard software and provide guidance on departmental usage. Contribute to strategic planning for automation and system integration. Collaborate with Senior Systems Analysts and Project Managers to develop scopes of work, project plans, and timelines. Prepare reports, maps, data models, and analyses to support initiatives. Analyze system data using business rules and SQL queries to identify discrepancies. Develop and maintain queries, worksheets, and reports; compile program data; maintain an inventory of reports and manage information distribution. Oversee software and system testing using functional QA methods to ensure data integrity, governance, and process adherence. Document bugs, defects, and process gaps. Create and maintain quality assurance documentation for all releases. Develop technical and user documentation, including database diagrams, application overviews, and step-by-step guides. Create training manuals tailored to both novice and advanced users. Manage information security as the Department Application Security Administrator. Maintain and audit user access for internal and external applications and ensure accurate access records are kept. Provide advanced technical support and collaborate with peers to resolve complex technical issues. Hiring salary will be commensurate with experience. Requires any combination of education and experience equivalent to a Bachelors degree Computer Science, Information System Management, or related field; three (3) years of related experience in computer technology, programming, design, development, database management, and/or administration preferably in a government environment. Requires the ability to communicate effectively in both oral and written forms (explain technical concepts in non-technical terms to individuals and groups); research and resolve inquiries; demonstrate initiative; and work independently with minimum supervision. Preferred Qualifications Proven experience as a SQL Data Analyst with proficiency in SQL programming and database management systems (e.g., SQL Server, MySQL). Experience with SQL Server Reporting Services (SSRS) or similar reporting tools. Familiarity with data visualization tools such as Power BI. Knowledge of database optimization techniques and performance tuning. Certification in SQL Server or relevant technologies. Previous experience with RBS My Revenue System, IasWorld, CAMA systems, Oracle, or SQL in the financial, construction, or appraisal industries is preferred. Familiarity with Virginia local tax structures. One (1) year of supervisory experience preferred. Successful candidate will undergo criminal background, credit and DMV record checks. Must maintain a valid drivers license in Virginia or regional state of residence. Must be familiar with Microsoft Office applications. Must have the ability to tour commercial facilities of all types. Familiarity with business operations in Loudoun County or local tax compliance experience is preferred. All applicants seeking employment with the Office of the Commissioner of the Revenue are expected to comply with tax obligations. Failure to do so could impede consideration of your application. #J-18808-Ljbffr