1053 PeopleSoft Technical Analyst

Recruitment #TEX-1053-092649


Controller's Office Systems Division

City Job Classification:  1053 IS Business Analyst - Senior

Technical Business Analyst

PLEASE NOTE: 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.


The Controller's Office manages the following enterprise-wide systems for the City: PeopleSoft Financials & Supply Chain Management, PeopleSoft Human Capital Management, PeopleSoft Enterprise Learning Management, PeopleSoft Interaction Hub, Cognos Business Intelligence, and Informatica. For our PeopleSoft systems, we strive to keep updating to the latest version of the applications and People Tools.

The Controller’s Office is committed to enhancing and expanding application functionality to better support our users’ changing needs.  Over the last 5-year period, we have launched new applications and products that have greatly increased and diversified our user base and amplified the need to improve how we assist our business partners to drive stakeholder value and desired business outcomes. 

The Senior Functional Business Analyst will perform and participate in a range of business systems analysis and production support tasks. The analyst will provide advanced level of operational and batch support to the ELM, HCM, and FSCM applications. Batch processing includes PeopleSoft Process Scheduler, BMC Control-M scheduling systems, and GlobalScape secured transmission (sFTP) system.

Essential duties include but not limited to:


  • Link business processes with the setup, rules, workflow, and batch processing to the ELM, HCM, and FSCM applications
  • Define and implement application and scheduling system configuration settings
  • Analyze the feasibility of and develop requirements for systems, batch processes, and enhancements to existing or new systems; ensure the system design fits the needs of the users
  • Identify and be on guard for opportunities for business processes improvement through automation
  • Gather business requirements, perform fit/gap analysis on new and modified batch processes
  • May install and enhance software; program, test, debug and install new/modified programs
  • Consult on the analysis of an application; troubleshoot system problems; implement solutions
  • Identify, manage, and escalate issues and risks throughout software development life cycle
  • Conduct system analysis and may conduct programming activities for complex systems; document new and modified systems and programs; coordinate user training in new capabilities
  • Interface with inter-connecting city departments and external vendors to determine system needs and requirements
  • Prepare, or assist client in preparing service requests to implement system changes; determine level of effort required and the cost of implementing service requests; prioritize requests.
  • Provide technical production support for on-line and batch systems; assist with set processing schedule; update and produce reports
  • Coordinate with outside vendors and contractors to complete projects and service requests; define, assign and evaluate their work
  • May determine structure of databases; normalize data; perform conversion of data between platforms; design, develop and generate routine and ad hoc reports in response to user needs
  • Determine security levels for systems to ensure data integrity; test database applications to assure functionality and effectiveness in performing to desired specifications
  • Research and evaluate software on multiple platforms; assist in developing the evaluation criteria for software
  • Determine operating characteristics and requirements; develop or modify and document general system/process design; write detailed design specifications; conduct "walkthroughs" for proposed solutions to system problems
  • Keeping up-to-date functional and technical documentation
  • Performing 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.

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.

Desirable Qualifications:

  • Professional IS Business Analyst work experience in the Public Sector (Government or Nonprofit).
  • Familiarity with Tier-1 ERP systems.
  • Advanced functional and technical skills in some of the following PeopleSoft modules: general ledger, accounts payable/receivable, purchasing, services contracting, construction contracting and/or supplier management in a large government or highly regulated environment.
  • Developing reports and metrics to assist in documenting production support activities and enhancing production efficiency and effectiveness
  • Demonstrated experience preparing and maintaining user training materials; conducting online user trainings and oral presentations.
  • Three (3) years of experience analyzing, creating, documenting functional business/application solutions with clients and/or end users for large complex systems.  This experience must include:
  • Working knowledge of formal software development life cycle methodologies; 
  • Working knowledge of job scheduling system, such as BMC’s Control-M
  • PeopleSoft HCM and/or FSCM module functionality, fit/gap analysis, customization, and testing strategies;
  • Technical design and development experience with PeopleSoft Development Tools (PeopleTools 8.5x, Application Designer, PeopleCode, SQR, Process Scheduler and PeopleSoft Query;
  • Demonstrated expertise in utilizing appropriate tools for analyzing data, documenting processes, developing and testing prototype solutions (for example SQL, Excel, Visio, MS Access);
  • Demonstrated understanding of Oracle relational databases.

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://sfdhr.org/how-verify-education-requirements

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.

All City and County of San Francisco employees are required to be vaccinated against COVID-19 as a condition of employment.  For details on how it is applicable to your employment, please click here.

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

The selection process will include evaluation of applications in relation to minimum requirements. Applicants meeting the minimum qualifications are not guaranteed advancement to the interview. Depending on the number of applicants, the Department may establish and implement additional screening mechanisms to comparatively evaluate the qualifications of candidates. If this becomes necessary, only those applicants whose qualifications most closely meet the needs of the Department will be invited to participate in the oral/performance interview.

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.


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: 

Issued:  8/XX/2021
Carol Isen
Human Resources Director
Department of Human Resources
Recruitment ID Number: 092649
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.


Click on a link below to apply for this position:

Fill out the Application NOW using the Internet.

Powered by JobAps