1054 IS Business Analyst-Principal

Recruitment #PBT-1054-108533


This is a Position Based Test conducted in accordance with Civil Service Commission Rule 111A.

The San Francisco Health Service System
The San Francisco Health Service System (SFHSS) provides health benefits for SFHSS members - employees and retirees - of the City and County of San Francisco, the San Francisco Unified School District, San Francisco City College and the San Francisco Superior Court, and their dependents. Staff must know and administer benefits for 126,000 lives with over 29 benefit plans from 10 different vendors. These benefit plans include Medicare and Non-Medicare medical, dental, vision benefits, as well as life insurance, long-term disability benefits, flexible spending accounts for health and dependent care and COBRA..

Position Description
Under general direction, the IS Business Analyst - Principal position serves as the top technical authority for one or more related specialties, or provides technical leadership and direction and assumes technical responsibility for the completion of major projects; performs or oversees all or most of the systems development life cycle and ongoing administration functions, including needs analysis, cost-benefit analysis, structured systems analysis and design, feasibility analysis, technology and software assessment, telecommunications needs analysis, project planning and management, system installation, implementation and testing, conversion to production status, technical and procedural documentation, user training, and post-implementation assessment and administration.

The Health Service System utilizes 3 key enterprise systems to effectively administer benefits.   A Human Capital Management system (HCM) PeopleSoft 9.0, a Customer Relationship Management (CRM) system (SalesForce) and an Enterprise Content Management (ECM) system (Hyland Perceptive Content).  The incumbent will have varying responsibilities across these three systems to ensure workflows are programmed correctly, systems are configured, interfaces, programs, custom screens and reports are programmed, administrative tasks are executed and security roles/permissions are created.

Typical Duties
Typical include, but are not limited to:

When assigned to the Project Leader specialty:

  •  Analyze and evaluate existing complex systems for cost effective and efficient operation and recommend modifications; prepare feasibility studies; monitor technical design in relation to system changes; gather requirements and general information regarding users business needs relating to new developments or enhancements.
  • Identify opportunities for improving business processes through automation; prepare proposals to develop new systems or enhancements to existing systems, conduct feasibility studies. 
  • Assure proper planning, engineering, documentation, installation and testing of systems to meet end user requirements; manage system maintenance activities.
  • Prepare budgetary cost estimates and develop project implementation proposals, documentation and scheduling; write technical specifications and requests for proposals.
  • Coordinate multi-vendor/multi-partner support for the technical and administrative resolution of network troubleshooting problems.
  • Coordinate interactions and activities of vendors. 
  • Develop training exercises for staff and maintain technical education; may coordinate and/or present training classes. 
  • Create and document long-term strategies for project related information systems operations; translate business needs into IS directions; identify new information systems technology opportunities; may prepare and present long-term plans.
  • Research, analyze and select hardware and software products. 
  • Coordinate and/or attend project team meetings and user meetings.

When assigned to the Expert specialty:

  • Optimize system designs through review and analysis of user needs; customize systems through design and administration.
  • Identify opportunities for improvements in business processes through automation; make recommendations for new procedures and applications.
  • Analyze the feasibility of and develop requirements for new systems and enhancements to existing systems such as Hyland Perceptive Content and SalesForce Service Cloud; prepare cost estimates and schedules for modifications; set scope, boundaries and objectives for system functions and interfaces based on departmental needs. 
  • Design, develop and implement new systems to support departmental activities.
  • Define system requirements; design, code, test and debug systems, such as PeopleSoft 9.0 utilizing PeopleSoft development tools (PeopleTools, Application Designer, SQR, Process Scheduler and PeopleSoft Query); train users on applications. 
  • Develop or modify system design including administering Hyland Perceptive Content servers and designing Perceptive Content workflows, document types, routing rules and programming iScripts: write detailed design specifications.
  • Provide advice on the functionality of new programs and compatibility of modifications to ensure user needs are met.
  • Provide analysis and technical support for highly complex systems; troubleshoot systems problems; implement solutions.
  • Support and maintain highly technical systems or networks; analyze and evaluate systems for cost effective and efficient performance; recommend modifications.
  • Manage and monitor the progress of contractors and vendors; resolve problems.


Minimum Qualifications

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.

