Systems Analyst

1 month ago


Leesburg, United States Loudoun County Full time

Welcome and thank you for your interest in employment with Loudoun County Government

ALL SECTIONS OF THE APPLICATION MUST BE COMPLETED IN ITS ENTIRETY. THE RESUME IS CONSIDERED SUPPLEMENTAL INFORMATION ONLY. APPLICATIONS THAT ARE INCOMPLETE OR INDICATE 'SEE RESUME' WILL NOT BE TAKEN INTO CONSIDERATION.

Introduction

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. 

Job Summary

The Office of the Commissioner of the Revenue is seeking qualified applicants for the position of Systems Analyst.

The Systems 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 Systems Analyst should have previous experience as a SQL Data Analyst, possess exceptional skills in SQL data analytics, queries and reports essential for business operations and decision-making processes and will be involved in developing, writing and maintaining a multitude of SQL reports and queries.

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:
Write and optimize complex SQL queries to efficiently retrieve, manipulate, and aggregate data from databases. Ensure optimal query performance by understanding execution plans, indexing strategies, and database statistics.
Collaborate with stakeholders including business analysts, data scientists, and end-users to understand reporting requirements. Design and develop SQL-based reports using tools like SQL Server Reporting Services (SSRS), Power BI, or similar platforms.
Extract data from multiple databases or sources and transform it as necessary for reporting purposes. Perform data joins, apply business rules, and aggregate data to meet specific reporting needs.
Ensure the accuracy and reliability of data used in reports through thorough testing and validation procedures. Verify data integrity across different sources and ensure consistency in reporting outputs.
Deploy SQL-based reports to reporting servers (, SSRS), ensuring proper configuration and accessibility for end-users. Monitor and maintain existing reports to accommodate changing business requirements and data sources.
Monitor the performance of SQL queries used in reports. Identify opportunities for optimization, analyze query execution times, and monitor database server performance metrics. 

Hiring salary commensurate with experience. 

Minimum Qualifications

Requires any combination of education and experience equivalent to a bachelors degree with coursework in Computer Science, Management Information Systems or related field and 2 years of previous IT experience.

