> Markdown version of [/jobs/ext/2508303-systems-analyst](https://www.wearedevelopers.com/jobs/ext/2508303-systems-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Systems Analyst - **Company:** Loudoun County Government - **Location:** Sterling, VA, United States - **Salary:** $76,820.0 - $134,436.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Computer Programming, Databases, Data Integrity, Data Visualization, Database Servers, Microsoft SQL Server, MySQL, Oracle (Applications), Performance Tuning, Power BI, SQL Databases, SQL Server Reporting Services, Freeform SQL, Database Optimization, Information Technology, Tools for Reporting - **Published:** August 2, 2026 - **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/17798656?backUrl=%2Fcareer%2F17798656%2FSystems-Analyst-Virginia-Sterling ## About the Role Bachelor's degree in Computer Science or related field; two (2) years of related experience; or equivalent combination of education and experience., + 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. + Certification in SQL Server or relevant technologies. + Demonstrated 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 keen attention to detail. + Ability to work collaboratively in a team environment and communicate effectively with stakeholders. + Previous experience with iasWorld, CAMA systems, Oracle, or SQL in the financial, appraisal, or construction industries is preferred. Familiarity with Virginia local tax structures. Job Contingencies and Special Requirements Must maintain a valid driver's license in Virginia or regional state of residence. 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. ## Description 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 the Commissioner's office technology team, addressing a wide range of technical challenges to support our tax assessment and CAMA (Computer Assisted Mass Apraisal) systems. The Systems Analyst must have previous experience as a SQL Data Analyst, possess exceptional skills in SQL data analytics, queries and reports. The Systems Analyst 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 within the Commissioner's Office and other County departments 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. ## Related Videos - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [OLAP for AI Applications and why you should care](https://www.wearedevelopers.com/videos/100212-olap-for-ai-applications-and-why-you-should-care) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london) - [Software Developer Salary in Austria [2023]](https://www.wearedevelopers.com/magazine/213-software-developer-salary-in-austria-2023)