Career Opportunity

Junior Administrative Analyst – Infrastructure –San Francisco Public Utilities Commission (1820) (142554)

Recruitment: RTF0142553-01155898

Published: January 17, 2024

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

About:

• Application Opening: 01/17/2024
• Application Filing Deadline: 01/24/2024
• Annual Salary: $75,608 to $91,936
• Recruitment ID:  RTF0142553-01155898 (TEX-1820-142554)

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

Special Project:  State Revolving Fund (SRF) and Water Infrastructure Finance and Innovation Act (WIFIA) Loan Reimbursement/Report                                                                                                                                                                                      

Under general direction, the 1820 Junior Administrative Analyst will perform detailed professional-level analytical work for the Payment Processing Unit of the Infrastructure Budget & Finance Group. The essential functions of this position include, but are not limited to, working directly with senior analysts to assist with analyzing large volumes of detailed project data from labor, accounts payable (AP), general ledger, and other financial reports from the City’s Financial and Procurement system (PeopleSoft) to prepare multi-million dollar reimbursement submissions for State Revolving Fund (SRF) project loans and report submissions for Water Infrastructure Finance and Innovation Act (WIFIA) project loans. The Junior Administrative Analyst will assist senior analysts with calculating and validating eligible project expenditures, compiling supporting documentation that substantiate these charges, and extracting pertinent elements. This position will assist with preparing submission packages, maintaining submission schedules, and issuing status reports for management review. In addition, this position also will work directly with senior analysts to assist with reviewing payments for all SFPUC contractual agreements, general services, and commodities, ensuring payment compliance with the provisions of the contract or quote and prompt payment. The Junior Administrative Analyst will assist with ensuring compliance with City requirements, Departmental policies and procedures, and government accounting standards. This position also will assist with ensuring proper internal controls, monitoring and following up on submitted requests to completion, maintaining and properly archiving invoice files, and ensuring that all payment requests are approved and processed timely in the SFPUC’s contract management and online invoicing system (SOLIS) and in the City’s Financial and Procurement system (PeopleSoft). This position will perform other related duties as required.

Essential Duties:

• Assisting with extracting and reviewing various types of financial and labor reports from the City’s Financial and Procurement system based on defined report specifications.      
• Assisting with analyzing and reconciling project expenditure data to identify eligible costs for loan reimbursement or loan report submissions based on criteria including, but not limited to, reporting period, expenditure type, and funding source.    
• Ensuring that appropriate approval processes and procedures are met and that approvals are granted in a timely manner in order to meet submission deadline schedules.          
• Researching and responding to questions from Program Analysts from Fiscal Agencies and assisting with negotiating the validity and eligibility of submitted costs as defined by executed loan agreements.      
• Assisting with establishing and maintaining reimbursement/report documentation to meet archival requirement as defined by the Department and the executed loan agreements.          
• Performing payment compliance for all SFPUC contractual agreements as well as general services and commodities invoices for the Infrastructure Division and for the SFPUC's 525 Golden Gate Administration Building.     
• Ensuring that invoices are processed consistent with the contract scope of work and proposed funding source.        
• Ensuring prompt payment.          
• Providing support to SFPUC's contract management and online invoicing system (SOLIS) users and assisting with the research and resolution of issues.      
• Assisting with maintaining internal controls documentation for invoice processing and administering policies and procedures to ensure proper internal controls.  
• Assisting in reviewing, validating, and reconciling contract, purchase order, and payment data from the City Financial and Procurement System and internal front-end systems to analyze accounts and to identify data discrepancies.      
• Updating and maintaining contract and invoice data in the SFPUC’s contract management and online invoicing system (SOLIS), with an emphasis on data accuracy and timeliness.         
• Ensuring financial data integrity
• Performs related duties as assigned.       

Work Schedule: 8am to 5pm

Work Location: 525 Golden Gate Ave., 8th Floor, San Francisco, CA 94102

How to qualify

Possession of a baccalaureate degree from an accredited college or university

Substitution:

May substitute up to 2 years of the required education with qualifying full-time, professional-level experience in budget analysis, financial analysis and reporting, legislative/policy analysis, data analysis, or contract/grant administration. One year (2,000 hours) of qualifying experience will be considered equivalent to 30 semester/45 quarter units

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

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. 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 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?

• 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

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.

Job Analyst Information: If you have any questions regarding this recruitment or application process, please contact the job analyst, Yvane Mirabueno, by email at YMirabueno@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.