Systems Analyst

Loudoun County

Sterling, VA

JOB DETAILS
SALARY
$75,314.11–$131,799.70 Per Year
SKILLS
Analysis Skills, Business Analysis, Business Operations, Communication Skills, Compensation and Benefits, Computer Science, Construction, Cross-Functional, Customer Satisfaction, Data Analysis, Data Collection, Data Quality, Data Science, Data Visualization Tools, Database Management Software/Systems (DBMS), Database Optimization, Database Technology, Detail Oriented, Driver's License, Employee Benefits, Equal Employment Opportunity (EEO), Genetics, Human Resources, Information Technology & Information Systems, Local Government, Local Tax, Management of Information Systems/Technology (MIS), Microsoft SQL Server, MySQL, Oracle Applications, Performance Analysis, Performance Metrics, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Property Tax, Query Analysis, Query Optimization, Reporting Skills, SQL (Structured Query Language), SQL Server Reporting Services (SSRS), Statistics, Systems Analysis, Tableau, Tax Accounting, Team Player, Technical Support, Test Plan/Schedule, Validation Testing
LOCATION
Sterling, VA
POSTED
20 days ago

Systems Analyst

Salary

$75,314.11 - $131,799.70 Annually

Location

Sterling, VA

Job Type

FT Salary W BN

Job Number

26-00603

Department

Commissioner of the Revenue

Opening Date

06/05/2026

Closing Date

6/19/2026 11:59 PM Eastern

FLSA

Exempt

Grade

127

  • Description
  • Benefits
  • Questions

Loudoun County Government has been named one of Forbes 2025 Best Large Employers! We're proud to be recognized nationally for our commitment to employee satisfaction and excellence in public service. At Loudoun County, we bring together talented professionals from all backgrounds to make a meaningful impact in a dynamic, growing community - that's The Loudoun Difference.

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 Loudouns 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 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 County's 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 (e.g., 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.

This position is full-time and on-site in our Sterling, Virginia office, with the potential for telework up to two days per week after six months.

Hiring salary will be commensurate with experience.

Minimum Qualifications

Requires any combination of education and experience equivalent to a bachelor's degree with coursework in Computer Science, Management Information Systems or related field and two 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 (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.
  • 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

Employment is contingent upon successful completion of criminal background, driving, and credit check. 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 driver's license in Virginia or regional state of residence.

_____

Equal Employment Opportunity

Loudoun County Government prides itself on fostering a diverse and inclusive workplace that promotes employee wellness and work-life balance. As an equal opportunity employer, we consider all qualified applicants regardless of age, color, disability, gender identity, genetic information, national origin, political affiliation, race, religion, sex, sexual orientation or other non-merit factors.

Reasonable Accommodation

Applicants who wish to request a reasonable accommodation during the recruitment process should call Human Resources directly at

703-777-0213 or email Human Resources.

Loudoun County Government offers a variety of benefits to both regular full time and part time employees. To view the comprehensive benefits package we have to offer you when you join our team, please click here.

Employees hired into Regular Part-Time Intermittent positions are eligible for limited County employee benefit programs, based on the position's regularly scheduled hours. Benefits eligibility for temporary employees are dependent on duration of assignment and number of scheduled hours.

01

Do you have a bachelor's degree with coursework in Computer Science, Management Information Systems or related field and two years of previous IT experience or any combination of education and experience equivalent?

  • Yes
  • No

02

Can you describe your overall experience with SQL? How long have you been working with it?

03

What were your main responsibilities in your previous roles as a SQL Analyst (or related roles)?

04

Have you ever worked in a cross-functional environment where you had to collaborate with non-technical stakeholders?

  • Yes
  • No

05

Have you worked with data specific to our industry, local government property assessment and taxation?

  • Yes
  • No

06

What experience do you have with reporting and visualization tools like Tableau, Power BI, or Excel?

Required Question

Employer Loudoun County Government

Address 1 Harrison Street SE

Leesburg, Virginia, 20175

Phone 7037770213

Website www.loudoun.gov

About the Company

L

Loudoun County