1823 Senior Administrative Analyst - Capital Finance
|Department||Airport - San Francisco International|
|Date Opened||5/9/2016 08:00:00 AM|
|Filing Deadline||7/18/2016 5:00:00 PM|
|Salary||$47.16 - $57.31/hour; $8,175.00 - $9,934.00/month; $98,098.00 - $119,210.00/year|
|Job Type||Permanent PBT|
This announcement has been amended to provide clarification on the minimum qualifications.
This recruitment may close at any time, but no sooner than Friday, May 27.
This is a Position Based Test administered in accordance with Civil Service Rule 111A.
San Francisco International Airport (SFO) is a world‐class, award‐winning airport that serves more than 50 million guests each year. SFO offers non‐stop flights to 46 international airports on 35 international carriers. The Bay Area's largest airport also connects non‐stop with 72 U.S. cities on 10 domestic airlines. In 2015, the Airport, an enterprise department of the City & County of San Francisco, accounted for $6.3 billion in business activity and supported nearly 36,400 direct jobs.
SFO’s mission is to provide an exceptional airport in service to our communities and is committed to redefining air travel. SFO has embarked on the renovation of Terminal 1, the largest project in the Airport’s 10-year, $4.4 billion Capital Improvement Plan. For more information about SFO, visit www.flysfo.com.
Under general direction of the Debt Manager, the 1823 Senior Administrative Analyst functions as a senior financial analyst performing professional-level analytical work to support funding for the Airport's capital projects activities.
The essential functions of this position include:
- Prepare complex financial analysis and reports that involve, but not limited to interest calculations, time value of money concepts, future value, present value, net present value, IRR, and amortization analysis. Prepare financial memos and reports to management for ongoing projects and new project analysis. Ability to construct and explain analysis both verbally and in writing is critical, as is ability to perform financial policy impact analysis including analyzing and recommending alternative course of action and project consequences.
- Manage the preparation of financial information to capital market audiences. Interpret complex financial information and present it in a clear, concise and simple to read format. Requires data analysis to determine the best format of presentation; data gathering of historical information; reviewing historical trends; and presenting future planned financial forecast.
- Review data to update the Airport’s municipal bond offering document called the Official Statement. Requires close coordination with other Airport departments to gather key information and to ensure the information is accurate and received timely so it can be disseminated to potential investors of general airport revenue bonds.
- Manage the disclosure of financial information to the capital markets following the Securities and Exchange Commission rules and regulations (15c2-12). Post reports to publicly available websites to ensure all bondholders are aware of any financial actions relating to the Airport. This position will also be responsible for managing the content of the Investor Link on the FLYSFO.COM website, which acts as a central information point related to the debt program.
- Bond Arbitrage Rebate data compilation: Requires technical analytical research of interest earnings and expenditure reporting to determine if any excess interest earnings should be remitted to the Internal Revenue Service as per federal tax laws. This is performed on an annual basis.
- Bond Tax Diligence: Requires researching finance data extending 10 years prior. Refunding of past bonds requires up to 4 months of extensive research into the City and County of San Francisco’s Financial Accounting Management Information System (FAMIS) and accounting data on how the use of the bond proceeds was spent and for what type of projects. This requires extensive knowledge of the City’s accounting and financial reporting system to ensure that all bond proceeds were used in accordance with federal tax laws. Compilation and development of reports for review by tax attorneys.
- $400 million Commercial Paper Program administration: Assist with the daily operations of issuing and managing commercial paper funds for the Airports Capital Improvement Program. Track expenditures, prepare tax reports, wire funds, and interact with commercial paper dealers and other financial institutions that support the program. Prepare extensive tracking and reporting systems. Create procedures and record keeping systems. Work with Airport’s Financial Advisors to ensure that the commercial paper program is functioning properly. Use on-line banking systems to create reports via the web.
- Contract Administration for Finance Professional Services: The Capital Finance department utilizes a large group of outside municipal bond finance experts to carry out the refunding and issuance of bonds for capital projects. This task requires developing RFQ/RFPs, coordinating selection process, preparing contracts, and analyzing the overall financial performance of the contracts. Analyzing monthly invoices from professional consultants, each task and deliverables to ensure they were completed on time and within budget and scope according to contract guidelines. Preparing quarterly financial expenditure reports for all professional service contracts and prepare report to management staff.
- Prepare Airport Commission Packages: Write Commission Packages for various contract functions from requesting authorization to issue a request for proposal to award a contract to a vendor after a selection process. Prepare talking points for the Deputy Airport Director’s presentation at Commission meetings.
- Management of Bond Funds: In coordination with Accounting and the Controller’s Office, assist in the management of the Airport 31 bond funds. Requires complex analyses of fund balances and ensuring that fund amounts match appropriation levels from the Board of Supervisors. Preparation of complex Supplemental Appropriation packages to the Airport Commission, Mayor’s Office, Controllers’ Office and the Board of Supervisors.
- Special projects to provide back up to staff in the areas of bond financings, grants, general compliance reports and provide assistance to the Capital Planning group when needed.
- Performs other duties as required.
Nature of work: Requires extensive computer work requiring keyboarding and prolonged sitting and working off a flat screen monitor to perform financial and economic analysis and analyze, manipulate and generate reports; ability to work effectively with managers, co-workers, contractors and other personnel; and ability to identify issues and problem solve.
1. Possession of a graduate degree (Master's degree or higher) from an accredited college or university and three (3) years of 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 two (2) 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 four (4) 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 three (3) years full-time equivalent experience performing professional level analytical work as described in Note A.
Two or more years of experience in financial analysis, including cost/benefit analysis, net present value analysis, rate and financial modeling analysis, present value cash flow analysis, and analyzing financial market conditions.
The above minimum qualifications reflect special conditions associated with the position(s) to be filled. They may differ from the standard minimum qualifications associated with this classification.
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 include two or more years of experience in financial analysis, including cost/benefit analysis, net present value analysis, rate and financial modeling analysis, present value cash flow analysis, and analyzing financial market conditions. Any remaining required 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 1823, 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 1822 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 1823.
The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.
- Two (2) years of experience with issuance of municipal bonds.
- One (1) year experience in managing a Commercial Paper Program.
- One (1) year experience in contract administration writing professional service contracts.
- Exceptional oral and written communication skills.
- Strong Microsoft Word, Power Point and Excel skills (pivot tables, filters, formulas, functions, formatting).
- Project management experience.
How To Apply
Applications for City and County of San Francisco jobs are only 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, @sfpl.org, @dcyf.org, @first5sf.org).
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, Regina Soo, by telephone at (650) 821-2080, or by email at firstname.lastname@example.org.
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 http://sfdhr.org/index.aspx?page=456.
Verification of qualifying experience, when requested, must be documented on the employer's business letterhead and must include the name of the applicant, job title(s), dates of employment, description of job duties performed, and signature of the employer or the employer’s authorized representative. Experience claimed in self-employment will only be accepted if supported by documents verifying income, earnings, business license and experience comparable to minimum qualifications above. Copies of income tax papers or other documents listing occupation and total earnings must be submitted. Employees of the City and County of San Francisco may submit performance evaluations showing duties performed to verify qualifying City experience. City employees will receive credit for the duties of the class to which appointed. Credit for experience obtained outside of the employee's class will be allowed only if recorded in accordance with the provisions of Civil Service Commission Rules. Verification may be waived if impossible to obtain. The applicant must submit a signed statement explaining why verification cannot be obtained. Waiver requests will be considered on a case-by-case basis. Failure to provide the required verification, or request for waiver when requested may result in rejection of application.
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.
Written Core Examination (Weight: 50%)
Candidates who meet the minimum qualifications will be invited to participate in a written, multiple-choice examination, designed to measure their relative knowledge, skills and abilities in job-related areas. The “core” multiple-choice examination component may include but not be limited to:
- Ability to evaluate/analyze information/data and to exercise good judgment relative to that evaluation or analysis.
- Ability to communicate written information (includes ability to proofread).
- Knowledge of, and ability to apply, financial/fiscal principles (including the ability to use mathematical and statistical formulas).
- Ability to comprehend and understand written information.
- Ability to use various computer software programs.
- Ability to conduct research.
- Ability to establish and maintain cooperative and effective working relationships.
- Knowledge of, and the ability to apply, principles, practices and procedures involving office operations.
This is a standardized examination and, therefore, test questions and test answers are not available for public inspection or review.
You will receive one or more scores with respect to the multiple-choice exam component. One will correspond to the core test component and, should any specialty subtests be added to that component, you may receive one or more additional “specialty” scores. Any scores attained on these components will be valid and 'banked' for three years, starting from the date of the examination. This means that, during this three-year time period, you will not be required to take any test components for which you have already attained a score. This core test is also used for 1820 Junior Administrative Analyst, 1822 Administrative Analyst and 1823 Senior Administrative Analyst, therefore your test scores may be applied to one or more of these classes if you choose to apply to future recruitments. This is not the same exam that is used for 1824 Principal Administrative Analyst, as such your scores on this exam are not applied to any 1824 recruitments, and your scores from the 1824 exam cannot be applied to this recruitment. If the selection process for the future announcement is held within one year of the date of this examination and it includes any of these components [i.e., core exam or specialty subtest(s)], your score(s) for the corresponding test component(s) will be automatically applied to that announcement. However, after one year, you have the option to either (a) apply your test score(s) to the other announcement or (b) re-take the test component(s). Re-testing is permitted no sooner than one year from the date of the examination and only in association with your eligibility for another announcement for which the test component (core or specialty subtest) is used. Please note that, should you re-test, your re-test score would become your official score since it is the most recent.
The department may administer additional position-specific selection procedures to make final hiring decisions.
Oral Examination (Weight: 50%)
Candidates who obtain a passing score on the written examination will be invited to participate in an oral examination designed to measure knowledge, skills and abilities in job-related areas. These may include, but not be limited to the items listed below:
Knowledge of: financial principles including time value of money, present value and future value; fiscal, financial and economic concepts and analysis; and City and County of San Francisco contracting procedures.
Ability to: manage and prioritize multiple projects, including coordinating with other sections and departments; compose/prepare/write accurate reports, financial documents, Commission Packages, correspondence and e-mails in short, concise, clear and well-organized form; maintain organization with electronic filing, paper filing and documentation of financial transactions.
Skill in: written and verbal communication; and Microsoft Office Suite (Excel, PowerPoint, Word).
Candidates will be placed on the eligible list in rank order according to their final score. Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.
Training and Experience Evaluation (Qualifying)
Candidates will be prompted to complete a Supplemental Questionnaire that must be submitted during the online application process. All relevant experience, education and/or training must be on the application in order to be reviewed in the screening process.
Make sure your application and any attachments to the application submitted at the time of filing are complete and accurate and include details on all experience, education, training and other information that qualifies you for this recruitment. Failure to submit a complete and accurate application at the time of filing may result in your ineligibility for this recruitment. Any new information concerning work experience, education, training and other information that is submitted after the filing deadline may not be used to determine whether you meet the minimum qualifications.
The certification rule for the ranked eligible list resulting from this examination will be Rule of Five Scores. The hiring department my conduct additional selection processes to make final hiring decisions.
The eligible list is resulting from this examination is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission. The duration of the eligible list resulting from this examination process will be six (6) months, and may be extended with the approval of the Human Resources Director.
Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list resulting from this announcement may be used by other departments that also use this classification or a similar classification. To find other Departments which use this classification, please see http://sfdhr.org/sites/default/files/FileCenter/Documents/21246-All%2015.60.016%207-29-15.pdf. Search that document by title or job code to see which departments use the classification.
Transportation Security Administration (TSA) Security Clearance:
Candidates for employment with the San Francisco Airport Commission are required to undergo a criminal history check, including FBI fingerprints, and Security Threat Assessment in order to determine eligibility for security clearance and may be required to undergo drug/alcohol screening. Per Civil Service Commission Rule Section 110.9.1, every applicant for an examination must possess and maintain the qualifications required by law and by the examination announcement for the examination. Failure to obtain and maintain security clearance may be basis for termination from employment with the Airport Commission. More information can be found at: http://www.sfdhr.org/index.aspx?page=20#transportationsecurity.
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 applying 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 applying 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
Position Based Testing: http://www.sfdhr.org/index.aspx?page=20#positionbasedtesting
Reasonable Accommodation Request: Applicants with disabilities requiring reasonable accommodation for this examination can find information on requesting a reasonable accommodation at http://www.sfdhr.org/index.aspx?page=20#applicantswithdisabilities
Requests for an alternate test date may be considered in limited circumstances and must be submitted to the analyst listed in this announcement within five (5) calendar days of the announcement of the test date.
Veterans Preference: Information regarding requests for veterans preference can be found at:http://www.sfdhr.org/index.aspx?page=20#veteranspreference
Seniority Credit in Promotional Exams: Information regarding seniority credit can be found at:http://www.sfdhr.org/index.aspx?page=20#senioritycredit
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://www.sfdhr.org/index.aspx?page=20 or hard copy at 1 South Van Ness Avenue, 4th Floor.
Terms of Announcement and Appeal Rights: Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at www.jobaps.com/sf.
The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.
Copies of Application Documents: http://www.sfdhr.org/index.aspx?page=20#copies. Applicants are advised to keep copies of all documents submitted. Submitted documents become a permanent part of the exam record and will not be returned. The hiring department may require applicants to submit the same documents and/or additional documents at a later date.
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.
Exam Type: Combined Promotive and Entrance
Issued: May 9, 2016, Amended May 13, 2016
Human Resources Director
Department of Human Resources
Recruitment ID Number: 067615
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.