Programmer Analyst I

Dallas, TX, United States

Welcome to the City of Dallas!

The City of Dallas is one of the largest employers in the DFW Metroplex.

We offer growth opportunities and a chance to make a difference in our community.

What do we offer?

A competitive salary, five-year vested pension plan, great benefits package that includes health, vision and dental insurance, pet insurance, tuition reimbursement, qualifying childcare assistance, paid time off and more.

Join our diverse workforce and help us in providing excellent service to the residents of Dallas while building a rewarding career.

Job Summary

Write, test, and debug programs, and maintain mainframe or computer systems in order to improve the availability,usability, reliability, and productivity of the system.

Job Description

Overview

The Programmer Analyst I is an entry-level to mid-level technical support position designed to contribute toward application layer and related integrations readiness through some of of the following activities: active monitoring of assigned systems, support to related incident and request management processes, and in delivery of experienced programming or technical support in the City's information systems and projects. Guided by senior Programmer Analysts, the Programmer Analyst I will be part of IT Teams that works closely with other IT Service Delivery Managers, teams, and vendors (Server, Active Directory, Security, Database, Service Desk, Network, etc.) in optimizing overall and specific performance, compliance, response to issues that emerge and overall readiness in supporting business processes. Works closely with above teams in the successful planning, execution and completion of various projects and initiatives.

Essential Functions

1 Provides application-layer technical support of assigned/aligned applications through close monitoring of system (application, web, and database) processing and other dependencies to ensure that current operational business processes and application information processing requirements are met, supported, triaged, restored, and enhanced.

2 Coordinates with supporting IT Service Delivery Teams (Server, Network, Security, Service Desk, etc.) and functions to ensure responsive incident, service request/task, problem, change and release management functions in support of assigned/aligned applications; coordinate assembly and orientation of these teams as required to combine and resolve problems.

3 Monitors and responds to IT Service Management queues (incident, support, or service request, change request, etc.) related to assigned/aligned applications to ensure appropriate support, triage, assignment routing and customer service.

4 Develops proficiencies in administering assigned/aligned software applications, programs, and documentation in Admin-Runbooks; tests, debugs, and assists in teaching users/Project Teams in how to use newly developed or refined software; tailors but avoids 'custom coding' in supporting reporting/dash-boarding initiatives to make application systems more user friendly.

5 Collaborates closely with supported operational business department subject matter experts to learn and support operational business processes, data processing, data conversion, data dictionary, data mapping and conversion, integrations, reporting, standards, and dashboard requests are clearly documented and mapped so that any as-is application requests or enhancement requests are clearly understood and actionable by teams.

6 Supports the evaluation and upgrade of systems and programs to ensure support of documented department business practices, standards, and expectations to maximize processing efficiency of aligned applications; provides troubleshooting support, resolves incidents and supports/addresses service and incident requests within benchmark standards.

7 Contributes to application-oriented performance, smoke, regression, end-to-end and other testing on assigned aligned applications in as-is to will-be enhancements; creates and runs accompanying testing scripts and scenarios as required; captures this content sufficiently to support Application Change Control/Release Control preparations and processes. Runs and tests software of client departments to detect program problems and improve efficiency; schedules and monitors periodic processing and provides documentation and reporting on functionality, programming, and issues addressed.

8 Assists in evaluations and planning of software and hardware purchases to maintain and enhance the system; prepares cost analysis of maintenance or enhancement of existing programs; develops, creates, and implements workflow solutions to improve end user's daily workflow activity.

9 Progressively gains proficiencies in the coding and development of vendor provided and peer programmer analysts and others as-required for accuracy, efficiency, and skill development; assists in training lower-level programmer analysts in coding, testing, and debugging according to City standards; participates in training webinars and seminars to remain abreast of technology enhancements and changes.

10 Compiles complex ad-hoc reports for client departments, participates in various special projects, and provides analysis and programing support for various business needs within the City.

11 Performs any and all other work as needed or assigned.

Knowledge and Skills

