Job Information
City and County of San Francisco PeopleSoft Principal Business Analyst (Hybrid Workplace) - Controller's Office (1054) 146474 in San Francisco, California
This is a Position-Based Test conducted in accordance with CSC Rule 111A.
PeopleSoft Principal Business Analyst - Office of the Controller, Systems Division (1054)
Hybrid Workplace:
Our workplace has a hybrid/flexible weekly schedule, where colleagues work 1 day onsite (in the San Francisco office) and 4 days from home, subject to periodic review and approval.
Controller’s Office
The Controller is the City’s chief financial officer. Our team includes financial, technology, analytical, and other professionals who work hard to secure the City’s financial integrity and promote efficient, effective, and accountable government. We hold ourselves to high standards and strive to be a model for good government. We value the diverse backgrounds, perspectives and lived experiences of our teams and clients in everything we do. We work in a collaborative and inclusive environment, promote equal opportunity, and invest in the professional development and well-being of our team members. You can expect to work alongside colleagues who are committed to serving the public with integrity and want to see positive impacts from their work. We are looking for smart, motivated individuals who want to make a difference and use government to play a role in solving our City’s issues, including addressing long-standing and harmful disparities in our communities. For a career with purpose and professional growth, join us in the Controller’s Office!
Systems Division of the Controller’s Office:
The Systems Division of the Controller’s Office manages the City and County of San Francisco’s Enterprise Oracle and PeopleSoft Applications, which include Oracle Interaction Hub, PeopleSoft Human Capital Management (HCM), PeopleSoft Financials and Supply Chain Management (FSCM), PeopleSoft Enterprise Learning Management (ELM), and Oracle Business Intelligence. These applications are branded locally as our SF Employee Portal, SF People & Pay, SF Financials, SF Procurement, SF Learning, and SF Reports and Analytics systems. Collectively, these applications provide a robust, integrated platform that delivers mission-critical services to 55 City Departments, eliminating the need for hundreds of independent legacy systems and customized applications. The division serves over 35,000 active City employees, 75,000 retirees and 25,000 City vendors (bidders and suppliers). Peripheral and legacy applications also leveraged by the division include Oracle Identify & Access Management, Sherpa Budget Formulation & Management, Phire Architect, Control-M, and FreshWorks. The technology implemented and maintained by the Systems Division provides standardization, transparency, and efficiency for the City’s crucial business processes. Users are fully supported to ensure adoption of these interconnected functionalities.
Specific information regarding this recruitment process are listed below:
Application Opening: 5/202024
Application Deadline: 6/3/2024
Compensation: $142,714 - 179,530
Recruitment ID: PBT-1054-146474
Essential duties will vary based on assignment of Supervision, Project Leader, and/or Expert.
When assigned to the Supervision specialty, essential duties include but are not limited to:
May supervise, assign, review and participate in the work of Business Analysts, Programmer Analysts, technical, clerical and other functional staff in the assigned work unit.
Ensure that appropriate policies and procedures are followed by subordinates; review and recommend a variety of personnel actions in such areas as performance evaluation, training, selection and disciplinary measures.
Analyze and recommend procedures consistent with departmental directives and policy regulations that are developed by higher-level management staff.
Analyze and resolve complex system problems; develop and implement modification as necessary; prepare special reports; maintain records of system documentation.
Consult on special requests for information and reports; participate in audits, integrated reviews and improvement studies, and quality control reviews.
Monitor, coordinate and assist in developing the assigned work unit budget.
Provide advice and recommendations to meet user needs.
Coordinate system related activities with other departments for multi-departmental system projects.
Manage complex systems; lead and schedule multiple projects; plan, analyze and develop new systems; develop enhancements to systems; analyze procedures; develop conversion plans; move data from one system to another; provide user training.
Review plans for software, hardware and telecommunications equipment and services; prepare specifications; oversee request for proposal process.
Develop annual MIS plans, including budgeting, configuring, and purchasing hard and software.
Monitor and review work in progress, providing technical assistance and guidance.
Manage and monitor progress of contractors and vendors; facilitate contract payments; participate in the request for proposal process and re-negotiate amendments; resolve problems.
Manage and design the structure and growth of computer and telecommunications systems and networking; design, develop and implement new systems to support departmental activities; set scope, boundaries and objectives for system functions interfaces based on departmental needs.
Attend meetings as needed; represent unit on committees.
When assigned to the Project Leader specialty, essential duties include but are not limited to:
May coordinate a team of workers which may include professional, technical and/or clerical staff within the assigned work unit or jointly with other units.
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.
Determine allocation of resources and installation schedules; prepare feasibility studies; determine operating characteristics and requirements; monitor and report progress of work.
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.
Assure coordination and intra-network compatibility; assist with integration of manual and automated system procedures.
Coordinate multi-vendor support for the technical and administrative resolution of network troubleshooting problems.
Recommend contractor selection, may review contractor and vendor billings; monitor and evaluate quality of contractor/consultant products and services; coordinate interactions and activities of vendors.
Analyze regulatory rules and regulatory issues for their impact on current operations.
Provide technical support services to other agencies and departments.
Develop training exercises for subordinate staff and maintain technical education; may coordinate and/or present training classes.
Create work plans and monitor progress of project tasks; review staff work and train staff relating to the project work.
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.
May oversee certain project related production functions.
Monitor project related work schedules and completion dates.
Coordinate and/or attend project team meetings and user meetings.
When assigned to the Expert specialty, essential duties include but are not limited to:
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; 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; train users on new applications.
Develop or modify system design: write detailed design specifications.
Provide advice on the functionality of new programs and compatibility of modifications to ensure user needs are met.
Evaluate software and hardware products on multiple platforms; make recommendations for compatibility, based on user requirements and systems analysis.
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.
Coordinate the efforts of analysts, engineers and operators in the implementation of projects spanning multiple systems and sites; multiple platforms.
Manage and monitor the progress of contractors and vendors; resolve problems.
Education:
An associate degree in business administration, public administration, information systems, economics, finance, 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 one of the fields above or a closely-related field].
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.
License and Certification:
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 / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in one of the fields above or a closely related field.
Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.
Desirable Qualifications:
The stated desirable qualifications will be used to identify job finalists at the end of the selection process when candidates are referred for hiring.
Experience with PeopleSoft Human Capital Management (HCM), PeopleSoft Financials & Supply Chain Management (FSCM) modules, and/or PeopleSoft Enterprise Learning Management (ELM); version 9.2 or higher.
Experience with other Enterprise Resource Planning (ERP) systems or HR-specific systems.
Experience with Oracle Business Intelligence Enterprise Edition (OBIEE) or similar data warehouse system.
Professional IS Business Analyst work experience and/or management in the Public Sector (Government or Nonprofit).
Experience preparing and maintaining user training materials and conducting online user trainings and oral presentations .
Experience with service request and incident management procedures in an Information Technology Service Management (ITSM) ticketing/service desk application .
Proven ability to interact skillfully and tactfully with all levels of staff and management.
Project Management Certification or demonstrated experience in project management (applies to “Project Leader” specialty assignment).
Demonstrated strong analytical, planning, and organizational skills and abilities.
Experience diagramming business process flows, including roles, responsibilities, policies and business requirements.
Experience linking business processes with the setup and business rules of the PeopleSoft system.
Understanding of the processes and methods employed to perform requirements gathering, fit/gap analysis, and test planning; defining and implementing application configuration settings.
Experience cleaning and verifying data during conversion.
Experience performing complex data analysis.
Experience leading project teams by assisting department managers on transition plans for re-engineered business processes.
Experience collaborating with internal teams to develop functional and technical designs.
Experience developing test plans, conducting testing, design, and development of external interfaces.
Experience developing, documenting and testing security roles and permissions based on business process requirements.
Experience identifying, managing, escalating and resolving issues and risks related to development requests, functional design approach, implementation, requirements and/or scheduling.
Experience keeping functional documentation up-to-date and developing documentation for standards through feedback and updates received from the technical team.
Experience supervising support resources, including recruiting, hiring, setting performance goals and writing reviews for subordinate staff (applies to “Supervision” specialty).
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 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.
Important: 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:
Applications will be screened for relevant qualifying experience. Additional screening mechanisms may be implemented in order to determine the applicants’ qualifications. Only those applicants whose backgrounds best match the position will be invited to participate in the selection process. Applicants meeting minimum qualifications are not guaranteed advancement in the selection process.
After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:
Minimum Qualification Preliminary Questionnaire (Weight: Qualifying) Candidates will be required to complete a Questionnaire as part of the employment application. This is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQ) for this position. The questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications.
Supplemental Examination (Weight: 100%)
Candidates who meet the minimum qualifications will be emailed a Supplemental Questionnaire. The Supplemental Questionnaire is designed to measure the knowledge, skills and abilities required for this position. All candidates’ responses to the Supplemental Questionnaire are subject to verification. All relevant experience, education and/or training must be included in the responses in order to be reviewed in the rating process.
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 of 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 here (https://sfdhr.org/sites/default/files/documents/Forms-Documents/Position-Counts-by-Job-Codes-and-Department-FY-2021-22.pdf) .
Terms of Announcement and Appeal Rights:
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 https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ .
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.
Additional Information Regarding Employment with the City and County of San Francisco:
Information About the Hiring Process (https://sfdhr.org/information-about-hiring-process)
Conviction History
Employee Benefits Overview (https://sfdhr.org/benefits-overview)
Equal Employment Opportunity
Disaster Service Worker (https://sfdhr.org/disaster-service-workers)
ADA Accommodation
Right to Work (https://sfdhr.org/information-about-hiring-process#identification)
Copies of Application Documents
Diversity Statement (https://sfdhr.org/information-about-hiring-process#diversitystatement)
Veterans Preference
Seniority Credit in Promotional Exams (https://sfdhr.org/information-about-hiring-process#senioritycredit)
HOW TO APPLY
Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process.
- Select the “I’m Interested” button and follow instructions on the screen
Applicants may be contacted by email about this recruitment 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, @smartalerts.info, and @smartrecruiters.com).
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.
If you have any questions regarding this recruitment or application process, please contact the analysts Vicente Centeno at Vicente.Centeno@sfgov.org
The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.