City and County of San Francisco

Principal Administrative Analyst II (#1825)

$63.74-$77.51 Hourly / $11,048.00-$13,436.00 Monthly / $132,574.00-$161,226.00 Yearly


Definition

Under administrative direction plans, organizes, leads and may supervise staff engaged in difficult, complex, sensitive, and detailed analytical work including complex quantitative analysis in the areas of budget, contracts, financial/fiscal, economic, legislative and administrative policies.

Distinguishing Features

Class 1825 Principal Administrative Analyst II is a unique level in the Administrative Analyst professional/supervisory/management series. It is distinguished from the next lower level of 1824 Principal Administrative Analyst by its assignment of complex finance and utility analysis, project finance pro-forma development, forecast modeling, debt finance risk management, and statistical modeling typically involving the use of specialized analytical software, complex business intelligence systems and complex analysis of data. Positions in this class maintain senior levels of responsibility with greater independence of action and consequence of error in designing business solutions, formulating recommendations and achieving effective decisions. The financial impact of the work performed by incumbents in these positions is significant, potentially involving hundreds of millions of dollars.

Supervision Exercised

Class 1825 Principal Administrative Analysts II typically supervises staff including lower-level administrative analysts, and/or complex, cross-functional project teams staffed with professional level employees.

Examples of Important and Essential Duties

According to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job code/class and are not intended to be an inclusive list.

1. Working independently, researches, analyzes and makes policy recommendations on unique special projects with significant financial impact or highly visible public issues; may direct mission critical financial or operational activities; responds to informational requests, including those of a highly sensitive nature, and may represent the department to the Mayor's Office, Board of Supervisors, Controller's Office, other city officials, outside agencies and the public; acts as executive assistant and provides administrative analysis including complex forecast modeling to high-level managers or a department head.

2. Plans, develops and directs the production of highly complex departmental budget(s); advises management in the budget development and management process, including formulating policy, monitoring, reporting and interpreting budget documents; may negotiate budget proposals within the department and with the Mayor's Office, Board of Supervisors, and other agencies; prepares or supervises staff in the preparation of, budget line-item narratives, complex analyses, recommendations and justification based on complex statistical analyses for annual, supplemental and multiyear requests.

3. Establishes, administers, monitors, coordinates and acts as liaison regarding application for and management of the extremely complex, multiple source capital project and/or grants; ensures compliance of fund reallocations with funding agency requirements; analyzes trends in expenditures and revenues for multi-year budgets; prepares financial/statistical reports for management, Mayor's Office, Board of Supervisors, Controller's Office and other funding agencies; coordinates and monitors departmental reporting to funding agencies including the subvention of funds to contracting organizations and justifies that funds are used as required.

4. Plans, develops, performs and directs work involving extremely complex economic and/or financial analysis including finance and utility rate analysis and modeling, cost/benefit analysis, and capital planning for senior management; determines appropriate methodology and performs difficult financial analyses, including financial forecasting, revenue and/or expense projections, capital requirements, calculation of debt capacity and evaluation of financing alternatives utilizing specialized analytical software to produce complex analysis or data; makes written and oral recommendations on difficult administrative and fiscal issues.

5. Analyzes, evaluates, interprets, and implements new and existing governmental accounting pronouncements and technical guidance; identifies problems with, develops and implements changes to current financial policies and procedures; may coordinate and oversee the annual financial audit including preparation of audit schedules and governmental accounting standards, local, state, and federal regulations.

6. Identifies and analyzes highly complex existing, newly enacted and proposed local, state, federal legislation policies and procedures projecting potential impact; advises management on the consequences of proposed and pending legislation and effectively presents recommendations; develops and recommends procedures for the citywide implementation of enacted legislation; may act as legislative liaison to other departments; assists state and federal legislative staff in drafting legislation; advocates and testifies regarding department's position to legislators, committees, and staff; develops comprehensive user manuals to implement legislation, programs and administrative policies.

7. Researches, analyzes, forecasts and makes policy recommendations on special projects or highly visible public issues including administrative policies, practices, and procedures; manages implementation of new systems, policies, and procedures.

8. Plans and directs difficult and detailed staff work involving: preparation of MBE/WBE and contract status reports; conducting competitive contract vendor selection processes including public bids and Requests For Proposals, ensuring adequate and economic distribution of advertisement, requests for proposals and public notices; process highly complex contracts including advertising for bids/proposals, receipt and review of bids, contract negotiation and award and routing through signature/documentation process to certification; coordinate with staff from purchasing, Human Resources, Human Rights Commission, and the Administrative Services office; and provide training and assistance to staff and contractors on departmental and City contracting policies, procedures, and requirements.

9. Reviews, prepares, and analyzes cost estimates and terms for financially significant new and existing contracts, change orders, and modifications; prepares reports of analyses and related documents; analyzes claims for additional cost reimbursement to determine validity; analyzes contract provisions to determine appropriate reimbursement amount; conducts negotiations with contractors with regard to additional contract terms, cost reimbursement and change order provisions; prepares reports regarding claim status, settlement activities and reimbursement amounts for use by management and city Attorney's Office; maintains records of negotiations.

10. Independently reviews and evaluates financial and business models utilized within an organization. Conducts reviews and appraisals of business models and discusses review findings and recommendations with senior and executive management. Utilizes statistical models to forecast particular outcomes or events.

11. Performs related duties and responsibilities as assigned.

Knowledge, Skills and Abilities

Knowledge of: principles and techniques of governmental organization and management: the principles and techniques of financial/fiscal analysis and budgeting; principles and techniques of economic and policy analysis; principles and techniques of generally accepted accounting principles and government accounting standards; application of statistical and other analytical methods, knowledge of methods and techniques of data collection and analysis; specialized analytical software; applicable local, state, and federal laws and regulations affecting departmental operations; principles involved in the development and implementation of complex systems and procedures; methods, procedures, and techniques needed for negotiations of contract terms, change orders, cost estimates and modifications.

Ability to: collect, synthesize, and analyze a wide variety of information; conduct extremely difficult analytical studies involving complex administrative and financial systems and procedures and significant financial impact; work with complex business intelligence systems,; to oversee programmers and software developers in the production of complex analysis or data; temporarily manage complex, cross-functional project teams; work with authority to identify and define problems, determine methodology evaluate data, make recommendations with appropriate justification and develop/implement a plan of action; plan, prepare, review, and present clear and concise findings and reports; assign and direct the work of subordinates and other staff; establish and maintain effective oral communication with management, officials, representative of other agencies, contractors, and the general public; negotiate effectively; use personal computer and software programs as utilized in various departments

Experience and Training

These minimum qualifications are to be used as a guide for establishing the education, training, experience, special skills and/or license which may be required for employment in the class. Although these minimum qualifications are typical of the class, additional minimum qualifications and special conditions may apply to a particular position and will be stated on the job announcement.

1. Possession of a graduate degree (Master's degree or higher) from an accredited college or university AND seven (7) years 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 college coursework as described in Note B and six (6) years full-time equivalent experience performing professional level analytical work as described in Note A; OR

3. Possession of a baccalaureate degree from an accredited college or university and eight (8) years of 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 college coursework as described in Note B and seven (7) years 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 1825, 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 1824 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 1825.

License or Certificate

None.

Notes

AMENDED:  9/28/09

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.

CLASS: 1825; EST: 2/23/2007; REV: 9/28/2009;