1822 Administrative Analyst

Recruitment #TEX-1822-092072


This announcement was reopened on 1/14/2019 to allow for additional recruitment.  The announcement will close on 1/18/2019 at 5:00 pm. 

Position Description

This 1822 Administrative Analyst position works on the accounting related analytics in the Controller’s Accounting Operations and Systems Division (Accounting), with significant assignments in the divisions’ Cash Disbursement Unit and Finance & Accounting Services Team.

Overall, Accounting is responsible for monitoring, tracking, approving and establishing guidelines, policies and procedures for central accounting across all City departments. This includes 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, and Excel are also heavily used. The City has recently implemented these systems and still accesses historical data in its former systems, FAMIS and EIS. 

Under direction, the 1822 may analyze various accounting and financial transaction activities; performs difficult and responsible accounting and financial transaction and clerical work; prepares and reviews a variety of complex financial documents and records; interprets, enforces and carries out existing policies, regulations and procedures relating to accounting and financial activities; makes regular contacts with other departmental personnel, the general public and outside organizations in connection with accounting and financial operations; prepare and maintain a variety of complex financial and bookkeeping records and reports; post, adjust and balance entries to ledgers; verify the correctness of accounting documents; respond to inquiries and provide financial information; organize and file source documents; perform operations involving automated accounting systems and spreadsheet programs and performs related duties as required.

Essential duties of the job include but are not limited to:  

· Provide departmental assistance to ensure accurate and timely recording of financial information in the City’s accounting system in compliance with Controller’s policies and procedures.

· Reconcile collections with cashiers and count cash received. Prepare bank deposits. Submit entries online in the City’s financial accounting system to record bank deposits, including currency, checks, credit card payments, and wire transfers.

· Reconcile and prepare billing, budget, and other interdepartmental services transactions.

· Prepare, process, and review additional financial, accounting, budget, general ledger, payables, purchasing, encumbrance and other transactions using PeopleSoft as needed.

· Record transactions for full grant cycle from budget set up through closeout and maintain and organize records for assigned grants.

· Verify availability of funds, proper authorization, correct coding, and vendor status for above transactions.

· Accurately initiate, approve and/or analyze a high volume of purchasing and payment transactions related to various commodities, contracts and services, including: blanket and regular purchase orders; purchases under Proposition Q; requisitions online in in City’s accounting system; and direct and one-time payment requests in compliance with Department and City procedures.

· Prepare, review and reconcile supporting documentation for above transactions.

· Reconcile bank statements and revolving fund balances.

· Generate reports and queries as needed to support tasks using Oracle Business Intelligence, PeopleSoft Query, and PeopleSoft nVision.

· Provide feedback and clerical support on Policies and Procedures in use or proposed by the Controller’s Office or department.

· Act as a liaison between assigned department and the Controller’s Office.

· Initiate requests on behalf of department to update coding, role mapping, workflow, or other system functionality for assigned departments.

· Research information in PeopleSoft and the City’s former financial system.

· Reconcile various accounting and financial reports between different sources and systems, including between former accounting system and current PeopleSoft system.

· Assist with post audit of financial transactions and grants of assigned city departments.

· Assist with preparation for reports and financial audits, preparation of the Comprehensive Annual Financial Report, the Single Audit, and reporting to other governments as needed.

· Respond verbally and in writing to phone, email and in-person questions and requests for information from the public and staff from other departments.

· Sort, file, track and return various accounting, financial and system documents to departments and the public.

· Train Controller’s and departmental staff as assigned.

· Follow all City and Controller’s Office policies and procedures.

· Create reports and logs using Excel, Word or other software.

· Take all necessary steps to prepare yourself for an emergency, in your capacity as a Disaster Service Worker; provide updated personal contact information to your department.

· May supervise or direct the work of other clerical staff.

· Other duties as required.

Minimum Qualifications

1. Possession of a graduate degree (Master's degree or higher) from an accredited college or university; and one (1) year full-time equivalent experience performing professional-level analytical work,as described in Note A; OR

2. Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework as described in Note B; OR

3. Possession of a baccalaureate degree from an accredited college or university, and two (2) years full-time equivalent experience performing professional-level analytical work as described in Note A; OR

4. Possession of a baccalaureate degree from an accredited college or university with major coursework as described in Note B and one (1) year full-time equivalent experience performing professional-level analytical work as described in Note A;

SUBSTITUTION: Applicants may substitute up to 2 years of the required education with additional qualifying experience in budget analysis, financial analysis and reporting, legislative/policy analysis, or contract/grant administration. One year (2000 hours) of additional qualifying experience will be considered equivalent to 30 semester units/45 quarter units.

Notes on Qualifying Experience and Education:

A. Qualifying professional-level analytical experience must be in one or more of the following functional areas: complex budget analysis, development and administration; complex financial/fiscal analysis and reporting; development of complex contracting systems and administration of competitive bid processes and complex contractual agreements; development and evaluation of complex management/administrative policy; complex grant administration and monitoring; complex program evaluation and planning; complex legislative analysis; complex economic analysis; or other functional areas related to the duties of positions in Class 1822, where the primary focus of the job is complex professional-level analysis for evaluation, recommendation, development and implementation of major programs and functions of department/organization. Analytical experience equivalent to the duties of Class 1820 is considered qualifying.

B. Coursework applicable to a baccalaureate or higher degree 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 Class 1822.

How To Apply

Applications for City and County of San Francisco jobs are being accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.

  • Select the desired job announcement
  • Select “Apply” and read and acknowledge the information
  • Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
  • Follow instructions on the screen

Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.

Applicants may be contacted by email about this announcement 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).

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.

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.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

If you have any questions regarding this recruitment or application process, please contact the exam analyst, Carlos Benitez, by telephone at 415-554-7530, or by email at carlos.benitez@sfgov.org.

Selection Procedures

Applications will be screened for relevant qualifying experience. Additional screening mechanisms may be implemented in order to determine applicants’ qualifications. Only those applicants who most closely meet the needs of the Department will be invited to participate in the selection process. Applicants meeting the minimum qualifications are not guaranteed advancement to the interview.

Verification:  Applicants will 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 http://sfdhr.org/index.aspx?page=456

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.

Conviction History

As a finalist for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a finalist. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:

  • Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
  • Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.

Having a conviction history does not automatically preclude you from a job with the City.

If you are selected as a finalist, the hiring department will contact you to schedule a fingerprinting appointment.

Disaster Service Workers

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.


General Information concerning City and County of San Francisco Employment Policies and Procedures:
Important Employment Information for the City and County of San Francisco can be obtained at http://sfdhr.org/information-about-hiring-process or hard copy at 1 South Van Ness Avenue, 4th Floor.

Copies of Application Documents:
Applicants should keep copies of all documents submitted, as these will not be returned.

Right to Work:
All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.

Requests: Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at: 
Information regarding requests for Veterans Preference can be found at: 

Issued:  December 7, 2018 
Amended: January 14, 2019
Micki  Callahan

Human Resources Director
Department of Human Resources
Recruitment ID Number: 092072


All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

For more information about benefits, please click here.


Powered by JobAps