Demonstrated aptitude and interest in progressively improving knowledge of multiple programming languages, database methodologies/platforms that support application layer processing, service/support and enhancements.

Demonstrated aptitude and interest in progressively improving knowledge of current Client, Server, Web, Database, Security/Compliance and IT Service Management technologies, systems, software, and integration standards/techniques.

Demonstrated familiarity with physical platforms, virtual platforms, Software as a Service hosted platforms, and common industrial platform services such as Amazon Cloud, Microsoft Azure, etc.

Demonstrated ability to communicating effectively verbally, in writing and in collaborative presentation settings.

Demonstrated ability to establish and maintain effective working relationships with customer departments, other IT Service Delivery Manager groups and supporting vendors.

Knowledge of multiple programming languages- .NET, Object-Oriented Programming, SQL, etc.

Ability to write advanced SQL Queries, Stored Procedures.

Knowledge and understand of Scripting Languages such as VBScript.

Working knowledge of ITSM/ITIL methodologies for knowledge base build, Application Runbook framing, CMDB, change, release, problem, incident, asset and event management processes.

Working knowledge of automated network, server, database, security, CMDB tools and system monitoring tools (NetScout, APP-D, Extra Hop, etc.).

Strong analytical skills

Ability to write and evaluate new software programs.

Ability to solve problems with developing/deploying software technology solutions.

Ability to communicate effectively and diplomatically orally and in writing.

Ability to establish and maintain an effective working relationship with all levels of management, city officials, vendors, other government agencies, other employees and the public

Ability to participate in 24x7 support coverage as needed

MINIMUM QUALIFICATIONS

EDUCATION: Associates degree or higher in engineering, math, computer science, Business Technology, or Information Technology related fields.

EXPERIENCE: One (1) year of experience in Object-Oriented Programming and/or relational database (JAVA, MS SQL, SQL Server, Oracle PC SQL, Python, UML Framework solutions and C+ or C++ within Applications), to maintain and improve application performance.

EQUIVALENCIES: High school diploma or GED plus three (3) years of the required experience will meet the education and experience requirements.

An associate degree in any field plus two (2) years of the required experience will meet the education and experience requirements.

A bachelor's degree (or higher) in a non-specified field plus one (1) years of the required experience will meet the education and experience requirements.

A Master's degree or higher in a stated field plus six (6) months of the hands-on technical support experience will meet the education and experience requirements.

OTHER REQUIREMENTS: No felony or class A misdemeanor convictions

No class B misdemeanor convictions within the last ten (10) years

No family violence convictions

Cannot currently be on any active deferred adjudication for any felony, class A misdemeanor or class B misdemeanor charge

Must be available to work varying shifts including nights, weekends, holidays and overtime.

Preferences: Will be unique to each Programmer Analyst I Position based upon the Team they are a part of and the Application Alignments Assigned. Below applies to a member of the Financial Apps Team This position specifically supports the City's IT Financial Applications Support Team and is expected to conduct technical administration, support, operations, enhancements and ensure readiness of the AMS Advantage Financial and Procurement system, Hyperion Oracle Budget system, Report2Web, Legistar City Agenda System and additional systems.

Selected candidates will plan, schedule, execute and enhance all integrations and reporting from these platforms and will work closely with business partners to maintain and support Configuration Management processes.

Hiring preference will be granted to Applicants who have experience in designing, implementing, and maintaining integrations and Interfaces with CGI Advantage or Hyperion or similar enterprise platform functions. The applicant's familiarity with older techniques (flat files, cvs exchange or SFTP) and new techniques such as building communications through xml Interfaces and API's will be an important part of the selection criteria.

Applicants that have a blend of ERP DevOps and Production Support skills experience and aptitude, not directly related to CGI Advantage or Hyperion will still be favorably considered.

Posting Close Date: 07/11/24

Salary Range

$56,509.18 - $69,437.17

The salary listed on this job posting is the starting salary range; amount offered will depend upon qualifications.

City of Dallas is an Equal Opportunity Employer and values diversity at all levels of its workforce.