City and County of San Francisco

Under general direction, responsible for the design, writing, maintenance and documentation of application source code for specific projects; may work directly with users to clarify system requirements.

The IS Programmer/Analyst is the journey level in the Programmer/Analyst series. This position is distinguished from the Assistant classification in the wider scope of programming responsibilities, and is distinguished from the higher level classifications in the lower complexity of the work and less interaction with users. At this level, incumbents work with occasional instruction or assistance. Employee performs a full range of complex analytical tasks and work under direction within a framework of established procedures. Work requires frequent interpretation of policies, procedures and guidelines, and may require the development of recommendations consistent with directives. Work is normally reviewed upon completion, and is judged primarily on overall results with great latitude in determining work methods and assignment requirements.

May be expected to provide supervision to subordinate clerical or technical staff, however, supervisory responsibilities are ancillary to the main focus of the position.

According to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job code/class and are not intended to be an inclusive list.

1. Design and code programs for a clean compile; prepare comprehensive test plans and ensure that programs are tested; debug problem programs; implement new programs.

2. Identify opportunities for operational improvements in existing systems; analyze requirements and costs of implementing service requests.

3. Determine and analyze operating characteristics and requirements; may schedule projects.

4. Develop screen prototypes; prepare detail design specifications.

5. Review program development with users and modify as necessary.

6. Code or update common program routines to be shared among programs.

7. Develop or modify data flow and diagrams, entity relationship diagrams; document systems design.

8. Create test plan and test cases; execute unit test and document results; assist users to develop and execute system test; provide migration support to users; resolve problems.

9. Create and maintain computer data base systems; prepare user system manuals; download existing data into tables for use in new applications.

10. Analyze, develop and test screen processes.

11. Implement the system; prepare production documentation and instructions; maintain technical and user manuals; provide training on new procedures.

12. Write, enhance and document production jobs; monitor and schedule production jobs; review status of submitted jobs; analyze and resolve problems as necessary and/or resubmit jobs.

13. Provide technical assistance for on-line and batch systems, including hardware and/or software problem resolution to ensure system availability, data integrity, and timely and accurate reporting; document issues and possible solutions/recovery procedures.

14. Compile and generate special reports; create tables, forms and queries; provide progress reports to higher management.

Knowledge of: Computer languages; interactive applications; electronic data processing methods; personal computer applications development tools; coding, testing and implementing programs; script/procedure languages; job flow within a large scale data processing environment; systems development life cycle; common operating systems software and relational database systems.

Ability and Skill to: Communicate effectively orally and in writing; use logic and analysis to solve computer and systems problems; establish effective working relationships with users, peers, management and vendors; translate functional requirements into systems; analyze and categorize data and information in order to determine the relationship of the data with reference to established criteria/standards; advise and provide interpretation to others how to apply policies, procedures and standards to specific situations; exercise judgement, decisiveness and creativity in situations involving the evaluation of information against measurable criteria; read and understand professional journals and literature; prioritize competing requests for service.

These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification.  Please note, additional qualifications (i.e., special conditions) may apply to a particular position and will be stated on the exam/job announcement.

Education:
An associated degree in computer science or closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field].

Experience:
One (1) year of experience in application or software development or programming.

License and Certification:

Substitution:
Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.