Career Opportunity

Administrative Analyst - Capital Projects & Grants, Accounting Services, SFPUC (1822)

Recruitment: REF32079H

Published: September 19, 2023

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

About:

• Application Opening: September 18th, 2023
• Application Deadline: October 2nd, 2023 
• Compensation Range: $97,266 - $118,248
• Recruitment ID: REF32079

APPOINTMENT TYPE: Temporary Exempt: This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer. The duration of the appointment shall not exceed 36 months. 

WHO ARE WE? 

San Francisco Public Utilities Commission (SFPUC)

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.

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 https://www.sfpuc.org/.

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 https://www.sfpuc.org/about-us/careers-sfpuc

Role description

Project Name: State Revolving Fund (SRF) & Water Infrastructure Finance and Innovation Act (WIFIA) Loans         

Under direction, the Administrative Analyst performs difficult and detailed professional-level analytical work in a variety of functional areas, such as; development and administration of competitive bid processes and contractual agreements; grant administration and monitoring; budget development and administration; legislative analysis; development and evaluation of management/administrative policy; program evaluation and planning; or complex financial/fiscal analysis and reporting.

ESSENTIAL DUTIES OF THIS POSITION INCLUDE, BUT ARE NOT LIMITED TO:

• Perform day-to-day detailed and complex financial accounting aspects of capital programs and projects, including Water, Sewer, and Hetchy System Improvement programs funded by revenue funds, revenue bonds, commercial paper, grants, and State Revolving Fund (SRF), and Water Infrastructure Finance and Innovation Act (WIFIA) Loans.
• Prepare and request new Chart of Accounts set up forms, including new SRF and WIFIA Funds and Grants/Loans Projects and Project Activities.
• Run Oracle Business Intelligence (BI) reports from various PeopleSoft modules for the SRF Disbursement requests and WIFIA Quarterly Reporting.
• Assist in analyzing, reconciling, and reviewing the SRF disbursements package and WIFIA Quarterly Reporting.
• Prepare SRF and WIFIA Loans budget set-up, expenditures abatements from bond funds to loan funds, Revenue, and Account Receivable recording journals in PeopleSoft.
• Prepare and review Contract and Purchase Orders set up, deliverable and compliance requirement reviews, progress payments, and monitoring reports for the PUC as a grantor, including Green Infrastructure Grant Program and Wastewater Flood and Stormwater Management Program.
• Perform complex accounting functions consistent with Generally Accepted Accounting Principles (GAAP), Government Accounting Standards Board (GASB) standards, auditing procedures, and City policies and procedures in connection with budget preparation, purchasing activities, payroll analysis, and grants management.
• Validate and process various accounting documents and transactions in conformance with established procedures and controls.
• Review, reconcile and validate accounting records of receipts, disbursements, and encumbrances to ensure fiscal accuracy and control.
• Analyze and prepare monthly Bureaus overhead allocation journals entries and work with the Budget Finance and Program Managers to resolve the funding issues.
• Analyze and prepare Water, Wastewater, and Hetchy Revenue Bonds debt service payments and State Revolving Fund (SRF) loans repayments.
• Ensure SRF Loans Disbursements and WIFIA Loans Quarterly Reports review processes comply with the State Water Resource Control Board (SWRCB) and the Environmental Protecting Agency (EPA)’s mandated guidelines and the Federal Single Audit Reporting requirements.
• Assist with implementing enhanced, efficient, and timely SRF and WIFIA reimbursements and quarterly reporting review processes in collaboration with the SFPUC Infrastructure Bureau.
• Support year-end closing activities, including retention and outstanding invoices accruals, estimates, and encumbrance carryforwards.
• Assist the coordination of grant Post Audit and Federal Single Audit under Uniform Guidance by preparing audit schedules, including the Single audit questionnaire and the Schedule of Federal Expenditures (SEFA), Provide samples and clarification on the operating processes, policies, and procedures.
• Prepare and pre-audit accounting documents, transactions, and audit schedules in conformance with established procedures and controls.
• Maintain and stay current on knowledge of applicable ordinances, rules, regulations, policies, and standards affecting accounting and financial transactions.
• Support identification, creation, and maintenance of accounting codes and structures to ensure accurate recording, reporting, and control in PeopleSoft.
• Perform the job duties for special projects and other tasks as assigned.

How to qualify

Possession of a baccalaureate degree from an accredited college or university, and one (1) year 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 areas such as 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 the required one (1) year of 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.

Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.

“The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.”

Verification of Education and Experience:

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. Education verification information on 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 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.

What else should I know?

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

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 Human Resources Analyst, Rocio Mendoza at Rmendoza@sfwater.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.