1053 IS Business Analyst-Senior, PeopleSoft HCM Payroll

Recruitment #PBT-1053-096996


Sr. Functional Business Analyst - People & Pay, Payroll Team
City Job Class:  1053 IS Business Analyst Senior
PeopleSoft Financials & Supply Chain Management System (FSCM)

Controller’s Office -  Systems Division

Please Note:  This examination announcement was amended to update the Certification Rule. 
The Controller’s Office recently completed a successful multi-year project to implement the City’s new Financial and Procurement System for the City and County of San Francisco (City). This new system replaced FAMIS, the City’s former central system of financial record and budgetary control, and includes additional functionality that was previously handled by a number of ancillary departmental systems. The transformational project implemented 17 modules within the PeopleSoft Financials & Supply Chain Management (FSCM) enterprise resource planning system suite. Oracle Business Intelligence (BI) was also implemented as the City’s new data analytics and reporting platform.

The Systems Division within the Controller’s Office manages the following enterprise-wide systems for the City:  Oracle Interaction Hub, PeopleSoft Human Capital Management, PeopleSoft Financials & Supply Chain Management, PeopleSoft Enterprise Learning Management, Oracle Business Intelligence, Cognos Business Intelligence, and Informatica.    

Position Description 

The Senior Functional Business Analyst position is responsible for the business analysis process and documentation which involves acquiring and documenting knowledge from subject matter experts throughout various City and County of San Francisco Departments and for translating this knowledge into functional solutions that are designed, tested and implemented in the PeopleSoft system.  Essential duties include but are not limited to:  diagramming policies and processes of the business practices and requirements; linking business processes with the setup and business rules of PeopleSoft Human Capital Management software; requirements gathering, fit/gap analysis; defining and implementing application configuration settings; performing complex data analysis; working with change management  team to  re-design business processes; conducting trainings for end users; create functional designs; creating test plans; executing testing; analyzing and testing of security roles and permissions; identifying, managing and escalating issues and risks throughout the software development life cycle, supporting system readiness and performance during payroll processing, including applying and testing tax updates, and analyzing and programming system changes required to implement new functionality, updating functional documentation to reflect these changes;  performs other duties as assigned.

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].

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

License and Certification:


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 listed above, this position has additional requirements. In order to qualify for any of this position, applicants must meet the following Special Conditions:

- Two (2) years of PeopleSoft HCM Payroll experience

The above minimum qualifications reflect special conditions associated with the position(s) to be filled. They may differ from the standard minimum qualifications associated with this classification. 

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.


  • Functional expertise in PeopleSoft Human Capital Management;
  • Working knowledge of business process flows used to support human resource, time and labor, and payroll enterprise software systems;
  • Experience developing business process and software development release projects;   
  • Two (2) years defining, planning and executing business process change initiatives coincident with enterprise information system implementations;
  • Expertise in utilizing appropriate tools for documenting processes, developing and delivering training, and performing help desk activities, for example Visio, screen capture tools, streaming video;
  • Understanding of PayMatch payroll compare application configuration and ability to utilize to analyze payroll data across systems;
  • Professional IS Business Analyst work experience in the Public Sector (Government or Nonprofit);
  • Recent experience in PeopleSoft Upgrades;  
  • Three (3) years experience analyzing, creating, documenting functional business/application solutions with clients and/or end users for large complex systems. 
  • Demonstrated experience using formal software development life cycle methodologies
  • Two (2) years experience with configuration and business processes used to support PeopleSoft Time & Labor or Payroll for North America or Absence Management Modules in PeopleSoft V8.9 or greater (8.9, 9.0, 9.1, 9.2)
  • Demonstrated experience developing queries using PeopleSoft Query to meet end user requirements
  • Demonstrated experience participating in requirements gathering and documentation sessions, including preparing functional requirements documentation
  • Expertise in utilizing data analysis tools
  • Expertise in utilizing tools for documenting processes, developing and testing prototype solutions, which must include using Microsoft Excel. 
  • Experience in PeopleSoft Modules: Absence Management, Time and Labor, Payroll for North America, Human Resources and Benefits;
  • Experience supporting payroll operations units with PeopleSoft Modules: Payroll, Absence, Time and Labor, Human Resources and Benefits, including Calendar and Fiscal Year End Activities.


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

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, @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 the exam analyst, Vicente Centeno, by telephone at (415) 554-7506, or by email at Vicente.Centeno@sfgov.org


Selection Procedures

Supplemental Questionnaire: (Qualifying) 

You will be prompted to complete a Supplemental Questionnaire as part of the online employment application.  The purpose of this Supplemental Questionnaire is to determine your experience, training and education as they relate to the job-related knowledge, skills and abilities needed to perform the essential functions of Class 1053.  Responses on this Supplemental Questionnaire will be evaluated to determine if you meet the minimum qualifications and special conditions for this classification.  


Supplemental Examination: (Weight 100%)

Candidates who meet the minimum qualifications and special conditions will be sent a Supplemental Questionnaire via electronic mail after the closing of this filing period.  The Supplemental Questionnaire Evaluation serves at the examination for this position and is designed to measure knowledge, skills and/or abilities in job-related areas.  A passing score must be achieved on the Supplemental Questionnaire Evaluation in order to continue in the selection process.  A Supplemental Questionnaire will be emailed after the closing of this filing period.  Applicants will be given a deadline to return the Supplemental Questionnaire.  Those who do not respond by the established deadline will not be eligible to continue in the examination process and will not be added to eligibility list resulting from this process.



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). Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.

Applicants will 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.

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.


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 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/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.

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

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. 

Seniority Credit in Promotional Exams:  Information regarding seniority credit can be found at: http://www.sfdhr.org/index.aspx?page=20#senioritycredit

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://sfdhr.org/information-about-hiring-process 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.

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.


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: 


Exam Type: CPE 
Issued: 5/17/2019
Amended:  5/29/2019
Micki  Callahan
Human Resources Director
Department of Human Resources
Recruitment ID Number: PBT-1053-096996
CON/CV/ 415-554-7506



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