What are the responsibilities and job description for the Financial Systems Supervisor (1670) position at City and County of San Francisco?
Job 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
Create and maintain the City’s data structure including all ChartFields in PeopleSoft
Qualifications
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.
Additional Information
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 :
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.
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.