An associate degree in computer science or a 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].

Five (5) years of experience in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.


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.

Special Conditions: (in addition to the Minimum Qualifications stated above, applicants must have the following experience in order to qualify)
One (1) year of recent and verifiable experience in PeopleSoft 9.0 HCM Benefits Administration.


Desirable 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:

  • Baccalaureate degree with major college course work in management information systems, computer science, information technology, data processing operations or related field.
  • Five (5) years technical design and development experience with PeopleSoft Development Tools (PeopleTools, Application Designer, PeopleCode, SQR, Process Scheduler and PeopleSoft Query). 
  • Six (6) months of experience administering Hyland Perceptive Content and Hyland Business Insights.
  • Six (6) months of experience with SalesForce customizing applications, building workflows and defining user roles and permissions.
  • Fluid development experience.
  • Experience with live production support of PeopleSoft HCM Systems.
  • Ability to troubleshoot, analyze and research PeopleSoft HCM System related issues and problems.

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process, prior to being appointed into the position. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at http://sfdhr.org/index.aspx?page=456. Employment verification letters should be in the company letterhead, stating the inclusive dates of service and positions held as it relates to the qualifying experience required to be considered for the position.


  • **Applicants must meet the Minimum Qualification requirements by the final filing date unless otherwise noted.**
  • The selected applicant will need to verify qualifying education and/or experience prior to being appointed into the position.
  • 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.  

How To Apply

Applications for City and County of San Francisco jobs are only 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.
  • 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.

In line with the Official Public Health Order to slow the spread of COVID-19, “shelter-in-place” has been issued for all San Francisco residents that is expected to be in effect until further notice.  As a result, Department of Human Resources (DHR)’s office (located at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103) is currently closed to the general public. If you have any questions, please feel free to email the Human Resources Analyst listed on this announcement.

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, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu).

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 Christine Salam, by telephone at 415-557-4881, or by email at christine.salam@sfgov.org.

Notes: 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.

Selection Procedures

Minimum Qualification Supplemental Questionnaire (Weight: Qualifying):
Candidates will be prompted to complete a Minimum Qualifications Supplemental Questionnaire (MQSQ) as part of the online employment application. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications for this position. Applicants must also complete the official application. It is essential that applicants provide complete information in identifying their education, experience and training. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications.

Supplemental Questionnaire Evaluation (Weight: 100%):
Candidates will be prompted to complete an additional supplemental questionnaire as part of online employment application. These supplemental questions are designed to evaluate candidates' relative knowledge, skills and abilities in job-related areas. This may include but not be limited to interviewing people by phone and/or in person, resolving complaints, explaining laws, policies and/or procedures, and working with governmental agencies. Only candidates who have been determined to meet the minimum qualifications of the position will have their supplemental questionnaires evaluated. All relevant experience, education and training must be on the application in order to be reviewed in the rating process. Candidates will be placed on the eligible list in rank order according to their final score. Candidates must receive a passing score to be ranked on the eligible list.

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/Score Report:
A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process 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 12 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/score report 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 https://sfdhr.org/sites/default/files/documents/ASO-Level-Chart.pdf?documentID=21246.



Conviction History

As a selected candidate for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a selected candidate. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:

  • Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
  • Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.

Having a conviction history does not automatically preclude you from a job with the City.

If you are a selected candidate, the hiring department will contact you to schedule a fingerprinting appointment.

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.



Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at: http://www.sfdhr.org/index.aspx?page=20#applicantswithdisabilities.


Information regarding requests for veteran's preference can be found at: http://sfdhr.org/information-about-hiring-process#veteranspreference.
Information regarding seniority credit can be found at: http://www.sfdhr.org/index.aspx?page=20#senioritycredit.



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.


Applicants are encouraged to keep copies of all documents submitted. Submitted documents become a permanent part of the exam records and will not be returned. The hiring department may require applicants to submit the same documents and/or additional documents at a later date.


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


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 of review for appeals is 'abuse of discretion' in establishing the position description, the minimum qualifications and/or 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.

Exam Type: CPE
Issued: 4/5/2021
Carol Isen
Human Resources Director
Department of Human Resources
Recruitment ID Number: PBT-1054- 108533


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, ranging from 7.5%-13.25% 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.


Powered by JobAps