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

Notes

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.