What are the responsibilities and job description for the Applications Programmer Analyst II position at City of Berkeley?
The City of Berkeley invites you to apply for the position of Applications Programmer Analyst II in the Information Technology Department! In this role, you will act as a technical liaison between IT and various City departments, translating complex business requirements into effective technological solutions. You'll support critical City operations through the design, implementation, and support of enterprise applications, data systems, and spatial technologies that directly impact City staff and the Berkeley community. Projects may include developing reports and data queries, participating in system integrations, and contributing to technology initiatives that improve service delivery, operational efficiency, and transparency.
Current vacant positions include a generalist role and a GIS-focused role. Both positions are embedded within the City’s Project Management Office (PMO) and function as technical resources on cross-departmental project teams.The generalist position offers broad exposure to the City’s technology environment, including enterprise and business applications, business intelligence and reporting systems, data warehousing, integrations, and GIS-supported workflows. This position supports departments by:
- Analyzing business processes and translating requirements into technical solutions
- Supporting, configuring, and enhancing enterprise and departmental applications
- Developing and maintaining reports, dashboards, and data queries
- Providing technical documentation, user support, and training
- Serving as a technical resource on PMO-led technology initiatives
- Administering, configuring, and supporting GIS platforms such as ArcGIS Pro, ArcGIS Online, and related ESRI technologies
- Creating, maintaining, and publishing spatial data, map services, and web maps
- Performing spatial analysis to support City programs, policy decisions, and operational needs
- Collaborating with departments to gather GIS requirements and translate them into technical solutions
- Developing GIS documentation, standards, and best practices
- Providing GIS training and technical support to City staff
Equivalent to graduation from a four-year college or university with major coursework in computer science, mathematics, business administration, or a closely related field and two (2) years of professional experience in systems design and analysis, systems integration, and/or programming of applications for computer systems. Experience in systems design and analysis, systems integration, and/or programming of applications for computer systems may be substituted for the education requirement on a year-for-year basis.
In addition to the qualifications outlined above, the ideal candidate will have a combination of technical and business acumen to navigate and resolve a wide array of projects and issues.Applications must be received by 5:00 PM Pacific on January 12, 2026 and must include a completed application and answers to the supplemental questions. Please note that resumes are not a substitute for a completed application.
Applications are available in alternative formats (audio-format, braille, large print, electronic text, etc.) upon request to ada@berkeleyca.gov. Please allow 10 days for production of the material in an alternative format.
The exam process will include, but may not be limited to:- Application review for minimum qualifications and required documents
- Review of Supplemental Questionnaire
- Written Exam (tentatively scheduled for the week of February 2, 2026)
Tests may consist of any combination of written, oral or other exercises or assessment procedures that test content and may include, but are not necessarily limited to, typing, math, reading, writing and analytical skills; problem solving ability; computer and software proficiency, or any other job-related knowledge, skill, ability or qualification. The examination process and dates are subject to change. The City may, without notice, change or eliminate any assessment component as needs dictate. Applicants passing all examination phases will have their names placed on an employment eligible list that hiring departments will use to conduct final selection interviews.
Reasonable Accommodations: The City is committed to making reasonable accommodations in the examination process and in the work environment. Individuals requesting reasonable accommodations in the examination process must submit a request in writing to hr@berkeleyca.gov at the time of application.
Salary : $118,985 - $141,840