Preferred Qualifications
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.
Previous experience with IasWorld, CAMA systems, Oracle, or SQL in the financial, construction, or appraisal industries is preferred. Familiarity with Virginia local tax structures.
Proven experience as a SQL Data Analyst with a focus on report writing.
Strong proficiency in SQL programming and database management systems (, 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.
Excellent analytical and problem-solving skills with a keen attention to detail.
Ability to work collaboratively in a team environment and communicate effectively with stakeholders.
Certification in SQL Server or relevant technologies. 

Job Contingencies and Special Requirements

Successful candidates will undergo background checks to include criminal background, driving, and credit checks. Employees are prohibited from participating in any outside activity which may be deemed a conflict of interest by the Commissioner of the Revenue. All applicants seeking employment with the Office of the Commissioner of the Revenue are expected to comply with tax obligations. Failure to do so may impede consideration of your application. 

Must maintain a valid drivers license in Virginia or regional state of residence. 



  • Leesburg, Virginia, United States Anika Systems Full time

    Anika Systems Incorporated is seeking a highly skilled Business Systems Analyst to join our Federal team. As a Business Systems Analyst, you will play a critical role in analyzing and improving business processes using Robotic Process Automation (RPA) tools such as UiPath, Blue Prism, or Automation Anywhere.Key Responsibilities:Conduct workshops with...

  • Systems Analyst

    4 weeks ago


    Leesburg, Virginia, United States Loudoun County Full time

    Welcome to Loudoun County Government, where we are committed to serving citizens and the business community with excellence. We are seeking a highly skilled Systems Analyst to join our team in the Office of the Commissioner of the Revenue.Job SummaryThe Systems Analyst will play a critical role in supporting our TAX Assessment and CAMA systems, addressing...


  • Leesburg, Virginia, United States Loudoun County Full time

    Job Opportunity: HRIS AnalystWe are seeking a highly motivated and detail-oriented HRIS Analyst to join our team at Loudoun County Government. As an HRIS Analyst, you will play a crucial role in supporting the strategic planning, implementation, and maintenance of our HR information systems.Key Responsibilities:HRIS Administration and Maintenance: Monitor...


  • Leesburg, Florida, United States Loudoun County Government Full time

    Job SummaryThe HRIS Analyst will play a pivotal role within the HRIS division supporting the strategic planning, implementation, and maintenance of our HR information systems. The HRIS Analyst will assist with automation systems planning, manage complex programs and databases, provide technical support, and ensure the security and integrity of our...


  • Leesburg, United States Loudoun County Full time

    Welcome and thank you for your interest in employment with Loudoun County Government! ALL SECTIONS OF THE APPLICATION MUST BE COMPLETED IN ITS ENTIRETY. THE RESUME IS CONSIDERED SUPPLEMENTAL INFORMATION ONLY. APPLICATIONS THAT ARE INCOMPLETE OR INDICATE 'SEE RESUME' WILL NOT BE TAKEN INTO CONSIDERATION. Introduction Are you a detail oriented and...


  • Leesburg, Virginia, United States Loudoun County Full time

    Job Opportunity:We are seeking a highly skilled and motivated HRIS Analyst to join our team at Loudoun County Department of Human Resources. As an HRIS Analyst, you will play a critical role in supporting the strategic planning, implementation, and maintenance of our HR information systems.Key Responsibilities:Monitor and maintain the day-to-day operations...

  • SOC Security Analyst

    4 weeks ago


    Leesburg, Virginia, United States Zachary Piper Full time

    Job Title: SOC Security AnalystZachary Piper Solutions is seeking a highly skilled SOC Security Analyst to support a government contracting company located in the Leesburg, VA area. The successful candidate will be responsible for receiving, documenting, and reporting on cyber security events in a 24x7x365 SOC environment.Key Responsibilities:Handle EOI and...

  • Systems Analyst III

    1 month ago


    Leesburg, United States SPECIAL AEROSPACE SECURITY SERVICES INC Full time

    Job DescriptionJob DescriptionSASSI is seeking a Systems Analyst to assist, lead, and coordinate closely with leadership within the Department of Defense Chief Information Office (DCIO). Position involves development and support of Cybersecurity Architecture artifacts and conducting gap analysis' of DCIO client's products against artifacts and...


  • Leesburg, Virginia, United States Piper Companies Full time

    Piper Companies is seeking a highly skilled Cybersecurity Threat Analyst to join our team. The successful candidate will be responsible for receiving, documenting, and reporting on cyber security events in a 24x7x365 Security Operations Center environment. This is a long-term program with a collaborative team, and the ideal candidate will have 5 years of...


  • Leesburg, Virginia, United States Yudrio, Inc. Full time

    Business Analyst Opportunity at Yudrio, Inc.We are seeking a skilled Business Analyst to support our team in delivering high-quality solutions to our clients. As a Business Analyst, you will play a crucial role in understanding our clients' needs and developing effective solutions to meet their business objectives.Key Responsibilities:Collaborate with...


  • Leesburg, Virginia, United States Iridium Satellite Full time

    Cyber Security Analyst Job DescriptionWe are seeking a highly skilled Cyber Security Analyst to join our team at Iridium Satellite. The successful candidate will be responsible for discovering vulnerabilities and risks on IT and OT equipment located both locally and remotely at sites in the US and non-US locations.This role will involve ongoing vulnerability...


  • Leesburg, United States Loudoun County Government Full time

    Welcome and thank you for your interest in employment with Loudoun County Government!ALL SECTIONS OF THE APPLICATION MUST BE COMPLETED IN ITS ENTIRETY. THE RESUME IS CONSIDERED SUPPLEMENTAL INFORMATION ONLY. APPLICATIONS THAT ARE INCOMPLETE OR INDICATE ‘SEE RESUME‘ WILL NOT BE TAKEN INTO...


  • Leesburg, Virginia, United States Loudoun County Government Full time

    Job Opportunity at Loudoun County GovernmentWelcome to the Operating Budget Division of Loudoun County Government, where we are seeking a highly skilled Management Analyst V/Team Lead to join our team.This is an exciting opportunity for a motivated and experienced professional to lead a team of management analysts and contribute to the planning and execution...

  • Cybersecurity Analyst

    4 weeks ago


    Leesburg, Virginia, United States Foxhole Technology Full time

    Job Title: SOC Analyst (Tier 2)Clearance: SecretLocation: Leesburg, VA (Onsite)Foxhole Technology is seeking a skilled SOC Analyst (Tier 2) to join our team in support of Security Operations Center on a newly awarded contract.The ideal candidate will have experience working in a network security environment, such as a Security Operations Center (SOC), and...


  • Leesburg, Virginia, United States Loudoun County Government Full time

    Job SummaryLoudoun County Government's Office of Management and Budget (OMB) is seeking an experienced Management Analyst V/Team Lead to join its Operating Budget Division. This role will oversee, train, and support a team of management analysts and contribute to the planning and execution of the annual operating budget process.Key ResponsibilitiesOversee...


  • Leesburg, Virginia, United States BizFirst Full time

    Job DescriptionThis is a remote position.BizFirst is seeking a skilled Oracle EBS Senior Functional Analyst to join our team. The ideal candidate will have a strong background in Oracle EBS processes, including Procure-to-Pay (P2P) and General Ledger (GL), with a preference for experience with Accounts Receivable (AR).The successful candidate will engage in...


  • Leesburg, Virginia, United States Loudoun County Government Full time

    Job SummaryLoudoun County Government's Office of Management and Budget (OMB) is seeking an experienced management analyst to become a core member of the management team for OMB's Operating Budget Division.This position will oversee, train, and support the work of a team of management analysts and contribute to the planning and execution of the annual...


  • Leesburg, Florida, United States Iridium Satellite Full time

    About the Role:We are seeking a highly skilled Cyber Security Analyst to join our team at Iridium Satellite. As a Cyber Security Analyst, you will be responsible for discovering vulnerabilities and risks on Information Technology (IT) and Operational Technology (OT) equipment located both locally and remotely at sites in the US and non-US locations.Key...


  • Leesburg, Virginia, United States Loudoun County Government Full time

    Job SummaryLoudoun County Government's Office of Management and Budget (OMB) is seeking an experienced Management Analyst V/Team Lead to lead the Position Management and Collective Bargaining team.This role involves supervising one senior analyst and participating in the County's internal collective bargaining negotiating team. Key responsibilities include...


  • Leesburg, United States Loudoun County Full time

    Welcome and thank you for your interest in employment with Loudoun County Government! ALL SECTIONS OF THE APPLICATION MUST BE COMPLETED IN ITS ENTIRETY. THE RESUME IS CONSIDERED SUPPLEMENTAL INFORMATION ONLY. APPLICATIONS THAT ARE INCOMPLETE OR INDICATE 'SEE RESUME' WILL NOT BE TAKEN INTO CONSIDERATION. Introduction Are you driven by a passion...