Career Opportunity

Budget System Business Analyst (Hybrid/Remote) - Office of the Controller (1054)

Recruitment: RTF0127052-01144813

Published: October 21, 2022

Apply using SmartRecruiters, the City and County of San Francisco's application portal.

About:

About: 
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 wellbeing 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 problems, 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. Systems Division has a hybrid/remote weekly schedule, working 1 day onsite (in the San Francisco office) and 4 days remote, subject to periodic review and approval.

• Application Opening: 10/21/2022
• Application Deadline: 11/14/2022 
• Compensation Range: $136,162 to $171,288 annually
• Appointment Type:  Permanent Civil Service (PCS)

Role description

The Role
The Budget System Business Analyst reports to the SF Budget System Director. Under general direction of the SF Budget business line, this position serves as technical and functional expert, and administrator for BFM.  The position includes roles and responsibilities in maintaining and supporting BFM, related databases, reports, files and interfaces to ensure all process run smoothly and meet the business needs for the Controller and all City Departments.  This is a hands-on role where the successful candidate will be able to define the work as well as dive in and do the work.  This role will also handle the intake of Budget System-related new requirements or changes as initiatives are defined, as well as manage the projects and changes throughout the development life cycle. 

Key responsibilities include:

• Administer, maintain, and operate citywide budget system BFM, its reporting application SAP BusinessObjects Web Intelligence, databases, files, interfaces and reports used in the Citywide budget process.
• Serve as functional expert in business process and systems analysis, testing, and user support; as technical expert in report building, query and dashboard development, and troubleshooting.
• Analyze the interrelationships of business processes, complex financial and position data to develop reporting requirements and data structures.
• Gather requirements from appropriate process owners, write clear and detailed functional specifications, prioritize features, and drive technical scoping as needed.
• Drive continuous process improvement by collaborating with stakeholders on design of new solutions that enhance business performance and achieve established goals.
• Developing, documenting and testing security roles and permissions.
• Review functional designs and test documentation to ensure they adhere to best practices, meet user needs, and are viable solutions from a technical perspective.
• Document and executes testing requirements and test plans.
• Conducting trainings for end users.
• Ensuring high data quality and process performance of BFM data integrations with internal and external applications
• Identifying, managing, escalating, and resolving issues and risks.
• Troubleshoot and resolve production support issues.
• Partner with SF Budget Advisory Board, including creation of content, leading presentations, and participating in discussions.
• Mentor and develop new functional business analysts.
• Performs other duties as assigned.

How to qualify

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.

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

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 computer science or a closely related field.

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:

• One (1) year of Sherpa Budget Formulation & Management experience.  Verifiable and recent experience with Sherpa Budget Formulation and Management system and its reporting application SAP BusinessObjects Web Intelligence 4.2 SP 8 or higher, performing production support, data analysis, design and testing.

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.

• Professional IS Business Analyst work experience in the Public Sector (Government or Nonprofit).
• Demonstrated strong analytical, planning and organizational skills and abilities.
• Advanced experience with BusinessObjects or similar reporting tools.
• Advanced-level skills in requirements gathering and documenting; preparing functional specification documentation, system and user testing techniques and documentation, process flow and diagramming.
• Demonstrated experience preparing and maintaining user training materials; conducting online user trainings and oral presentations.
• Firm understanding of statistics and databases
• Ability to effectively interact with internal and external City personnel and contractors
• Expert level knowledge of governmental accounting, governmental budgeting, and database development and report writing
• Excellent communication skills.
• Advanced QA and SQL skills.

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 and Special Condition 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.

What else should I know?

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.

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
• Conviction History
• Employee Benefits Overview
• Equal Employment Opportunity
• Disaster Service Worker
• ADA Accommodation
• Right to Work
• Copies of Application Documents
• Diversity Statement
• Veterans Preference
• Seniority Credit in Promotional Exams

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 

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

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.