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

• Application Opening:04/24/2024
• Filing Deadline: 05/03/2024
• Annual Salary:
• Recruitment ID:PBT-1825-144482 / RTF0144481-01083440

San Francisco is a vibrant and dynamic city, on the forefront of economic growth & innovation, urban development, arts & entertainment, as well as social issues & change. This rich tapestry of culture and ideas is sustained by our City's commitment to heighten the quality of life for the diverse population of San Franciscans and residents of the greater Bay Area. Our employees play an important role not only in making our City what it is today, but also in shaping the future of San Francisco.

WHO ARE WE?
We are the . Headquartered in San Francisco, we have 2,300 employees operating across eight counties serving more than 2.7 million customers in the San Francisco Bay Area - 24 hours per day, 365 days per year.

Our Mission: To provide our customers with high quality, efficient, and reliable water, power, and wastewater services in a manner that values environmental and community interests and sustains the resources entrusted to our care.

Our Vision: We are an innovative utility leader, recognized for excellent results in service, safety, stewardship, and inclusiveness.

More About SFPUC: We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. To learn more about our organization, please visit our website at . We are proud of our infrastructure and programs, but most importantly, we value our highly qualified and dedicated workforce which ensures that this vision becomes a reality. To learn more about working at the SFPUC, visit our career site at

Diversity, Equity, and Inclusion: The City's Department of Human Resources (DHR) is committed to providing a diverse, equitable, inclusive, and belonging environment for the City and County of San Francisco, where all employees and prospective employees experience fairness, dignity, and respect. DHR's mission is to use fair and equitable practices to hire, develop, support, and retain a highly-qualified workforce. The resources support and expand on the Mayor's Executive Directive 18-02, "Ensuring a Diverse, Fair, and Inclusive City Workplace."

ABOUT CAPITAL FINANCE

The Capital Finance group sits within Financial Services in the San Francisco Public Utilities Commission and is a team of five professionals supporting the agency's capital financing activities including capital markets transactions, banking agreements, commercial paper program activities, credit rating activities, investor relations and debt administration, among others. Under the leadership of the Capital Finance Director, the team manages the day-to-day administration of the SFPUC's more than $9.35 billion outstanding debt portfolio. The team manages the daily operations of the SFPUC's $1.5 billion Interim Funding/Commercial Paper Programs across three enterprises, Water, Wastewater and Power (including the administration of 12 series of commercial paper, two revolving loans, and one credit agreement with separate bank facilities and multiple dealers), multiple federal WIFA loans, State Revolving Fund loans and other new financing tools. The team is actively involved in exploring new financial tools, including joint financing arrangements and new federal tax credits, as the SFPUC's capital needs evolve and based on new governance structures and federal and state initiatives.

The Capital Finance team leads the issuance of new financing, with the largest share of borrowing through tax exempt enterprise revenue bonds for the SFPUC's four distinct rated credits. The SFPUC's current adopted 10-year financial plan (2025-2034) calls for the issuance of an additional $3.4 billion of Water financing, $6.2 billion of Wastewater financing and $1.5 billion of Power financing, or more than $11.1 billion of financing over the next decade.

Since 2015, the SFPUC has issued more than $4.4 billion in green bonds to finance Water, Wastewater, and Power capital projects that advance climate change mitigation or adaptation, making the SFPUC one of the largest, most innovative and most recognized municipal issuers of green bonds in the United States.

Position Summary

Under general direction of the SFPUC Capital Finance Director, the Principal Administrative Analyst II (Capital Finance) functions as a member of the Capital Finance team responsible for managing and performing professional-level analytical work to support funding for the capital programs of the SFPUC's Water, Wastewater, Power Enterprises and CleanPowerSF Program. The Principal Administrative Analyst manages, plans, organizes, leads and/or participates in complex, sensitive, and detailed analytical work in the areas of budget, financial/fiscal, economic, legislative and administrative policy and/or contract administration.

This position will be responsible for managing all aspects of bond transactions, including ongoing bond compliance and administration, as well as other special projects and analyses. The Analyst will assist in the structuring of both new money and refinancing transactions through the public capital markets or direct placements with federal and state programs, working closely with the Loans and Grants team which assists in applying for such facilities. The position includes close coordination with divisions and leadership throughout the SFPUC to determine the timing and sizing of debt issuances. The Analyst will provide difficult, complex, sensitive, detailed analytical work to help manage the SFPUC's debt portfolio, including analysis and recommendations involved in debt finance risk management, issuing new debt, developing policy and procedures, monitoring and administering debt portions of the ten-year financial plan and preparing a variety of comprehensive, complex and sensitive financial reports for a variety of audiences. This position involves working with attorneys in the drafting and understanding of detailed legal documents governing such financial programs.

In addition to the primary responsibilities referenced above, the position will support general debt activities in coordination and collaboration with other analysts on the team, as well as municipal advisors, consultants and legal counsel:

The essential job functions include, but are not limited to, the following:

