Career Opportunity

Treasury Services Consultant - Office of the Treasurer & Tax Collector (1824) (140291)

Recruitment: RTF0140290-01104937

Published: September 28, 2023

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

About:

Specific information regarding this recruitment process is listed below:
• Application Opening: Thursday, September 28, 2023
• Application Deadline: Thursday, October 19, 2023, 11:59PM (PST)
• Compensation Range: $131,248 - $159,562
• Recruitment ID: PBT-1824-140291

This is a Position-Based Test conducted in accordance with CSC Rule 111A.

Our Mission
The Office of the Treasurer & Tax Collector serves as the banker, tax collector, collection agent, and investment officer for the City and County of San Francisco. As the entity responsible for safeguarding the City’s money, the Office uses this expertise and authority to assist San Francisco residents through award-winning programs and initiatives that help low-income families build economic security and mobility.

Our Vision
We are committed to providing excellent services for taxpayers, customers, and our community. By promoting diversity, equity, and inclusion, we are a stronger, smarter, and more informed government agency.

Role description

The Banking & Treasury Services section of the Office of the Treasurer & Tax Collector manages all the banking and treasury services for the City & County of San Francisco. The section manages, evaluates, negotiates and recommends new treasury products, merchant services, fraud prevention tools to mitigate risk exposure as well as enhance departments’ efficiencies in cash handling and management. There are over 200 banking accounts plus investment instruments supporting the City & County. The section leads strategic planning for the City & County’s banking services. The team conducts Requests for Proposals (RFPs), negotiates contracts and implements new services. The section is the single point of contact for all merchant services (digital payments) and the associated compliance related to those services. Additionally, the section develops citywide policies and procedures related to cash management, regulatory control and compliance issues.

The Treasury Services Consultant (1824 Principal Administrative Analyst) will be the primary liaison for banking and cash management services for approximately 10 to 15 City & County of San Francisco departments. This position will be integral in building and expanding enterprise-wide banking and treasury services. This principal level position will report to the Director, Treasury & Banking Services.

Under current policy, this position supports a hybrid remote work schedule. The incumbent will be required to work a minimum of three (3) days per week in the office.

Essential Duties and Responsibilities:
The essential duties of the position include but are not limited to:

• Cash management and cash handling consulting with departments: Provides banking-related cash management and cash handling advisory services to designated CCSF departments in a consulting model format: prepares and presents scheduled department reviews covering current banking services and fees, bank account rationalization; analyzes and identifies potential fee reductions, discuss challenges and issues regarding departmental working capital and cash management, including accounts payable and accounts receivable; provides guidance and support for the effective receipt of revenues, payment of obligations, internal controls, processing, reconciliation, reporting, and cash handling efficiencies; understands department priorities and recommends solutions, process improvement and risk mitigation opportunities and industry/departmental best practices and trends; serves as the main point of contact, and builds and enhances relationships with departments as a trusted advisor; assists departments with implementations of new services and banking products.
• Strategizing policies, procedures, and regulations: Collaborates with Treasury & Banking Services Director, banking institution partners and stakeholders to strategize and optimize enterprise-wide treasury services; participates in determining preferred state of treasury and cash management by analyzing and evaluating current policies and procedures, identify performance indicators and staff training to achieve the preferred state in compliance with industry policies and regulations.
• Providing training and consultation: Designs and delivers treasury training/knowledge to share to departments and new employees; educate the departments’ treasury personnel on cash management procedures, new bank products, fraud prevention tools, and banking and credit card systems portals.
• Monitoring and auditing results: Develops annual planning calendar and department reviews (annually, semiannually); prepares customized agenda for each department review and regular status reports for management, including quarterly status report to show accomplishments (prior 90 days), upcoming activities (next 90 days), and challenges/items for consideration; prepares scorecard with Treasury Services key performance indicator (KPI) results to measure effectiveness in achieving goals and success.
• Managing the RFP process: Manages the centralized Request for Proposal (RFP) process for all banking products and services including negotiations, contract management and implementation.
• Special Projects: Performs special projects and financial analysis, as assigned.
• May include additional duties as assigned.

How to qualify

MINIMUM QUALIFICATIONS:

Education: Possession of a baccalaureate degree from an accredited college or university; AND

Experience: Five (5) years full-time equivalent experience performing professional-level analytical work. Qualifying professional-level analytical work includes analysis, development, administration, and reporting in major programs and functions of an organization in the areas of budgets, contracts, grants, policy, or other functional areas related to the duties of positions in the 182X Class series.

Substitution: Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework in specialized subject matter areas such as public or business administration, management, business law, contract law, public policy, urban studies, economics, statistical analysis, finance, accounting or other fields of study closely related to the essential functions of positions in the Class series may be substituted for one (1) year of required experience.

Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of 2 years). Thirty (30) semester units or forty-five (45) quarter units equal one year.

Note: One year full-time employment is equivalent to 2,000 hours (2,000 hours of qualifying work experience is based on a 40 hour work week). Any overtime hours that you work above 40 hours per week are not included in the calculation to determine full-time employment.

Desirable Qualifications:
The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring:

• Professional-level financial analysis experience in finance, banking, treasury operations and cash management, or related field.
• Certified Treasury Professional (CTP), Certified Cash Manager (CCM), or Certified California Municipal Treasurer (CCMT) certification is preferred.
• Proven expertise in banking and cash management products, processes, services, controls and risk mitigation.
• Consulting and/or project management experience.

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.

All work experience, education, training, and other information substantiating how you meet the minimum qualifications must be included on your SmartRecruiters application by the filing deadline. Information must be entered into the SmartRecruiters applicant tracking system under the headings for Experience and Education. Leaving these sections blank and attaching a resume in lieu of completing the Experience and Education sections will cause your application to be rejected.

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 includes the following:

Minimum Qualification Supplemental Questionnaire (MQSQ): Candidates will be required to complete a MQSQ as part of the employment application. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQ) for this position. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications.

Written Multiple-Choice Core Examination (Weight: 30%): Candidates will be invited to participate in a written, multiple-choice examination, designed to measure their relative knowledge, skills and abilities in job-related areas. The “core” multiple-choice examination component may include but not be limited to:

• Ability to evaluate/analyze information/data and to exercise good judgment relative to that evaluation or analysis.
• Knowledge of, and ability to apply, financial/fiscal principles (including the ability to use mathematical and statistical formulas).
• Ability to use various computer software programs.

Supervisory Test Battery (Weight: 40%): Candidates who attain a minimum passing score on the written examination component will be invited to participate in a computer-based examination designed to measure competencies in job-related areas which may include but not be limited to: Problem Solving; Leadership; Decision Making; Interpersonal skill; Human Resources Management; Team Building; Communication & Conflict Management.

For more information about this Supervisory Test Battery (and a suggested reading list) please visit: http://www.sfdhr.org/Modules/ShowDocument.aspx?documentid=11676

The above Written Multiple-Choice Core Examination and Supervisory Test Battery components are considered standardized and, therefore, test questions and answers are not available for public inspection or review. Candidates may receive two or more scores in association with the above selection components. One or more will correspond to the core component of the multiple-choice exam component (i.e., core examination and/or one or more specialty areas). Those candidates who participate in the Supervisory Test Battery will attain an additional score. Any scores attained on each of these components will be valid and 'banked' for three years, starting from the date of the examination. This means that, during this three-year time period, you will not be required to take any test components for which you have already attained a score. Your score on the Core Exam is not valid for any other classifications in the Administrative Analyst Series. You cannot apply a score from the Core Exam used for 1820, 1822, or 1823, as it is a different test. The Supervisory Test Battery may be used for many other classes, therefore your test score may be applied to other classes if you choose to apply to future recruitments. If the selection process for the future announcement is held within one year of the date of this examination and it includes any of these components (i.e., core exam, specialty subtest(s) and/or supervisory test battery), your score(s) for the corresponding test component(s) will be automatically applied to that announcement. However, after one year, you have the option to either (a) apply your test score(s) to the other announcement or (b) re-take the test component(s). Re-testing is permitted no sooner than one year from the date of the examination and only in association with your eligibility for another announcement for which the test component (core, specialty subtest or supervisory test battery) is used. Please note that should you re-test, your re-test score would become your official score since it is the most recent.

Supplemental Questionnaire Evaluation (Weight: 30%): Candidates who obtain a passing score both on the Written Multiple-Choice Examination and the Supervisory Test Battery will be sent a Supplemental Questionnaire via electronic mail after the closing of this filing period.

The Supplemental Questionnaire is designed to measure the knowledge, skills and/or abilities in job-related areas required for the position which may include, but not be limited to: Knowledge of: banking operations, processes, terms related to cash management products and treasury services; banking, principles, best practices and techniques for risk mitigation, fraud prevention, and compliance with laws and regulations; Ability to: build rapport and maintain strong customer relationships with banking partners and stakeholders; consult with City departments as a dedicated subject matter expert (SME) for their banking needs; analyze financial systems and procedures related to cash management and banking that impact the overall financial condition and working capital of an agency; manage the centralized Request for Proposal (RFP) process for all banking products and services; interact, coordinate with, establish and maintain effective working relationships with a variety of staff; oral and written communication ability for consulting, training, presenting, leading meetings and projects, and communicating actions and specialized information to a variety of personnel and the public.

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. All applicants’ responses to the Supplemental Questionnaire are subject to verification.

The Supplemental Questionnaire will be rated and scored by our Subject Matter Experts. A passing score on the Supplemental Questionnaire must be achieved in order to be placed/ranked on the Eligible List. Candidates will be placed on the eligible list in rank order according to their final score.

Passing scores on each the Written Multiple-Choice Core Examination, Supervisory Test Battery, and Supplemental Questionnaire Evaluation must be achieved in order to be placed/ranked on the Eligible List.

Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection 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 six (6) months, and may be extended with the approval of the Human Resources Director.

Certification Rule:
The certification rule for the eligible list resulting from this examination will be Rule of Ten.

To find Departments which use this classification, please see https://sfdhr.org/sites/default/files/documents/Forms-Documents/Position-Counts-by-Job-Codes-and-Department-FY-2023-24.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
• Conviction History
• Employee Benefits Overview
• Equal Employment Opportunity
• Disaster Service Worker
• ADA Accommodation
• Veterans Preference
• Seniority Credit in Promotional Exams
• Right to Work
• Copies of Application Documents
• Diversity Statement

HOW TO APPLY:
Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.sf.gov/ 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.

Exam Analyst Information: If you have any questions regarding this recruitment or application process, please contact the exam analyst, Josephine Jackson at josephine.serra@sfgov.org.

All your information will be kept confidential according to EEO guidelines.

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.