Computer Programmer Analyst II

An Overview

The Information Technologies 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, which includes applications for GL/AP/Budgeting, Purchasing, HR-Payroll, Accounts Receivables, Tax Billing, and Property Assessments. It also maintains assorted smaller ancillary systems supporting data interfaces or individual departmental needs. The CPA II will be performing software configuration, full life cycle support, and software development across the portfolio but will specialize in supporting our financial account receivable and real estate property management software packages. Production support, troubleshooting, root cause analysis, integration support, and end-user access & security setup are expected parts of this job function. Regular interaction with our end-user subject matter experts is another characteristic. 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) and supported 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.
• Under appropriate supervision of senior developers, develop new applications and interfaces to interact with existing financial applications and data transfer between these systems using well-established and new technologies, e.g., Visual Studio 2019, SQL Server 2016 or higher, Dynamic Linked Libraries (DLL), or standard software toolkits provided by 3rd party vendors, etc.

• Perform system administration within the applications; 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; Maintain application workflow rules and monitor these for correctness and continual improvement.

• 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.
• Analyze existing and future software needs and makes recommendations to supervisors on methods to enhance productivity.
• Consult and work with other EBSS and Applications staff, Network and Security Services staff, and/or Database Administrators to determine development platforms (e.g., applications and database development tools).
• Write documentation for applications and maintain these documents as required, including developing system documentation including object-oriented class libraries for assigned projects to in-house program modules for reuse by other EBSS and Applications staff.
• 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.

About the Department

The ITS Department is responsible for the centralized operation of the City's information technology services, support, and infrastructure. The department is comprised of approximately 70 staff and has an annual operating budget of around $15 million. The ITS department is organized to provide a flexible, efficient, and effective structure to manage information technology operations and investments to support the City's strategic goals, business processes, and enterprise-wide information needs.

Minimum & Additional Requirements

Four Year College Degree; Considerable experience as a Computer Programmer Analyst I or GIS Specialist, or equivalent level and completion of advanced courses in computer science, GIS, or a related field; or any equivalent combination of experience and training which provides the required knowledge, skills and abilities; two to four years demonstrated experience at the intermediate level in the information management and systems environment. Possess a sound working knowledge of, and significant hands-on experience with a high-level programming language, such as C#, Visual Basic, ASP, PL/SQL, or any of the Microsoft .Net development platforms.

Preferred Qualifications

Four Year College Degree; Graduation from an accredited four-year college or university with a four-year degree in Information Systems, Computer Technology, Business, Economics, or substantial work experience supporting medium to large computer applications systems; extensive working knowledge of, and significant hands-on experience in programming languages such as C#, Visual Basic, ASP, PL/SQL, or any of the Microsoft .Net development platforms; relational database experience in MS SQL Server, Oracle, or MS Access; experience utilizing reporting software such as Crystal Reports or MS SQL Server Reporting Services; experience utilizing a proprietary COTS SDK or workbench or with an enterprise development tool such as MS Visual Studio.