This job has expired

Computer Programmer Analyst II

City Of Alexandria Virginia
Alexandria, VA
$66,459.64 - $116,956.84 Annually
Closing date
Feb 20, 2023

View more

Job Details

Computer Programmer Analyst II

An Overview

The Information Technology Services department for the City of Alexandria is seeking a Computer Programmer Analyst II (CPA II) for our Enterprise Business Systems Support Division (EBSS). This technical team supports our portfolio of ERP and financial software systems, tax billing systems, and real estate property assessment systems. It also maintains assorted smaller ancillary systems supporting data interfaces or individual departmental needs. The CPA II will be primarily performing system administration and configuration of real estate assessment and property management software packages including day-to-day production support, report writing, troubleshooting, root cause analysis, integration support, and end-user access & security setup. Regular interaction with our end-user subject matter experts is an important characteristic of this position. The selected individual should bring a mix of analytic ability, technical knowledge, and the ability to communicate and coordinate actions within ITS and with external departments and agencies.

The Opportunity

As the Computer Programmer Analyst II and an important member of the financial application team, you will:
  • Maintain "commercial off the shelf" (COTS) real estate assessment and other software systems including their configuration and support of custom integrations; Provide support during server installations and/or upgrades of software packages, releases, and fixes; Provide tier 2 assistance to our Helpdesk with client PC issues related to the applications; Generally, assist others in the ITS department with support of the applications environment.
  • Support day-to-day production processes of in-house Windows and Web applications.
  • Develop reports for the end users using SSRS and/or Crystal Reports.
  • Perform system administration of systems; Ensure that setup and configuration are current and correct; Maintain code tables, validation tables, templates, and other application-specific objects which contribute to system performance and data integrity.
  • Confer with users to identify requirements and enhancements and develop specifications using business process documentation tools for new and modified small to medium-scaled applications.
  • Analyzes existing and future software needs and makes recommendations to supervisors on methods to enhance productivity.
  • Write documentation for applications and maintain these documents as required, including developing system documentation for assigned projects and in-house programs.
  • Develop and execute test plans for new and adapted systems and identify and correct problems.
  • Provide technical guidance and training to users, ITS Coordinators, Computer Operators, and other staff members.
  • Perform related work as required.

Essential Knowledge, Skills, and Abilities

An understanding of role-based security and inheritance is essential. This position requires coding and scripting experience using procedural methodologies using Structured Query Language (SQL) and other tools associated with maintaining an enterprise-class application. Some experience with report generation software and tools is needed. A sound understanding of information technology infrastructure components, such as databases, networks, workstations, servers, and firewalls is necessary to assist in problem determination and troubleshooting. Good written and verbal communications skills, good organizational skills, and good analytical skills are necessary to be effective working with end-users and across ITS.

About the Department
The Information Technology Services Department is responsible for enterprise technology operations for the City of Alexandria. ITS provides technology services and solutions to City departments to enhance service delivery. ITS aligns its work with City needs by providing leadership, resources, expertise, and products that enable departments to better serve the City's residents, businesses, and visitors. ITS resources support initiatives funded through the multi-year Information Technology Capital Improvement Plan (IT/CIP) to improve the overall technology landscape. The City of Alexandria's ITS Department has been a Top Ten National Finalist in the Digital Cities Award program for the past 13 consecutive years.

Minimum & Additional Requirements

Bachelor's or higher degree from an accredited college or university in computer science, information systems, or a closely related field; 2 years of relevant work experience; Hands-on experience supporting enterprise-class applications; Intermediate proficiency with MS SQL Server databases and proficiency with Structured Query Language; Intermediate experience with report generation software and tools, such as Crystal Reports or SSRS; or other combinations of education and relevant work experience which provides the required knowledge, skills, and abilities.

Preferred Qualifications

Hands-on experience supporting enterprise-class real estate assessment software applications; four or more years of progressively responsible demonstrated experience in application/database development and support; experience creating and maintaining database programming constructs, such as views, triggers, functions and stored procedures; experience supporting applications developed using MS Access, experience with Harris Govern RealWare Suite is highly desirable


This class specification provides a generalized representation of positions in this class. It is not intended to reflect essential functions pursuant to ADA, nor is it intended to list every specific function and task of this class title. A job class may also have a medical standard associated with specific physical or mental requirements that must be met.


The City of Alexandria is an award-winning, innovative, and progressive local government that brings together elected leaders, residents, businesses, and staff to foster a thriving community.  We are an independent, full-service city, providing the services typically operated by both counties and cities in areas such as public safety, transportation, human services, parks and recreation, planning, and administration. We offer a wide range of exciting career opportunities in a variety of fields, with the resources and expertise to succeed.  In Alexandria, employees are our most important asset, and we work hard to create and support a culture that delivers excellence through the shared values of respect, integrity, teamwork and continuous improvement.

Our employees have access to excellent medical, dental, vision, life insurance and other benefits.  Alexandria provides a defined-benefit pension and offers six weeks of paid parental leave to employees who become parents through birth, adoption or foster care.

We offer a robust wellness program, interdepartmental rotation program, tuition assistance funding and professional development program that helps employees obtain the knowledge, skills, qualifications and experience to enhance their professional and personal growth.

With a population of approximately 160,000 and a land area of 16 square miles, Alexandria is the seventh largest city in the Commonwealth of Virginia. Located on the Potomac River across from Washington, D.C., Alexandria is known for its beautifully preserved 18th- and 19th-century architecture, charming waterfront, high-tech economy, vibrant retail and restaurant corridors and diverse neighborhoods. We are a unique and historic community, and we continue to innovate for the 21st century.

Company info

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert