Business Analyst

San Francisco, California

City and County of San Francisco
Job Expired - Click here to search for similar jobs
Who We Are

The San Francisco Employees' Retirement System (SFERS) is dedicated to securing, protecting, and prudently investing the pension trust assets, administering mandated benefits programs, and providing promised benefits to the active and retired members of the City and County of San Francisco.

Established in 1889 as a fund for families and orphans of firefighters and police officers, today the San Francisco Employees' Retirement System serves more than 75,000 active, vested, and retired employees of the City and County of San Francisco and their survivors.

What We Do

The Information Systems Division provides department-wide training and support to users of the department's LAN and applications; coordinates City-provided technical services and support with the Department of Technology; manages the functional and technical teams assigned to develop and maintain the department's Pension Administration system and Enterprise Content Management (ECM) project; oversees the department's cybersecurity protocols; and leads the department's disaster recovery and business resumption planning and policy efforts.

Specific information regarding this recruitment process is listed below:

This is a Position-Based Test conducted in accordance with CSC Rule 111A.
  • Application Opening: May 13, 2025
  • Application Deadline: May close at any time, but not before May 28, 2025
  • Recruitment ID: RTF5423
  • Appointment Type: Permanent Civil Service
  • Reporting Location: 1145 Market Street, San Francisco, CA
  • Work schedule: Full time, Monday - Friday, Hybrid Telecommuting work schedule available up to 1 day per week
This job announcement will not close before May 28, 2025. Interested applicants are encouraged to apply as soon as possible.

What We're Looking For

Under administrative direction, the IS Principal Business Analyst at San Francisco Employees' Retirement System is responsible for coordinating with the IS application programming staff and business end users to determine, define and document on-going requirements and new enhancements, recommend design system integration or data interface options, develop and execute testing plans, create and update documentation, provide reports and research data issues and anomalies through queries, and provide training and support for end users.

Essential Duties:
  • Research, analyze, and document business requirements for the Retirement application system (PenAdmin) changes and enhancements.
  • Analyze and resolve complex systems problems.
  • Provide advice and recommendations to meet user needs.
  • Document and submit service requests and trouble reports to implement system changes; participate in the analysis and prioritization of service requests.
  • Respond to report requests and data requests; write and modify PeopleSoft queries as needed to meet business needs.
  • Develop and Test system changes and coordinate testing by end users to ensure functionality and quality of system modifications and enhancements.
  • Lead and coordinate projects, such as Annual Statement, Calendar year-end, and Fiscal year-end processing.
  • Update and maintain systems technical and procedure documentation.
  • Consult on special requests for information and reports; participate in audits, integrated reviews and improvement studies, and quality control reviews.
  • Submit, verify, schedule and transmit files, and interfaces for monthly Retiree Payroll.
  • Administer, remediate, upload PenAdmin data, and maintain the SFERS web presence.
  • Responsible for PeopleSoft Updates (Taxes, PeopleTools, PeopleSoft Images).
  • Perform other related duties as assigned/required.
How To Qualify:

Education

Requires 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 ; AND

Experience

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. This experience must include:
  • Three (3) years experience in PeopleSoft Human Capital Management (HCM) Payroll; AND
  • Three (3) years experience in PeopleSoft Human Capital Management (HCM) Human Resources 9.2; AND
  • Three (3) years of PeopleSoft Query Tools; AND
  • Three (3) years experience in PeopleSoft Security Administration and PeopleTools; AND
  • Three (3) years experience in PeopleSoft Human Resources Application Design and Development
Note: The five (5) years of the required experience MUST have been obtained within the past seven (7) years.

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 or forty-five (45) quarter units with a minimum of 10 semester or 15 quarter units in computer science or a closely related field. .

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 class code.

How to stand out

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.
  • Possession of a baccalaureate degree in Computer Science, Business Administration or closely related field;
  • Experience with PeopleSoft upgrades (PUM);
  • Experience with Oracle database and SQL;
  • Experience with PeopleSoft 9.2 (HCM, Payroll and Pension)
Verification

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

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

Resumes will not be accepted in lieu of a completed City and County of San Francisco application.

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

SELECTION PROCEDURES

After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which include the following:

Minimum Qualification Supplemental Questionnaire (Weight: Qualifying):

Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application. This Minimum Qualification Supplemental Questionnaire 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 Minimum Qualification Supplemental Questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications.

Supplemental Questionnaire Evaluation: (Weight: 100%)

Candidates will be prompted to complete a supplemental questionnaire as part of the online employment application. The Supplemental Questionnaire Evaluation is designed to measure knowledge, skills and/or abilities in job-related areas which may include but not be limited to: knowledge of and demonstrated skills in using the PeopleSoft Query Tool; knowledge of and demonstrated skills in Peoplesoft Human Capital Management Human Resources 9.x; knowledge of and demonstrated skills in Oracle / PeopleSoft applications, including Pension, Payroll, and Human Resources modules; knowledge of and demonstrated ability in Systems Development Life Cycle (SDLC) methodology with emphasis planning, requirements definition, design, testing, documentation, training, and support/maintenance; knowledge of pension, payroll, and human capital business processes; knowledge of training techniques; written communication ability; ability to exercise strong judgment, decisiveness, and creativity; and ability to prioritize competing requests and projects.

A passing score must be achieved on the Supplemental Questionnaire Evaluation in order to be ranked on the eligible list.

Please note that the answers to the supplemental questionnaire will be the main criteria for determining candidates' final scores and advancing to the next step of the selection process.

Applicants meeting the minimum qualifications are not guaranteed advancement in the selection process . click apply for full job details
Date Posted: 16 May 2025
Job Expired - Click here to search for similar jobs