Programmer Analyst II

  • City of Costa Mesa, CA
  • Costa Mesa, California
  • Oct 01, 2020
Full Time Administrative Analysis and Research Information Technology and Communication Services
  • Salary: $38.48 - $51.56 Hourly USD


Essential Functions: These functions may not be present in all positions in this class. When a position is to be filled, the essential functions will be noted in the announcement of position availability. Management reserves the right to add, modify, change or rescind work assignments as needed.
Provide technical support and guidance to City departments by analyzing user requirements for modifications to existing computer programs and requests for new programs.
Research and adopt methods to install new or improve existing software applications.
Meet with various department representatives to define specific procedures and activities that can be converted to computer applications programs; answer related questions concerning the feasibility and impact of proposed changes.
Establish reasons for application failures and errors, including user errors or application errors.
Analyze, debug and document software applications problems.
Apply appropriate fixes and upgrades in test mode; check for proper operation before applying software to production environment.
Conduct training sessions in computer applications for end users.
When assigned to General Programming:
Create and update processes, programs, and reports to resolve problems such as new application designs, scripts, data tables, formulas, documents, security features and test operations.
Provide technical support and guidance to City departments in relational database design, connectivity, access and quality assurance.
Create and execute SQL queries and/or Crystal reports.
Assist users in learning new software and potential department applications.
Responsible for other systems and data such as web application development.
When assigned to Geographic Information Systems (GIS):
Provide technical support and guidance to City departments in GIS database design, connectivity, access and quality assurance.
Coordinate, administer, maintain, and support the City's Geographic Information System (GIS) and other systems, as assigned; related hardware and software including research and adopt methods to install new or improve existing software applications; configure and maintain the City's GIS database, application, web servers, and web enabled GIS applications.
Create and maintain multiple GIS layers including parcels, streets, right-of-way, zoning and other development layers, and Police Department Computer Aid Dispatch (CAD) system layers.
Develop, design, plan, and implement various GIS projects including integration with other City systems and data sources.
Develop, test, prepare reports, and implement quality assurance (QA) and quality control (QC) processes; perform routine data management tasks, data validation and correction, queries and editing in GIS to ensure data accuracy, integrity, and completeness. Analyze, debug and document software applications problems.
Conduct GIS queries and analyze departmental data sources to develop decision-making tools critical to departmental and divisional needs.
Perform routine data management tasks such as data validation, correction, queries and editing in GIS.
Collect and research a variety of data (field studies, records reviews, statistical analysis, etc.).
Create and maintain GIS data sources and related applications.
Perform a variety of GIS tasks and activities including data input and map generation.

Job Description

This job posting was last updated on September 17, 2020

*Due to recent budget reductions, employees in these classifications are required to furlough 104 hours between June 21, 2020 and July 20, 2021.  New employees will have their required furlough hours prorated based on hire date.

*Effective July 2022: 2% Salary Increase will be applied.

Under general supervision, performs work of routine difficulty in the development and modification of software application programs in support of the information processing needs of city departments; to perform both routine and complex technical and administrative tasks related to the development and operation of the system; and to perform related duties as required. Incumbents may be assigned to any of the following assignments: General Programming or Geographic Information Systems (GIS) and related programming.
This position receives functional supervision from the Systems and Programming Supervisor and performs a variety of software analysis functions in support of various user department needs.  This position may receive technical direction from the Senior Programmer Analyst in completing particular assignments. This position requires knowledge of a broader range of applications programs, operating systems and division operations than the Programmer Analyst I classification.

There is currently one vacancy assigned to Geographic Information Systems (GIS).

Applications must be completed and submitted online.  This recruitment will remain open until filled and may close without prior notice, therefore prompt application is encouraged.  
The next application review date is August 3, 2020.
Candidates are required to provide specific information regarding their education and experience as it relates to the position by completing all fields of the application.  Applications may be rejected if incomplete.  Do not include text or attached resumes, as they will not be accepted or reviewed in the application process.  Based upon the information presented on the application, a limited number of candidates who possess qualifications most pertinent to the position will be invited to participate in the selection process.  The selection process may include, but is not limited to the following components:  application review and evaluation, written examination or exercise, physical examination, practical exercise and interview evaluation.  Please notify the Human Resources Division 72 hours in advance of the test date if you have a disability which requires accommodation for the testing process.  The eligibility list will be in effect for one (1) year, unless exhausted sooner.   The eligibility list established from this recruitment may be utilized to fill lower-level vacancies which occur during the life of the list.
It is recommended you use a personal email address on your application instead of a work email address.   Notifications during this recruitment will be sent by email only (regardless of the notification preference selected during the online application process).  Notifications will be sent to the email address that is listed on your online application. 
All employment offers made by the City are contingent upon establishing proof of a prospective candidate's legal authorization to work in the United States and successfully passing all components of the pre-employment process which may include, but is not limited to:  comprehensive background check, criminal history check (Live Scan fingerprint check), polygraph examination, post-offer psychological evaluation and post-offer medical evaluation (may include drug screen).
Note:  The provisions of this job bulletin do not constitute an expressed or implied contract.  Any provisions contained within may be modified or revoked without notice.
Closing Date/Time: Continuous

Special Instructions


Additional Information


Please contact human resources for a summary of the essential tasks and environmental factors for this classification.

Employee accommodations for physical or mental disabilities will be considered on a case-by-case basis.

Job Address

Costa Mesa, California United States View Map