Powered by JobAps

1063 IS Programmer Analyst-Senior

Recruitment #pbt-1063-059628


1063 IS Programmer Analyst - Senior



This is a Position-Based Test conducted in accordance with the Civil Service Rule 111A.
The position is currently located at the San Francisco General Hospital and Trauma Center.


General Description:

Under general direction of the Director of Infection Control  the 1063 IS Programmer Analyst - Senior will develop and maintain reporting infrastructure to meet regulatory requirements, patient safety and monitoring initiatives as well Quality Improvement projects for  the Infection Control Division  at San Francisco General Hospital and Trauma Center.  These systems will help Infection Control track hospital acquired infections, identify emerging infection patterns, initiate appropriate interventions when necessary and comply with the multiple state and federal regulatory requirements for public reporting.  
The IS Programmer Analyst - Senior will work collaboratively with physicians and Infection Control clinical experts to perform highly detailed analysis from electronic health records systems, laboratory and surveillance data.  This position will assist various UCSF/SFGH personnel with their ad hoc queries, medical studies and hospital surveillance projects; extract, consolidate, analyze and summarize hospital-wide clinical data from multiple external systems; and generate data summaries as needed by the supervisor in order to analyze reports on infectious trends.

The reporting environment is highly complex, consisting of multiple electronic health record systems and applications from ancillary diagnostic departments.  This requires high level of expertise in integrating data across platforms, able to do independent analysis for data validation and reliability.  The position also drives automating processes where possible on SQL servers.  Reporting is distributed through a wide variety of methods, ranging from flat files to web pages depending on end user needs and project objectives.  




The IS Programmer Analyst - Senior will work independently to plan, design, develop and implement system solutions; troubleshoot problems and make recommendations for next steps; provide follow up status reporting to the Infection Control team; support, integrate and enhance Infection Control’s Windows 2008, SQL 2008 database servers, IIS web site and other applicable sites; develop and maintain complex interfaces to other SFGH system platforms to facilitate automated data collection and surveillance reporting; write complex application programs and provide program support using Visual Basic/VB.net, various web/data base technologies, scripting languages, MS Access, SQL 2008, T-SQL, SQL 2008 SSIS, etc. to create and maintain Infection Control applications, automate data bases, and data collection routines which will include designing and programming complex user interfaces, on-line/batch update database processes, hospital patient surveillance and reporting applications, and web sites.


In addition, the IS Programmer Analyst - Senior will also work with Infection Control and the DPH Information Systems Department to evaluate external third party vendor applications and systems that may replace or compliment reporting capabilities and expand data integration across multiple departments and facilities.

Minimum Qualifications

1. Possession of a baccalaureate degree with major coursework in Computer Science, Information Systems, Business Administration, Public Health Administration or a closely related field; AND

2. Three (3) years of verifiable information systems work experience coordinating information systems implementation projects, performing application development work and providing server support.


Substitution: Additional work experience may substitute for the required educational requirement on a year-for-year basis. One year (2000 hours) of experience is equivalent to 30 semester/45 quarter units.


Desired Qualifications:

The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

  • Knowledge and familiarity with state and federal infection control requirements for healthcare settings, e.g. Joint Commission, California Department of Public Health, California Health and Safety Codes and Centers for Medicare/Medicaid Services plus security and privacy laws, e.g. HIPAA
  • Microsoft Certified Product Specialist SQL 2008, IIS, or MCSE certification
  • Familiarity with VMWare servers
  • Experience with application, web and database design, development, implementation and support
  • Experience with Windows 2008, MSSQL2008, SSIS and SSRS
  • Experience integrating data from multiple systems, validating data integrity and conducting analysis  
  • Has worked in a healthcare environment and experience gathering reporting specifications from clinical providers


How To Apply

Applications for City and County of San Francisco jobs are being accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.

  • Select the desired job announcement (PBT-1063-059628)
  • Select “Apply” and read and acknowledge the information
  • Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
  • Follow instructions on the screen

Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.

Applicants may be contacted by email about this announcement and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date.  Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter.  To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org).

Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file.  Applicants should retain this confirmation email for their records.  Failure to receive this email means that the online application was not submitted or received.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline.  Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

If you have any questions regarding this recruitment or application process, please contact the exam analyst, Elaine Lee, by telephone at 415-206-5033, or by email at Elaine.Lee@sfdph.org.

Applicants may be required to submit verification of qualifying education and experience at any point in the application, examination and/or departmental selection process. 

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

Selection Procedures

Training and Experience Evaluation:                                            Weight:  100%

The information provided by candidates on the job application, requested verification, if required, and a Supplemental Questionnaire will be evaluated in relations to the knowledge, skills and abilities required for this position in class 1063 IS Programmer Analyst - Senior.

Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.

Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process.

Candidates will be placed on the eligible list in rank order according to their final score.

The department may utilize additional selection procedures to make a final hiring decision.

The certification rule for the eligible list resulting from this examination will be Rule of Three Scores.  Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

Eligible List:
The eligible list resulting from this examination is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.

The duration of the eligible list resulting from this examination process will be of six (6) months, and may be extended with the approval of the Human Resources Director.

Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list resulting from this announcement may be used by other departments that also use this classification or a similar classification.  To find other Departments which use this classification, please see http://www.sfdhr.org/Modules/ShowDocument.aspx?documentID=13693. Search that document by title or job code to see which departments use the classification.

Terms of Announcement:
Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations.  Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at www.jobaps.com/sf.

The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule.  Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director.  Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.

General Information concerning City and County of San Francisco Employment Policies and Procedures: Important Employment Information for the City and County of San Francisco can be obtained at http://www.sfdhr.org/index.aspx?page=20 or hard copy at 1 South Van Ness Avenue, 4th Floor.

Copies of Application Documents:
Applicants should keep copies of all documents submitted, as these will not be returned.

Note: Make sure your application and any attachments to the application submitted at the time of filing are complete and accurate and include details on all experience, education, training and other information that qualifies you for this recruitment. Failure to submit a complete and accurate application at the time of filing may result in your ineligibility for this recruitment or inability to receive full credit for scoring purposes. Any new information concerning work experience, education, training and other information that is submitted after the filing deadline may not be used for scoring or considered to determine whether you meet the minimum qualifications.

Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at:

Information regarding requests for Veterans Preference can be found at:

Right to Work:
All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.

Medical Examination: Prior to appointment, at the Department's expense, applicants may be required to take a TB screening and a medical examination.





Exam Type:  CPE
Issued:  April 19, 2013 
Micki  Callahan
Human Resources Director
Department of Human Resources
Recruitment ID Number: PBT-1063-059628

Disaster Service Workers

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.



All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, typically 7.5% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

For more information about benefits, please click here.