Career Opportunity

Financial Systems Supervisor (1670)

Recruitment: RTF0154674-01155471

Published: March 07, 2025

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

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.

Accounting Operations & Supplier Division (AOSD) of the Controller’s Office monitors the financial activities of the City. The division certifies contracts, pays vendors, approves personnel requisitions and reviews, monitors, controls, and projects departmental expenditures on a continuous basis to assess overall fiscal condition. The division assists departments to achieve fiscal compliance, accuracy, timeliness and meaningfulness for the resulting financial information. The division is also responsible for the producing the City's annual audited financial statements including the Annual Comprehensive Financial Report (ACFR), the Single Audit Report, and other reports required by federal, state, and local regulations. Other functions include developing and maintaining citywide financial systems, system policies, procedures, training, security, and documentation.

AOSD is responsible for monitoring, tracking, approving and establishing guidelines, policies and procedures for central accounting across all City departments, including all City funds and grants. The City’s online accounting system, PeopleSoft, is used extensively in this work. The City’s data warehouse and analytical tool, Oracle Business Intelligence (BI), and Excel are also heavily used. The Asset Management team of AOSD manages the City’s fixed assets recording and reporting.

Application Opening: 3/7/2025

Application Filing Deadline: 3/21/2025

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.
What this means

Annual Salary: $160,758 - $195,416

Role description

Under general direction of the AOSD Director and Policy & Supplier Manager, this position oversees supplier management operations including supplier record creation, maintenance, cleanup, reporting, and analysis; manages projects related to supplier compliance and payment to improve government efficiency and fulfil the City’s social economic goals. The position also assumes responsibilities in maintaining the City’s financial data structure (ChartFields) and managing report creation and maintenance in the City’s financial system (PeopleSoft) for ACFR and other AOSD operations.

• Manage and lead the Supplier Management Team (SMT) in the following operational and special project areas:
  • Create, verify, and maintain the City’s supplier profiles in PeopleSoft
  • Analyze and clean up supplier data including ship to locations, sales tax rate, duplicate records, invalid TIN numbers, business tax statuses, etc.
  • As part of fiscal year end closing,  clean up financial data including vouchers, purchase orders, requisitions, and expense reports
  • Collaborate with various City departments and Controller’s Office divisions on projects fulfilling the GovOps initiatives and other social economic requirements
  • Support Non-Profit organization data validation and cleanup as of part of the City’s effort to maintain public integrity
  • Research on and implement supplier identifying mechanisms that fulfill City’s social economic requirements such as Admin Code 12B compliance, debarred/sanctioned supplier tracking, etc.
  • Stabilize the City’s electronic payment mechanism (Paymode-X upgrade) as a result of the banking partner change from Bank of America to JP Morang Chase
  • Explore and implement in-house ACH as a payment method for sole proprietor suppliers
  • Issue 1099 and 1098-F for the City as mandated by IRS
  • Conducts legislative research/analysis on SF Charter, SF Admin Codes, IRS Tax Codes, etc.
  • Update supplier-related policies & procedures, including the applicable section in the citywide Accounting Policies & Procedures
  • Maintains CON Forms Portal
• Train and develop SMT members; lead the work planning and performance evaluation processes
• Co-lead the ChartField Team (COA) in the following operational areas:
  • Create and maintain the City’s data structure including all ChartFields in PeopleSoft
  • Inactivate and reactivate ChartFields upon requests with approvals from various internal and external authorities
  • Reorganize Department IDs and other ChartFields upon request with approvals from various internal and external authorities
  • Create and maintain nVision reports for ACFR
  • Create and maintain PeopleSoft queries in test regions for AOSD internal needs
  • Work with Controller’s Office Systems Division to migrate queries from test regions to PeopleSoft Production
  • Process Citywide allocations (e.g., Carbon Tax allocation) in PeopleSoft

How to qualify

1. Possession of a baccalaureate degree from an accredited university or college with major course work in accounting, finance, business administration or a related field. Such education must include at least 12 semester units in accounting. Units in computer science are highly desirable; AND

2. Eight (8) years of professional accounting or financial management experience with large, complex financial systems, preferably government, including analytical and problem solving work, performing difficult and responsible accounting and reporting tasks, preparing financial records and reports, and supervising staff; requiring three (3) years supervising a large unit of accountants, analysts, and support staff.

Substitution: An associate degree in accounting and an additional two (2) years of professional accounting experience in computerized governmental financial systems may substitute for the required education. No substitution may be made for the 12 semester units in accounting. A master's degree in accounting, business administration, computer science or closely related field may substitute for one (1) year of professional accounting experience.

Desired Qualifications

Eight (8) Years Excel finance/budget Experience

Microsoft Excel experience performing complex functions of a financial and budget nature, including database development and maintenance, crafting Pivot tales utilizing massive databases from outside sources, use of lookup tables, graphing of spreadsheet data, linking spreadsheets and tables, use of complex formulas using statement logic, template development, subtotaling data, and data sorting, merging, grouping and filtering features within spreadsheets.

Eight (8) Years PeopleSoft Financials Accounting Experience

Professional experience working with PeopleSoft Financials, including familiarity with PeopleSoft’s Chart of Account structure (COA). Experience must include using the system to check project budget, encumbrance and cash balances and generating reports.

What else should I know?

Selection Procedures: select candidates who meet the minimum qualifications will be invited to participate in the selection interview process.

Analyst Information: 
If you have any questions regarding this recruitment or application process, please contact the exam analyst at Karena.Phung@sfgov.org

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

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.