• Prepare complex financial analysis and reports that involve, but are not limited to, interest calculations, time value of money concepts, future value, present value, net present value, and amortization analysis.
• Prepare financial memos and reports to management for ongoing projects and new project analysis. Ability to construct and explain analysis both verbally and in writing is critical, as is ability to perform financial policy impact analysis including analyzing and recommending alternative courses of action and project consequences.
• Manage the preparation of financial information to capital market audiences (i.e., bond investors,rating agencies). Interpret complex financial information and present it in a clear, concise and simple-to-read format. Requires data analysis to determine the best format of presentation; data gathering of historical information; reviewing historical trends; and presenting future planned financial forecast.
• Review data to update the SFPUC's municipal bond offering document called the Official Statement. Requires close coordination with other SFPUC departments to gather key information and to ensure the information is accurate and received timely so it can be disseminated to potential investors of the SFPUC's revenue bonds.
• Manage the disclosure of financial information to the capital markets following the Securities and Exchange Commission rules and regulations (15c2-12).
• Post reports to publicly available websites to ensure all bondholders are aware of any financial actions relating to the SFPUC. This position will also be responsible for managing the content of the "Debt Management and Disclosure Reports" page on the SFPUC's official website (www.sfpuc.org), which acts as a central information point related to the SFPUC's debt program.
• Bond Arbitrage Rebate data compilation: Requires technical analytical research of interest earnings and expenditure reporting to determine if any excess interest earnings should be remitted to the Internal Revenue Service as per federal tax laws. This is performed on an annual basis.
• Bond Tax Diligence: Requires researching finance data extending 10 years prior. Refunding of past bonds may require up to four months of extensive research into the City and County of San Francisco's F$P Financial Information System and accounting data on how the use of the bond proceeds was spent and for what type of projects. This requires extensive knowledge of the City's accounting and financial reporting system to ensure that all bond proceeds were used in accordance with federal tax laws. Compilation and development of reports for review by tax attorneys.
• Commercial Paper Program administration: Assist with the daily operations of issuing and managing commercial paper for the SFPUC's Water, Wastewater and Power Enterprise Commercial Paper Programs. Track expenditures, prepare tax reports, wire funds, and interact with commercial paper dealers and other financial institutions that support the program. Prepare extensive tracking and reporting systems. Create procedures and record keeping systems. Work with the SFPUC's Financial Advisors to ensure that the commercial paper program is functioning properly. Use on-line banking systems to create reports via the web.
• Contract Administration for Finance Professional Services: The SFPUC's Capital Finance Group utilizes a large group of outside municipal bond finance experts to carry out the issuance and refunding of bonds for capital projects, as well as other debt-related activities. This task requires developing RFQ/RFPs, coordinating selection process, preparing contracts, and analyzing the overall financial performance of the contracts. Analyzing monthly invoices from professional consultants against tasks and deliverables to ensure they were completed on time and within budget and scope according to contract guidelines. Preparing quarterly financial expenditure reports for all professional service contracts and prepare report to management staff.
• Prepare SFPUC Commission Agenda Packets: Draft Commission staff reports and presentations for various functions, from requesting authorization to issue a request for proposal to award a contract to a supplier after a selection process. Prepare presentation talking points for the Capital Finance Director or other senior managers making the presentation to the Commission.
• Help to respond to requests of the independent appointed Revenue Bond Oversight Committee (RBOC) which meets monthly to oversee the expenditure of bonds proceeds.
• Serve as the primary point of contact for RBOC auditors and other financial auditors in addressing financing program questions.
• Management of Bond Funds: In coordination with Accounting and the Controller's Office, assist in the management of bond funds. Requires complex analyses of fund balances and ensuring that fund amounts match appropriation levels from the Board of Supervisors. Preparation of complex Supplemental Appropriation packages to the SFPUC Commission, Mayor's Office, Controllers' Office and the Board of Supervisors.
• Special projects to provide backup to staff in the areas of bond financings, general compliance reports, accounting, financial reporting, and provide assistance to the associated SFPUC groups when needed.
• Manage and train future new Capital Finance entry level (1823) hires.
• Performs related duties as required within the scope of the classification 1825 Principal Administrative Analyst II.

If you are interested in this job, we are looking for people that have the following minimum qualifications:

Education:

1. Possession of a baccalaureate degree from an accredited college or university.AND

Experience:

1. Seven (7) years of 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 (i.e., 1824, 1823, etc.).

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.

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): (Weight: Qualifying)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.

Supplemental Questionnaire Examination: (Weight: 100%)

Candidates who meet minimum qualifications will be invited via a separate link to complete the Supplemental Questionnaire Examination. The purpose of the Supplemental Questionnaire Examination is to evaluate the experience, knowledge, skills and abilities that candidates possess in job-related areas, which have been identified as critical for this position and include, but are not limited to: Knowledge of the principles and techniques of financial accounting and budgeting, especially related to municipal financing; Ability to collect, synthesize, and analyze a wide variety of information and data; Ability to plan, prepare, review, and present clear and concise findings and reports; and Ability to communicate effectively, orally and in writing, with management, officials, representatives of other agencies, and the general public.

Applicants will be given a deadline to return the Supplemental Questionnaire Examination. 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 the eligibility list resulting from this process. All applicants' responses to the Supplemental Questionnaire Examination are subject to verification.

A passing score must be achieved on the Supplemental Questionnaire Examination in order to continue in the selection process and be placed on the eligible list. Candidates will be placed on the eligible list in rank order according to their final score. Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.

The department may administer additional position-specific selection procedures to make final hiring decisions.

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

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

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.

Analyst Information: If you have any questions regarding this recruitment or application process, please contact the analyst Eric Christensen at EChristensen@sfwater.org.

Please note: 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.