9255 Airport Economic Planner (Financial Planning & Analysis)

Recruitment #PBT-9255-093678

Introduction

Job announcement has been amended to reflect changes to the minimum qualifications on 3/12/2019.

This is a Position Based Test administered in accordance with Civil Service Rule 111A.

Applicants are encouraged to apply as soon as possible as this announcement may close at any time after 5:00 p.m. on March 26, 2019.

The Department
SFO is a world-class, award-winning airport that served more than 57 million guests in fiscal year 17/18. SFO offers non-stop flights to 50 international cities on 44 international carriers. The Bay Area's largest airport also connects non-stop with 85 U.S. cities on 12 domestic airlines. In fiscal year 16/17, the Airport, an enterprise department of the City & County of San Francisco, accounted for $8.4 billion in business activity and supported nearly 43,000 direct jobs.

SFO’s mission is to provide an exceptional airport in service to our communities and is committed to redefining air travel. SFO is renovating Terminal 1: The Harvey B. Milk Terminal, the largest capital project in the Airport’s $7.3 billion Ascent Program. For more information, visit www.flysfo.com. You can also watch this video about careers at SFO.

Position Description
The 9255 Airport Economic Planner reports to the Financial Planning and Analysis Manager of the Business and Finance Division at the San Francisco International Airport. This position performs a variety of duties related to financial and economic business planning, development & management, contract administration and may supervise professional and support staff.

The essential functions of this position include:

Rates and Charges and Analytical Modeling

  • Conduct financial analyses and calculate rates and charges for Airport facilities and services, consistent with the Airport-Airline Lease & Use Agreement and other governing policies.
  • Develop, construct and implement complex analytical models to predict outcomes under differing assumptions, and use output to recommend financial strategies.
  • Perform cost recovery and sensitivity analyses using well developed assumptions.

Revenue Budgeting and Forecasting 

  • Develop the annual Airline and non-Airline revenue budget with supporting quantitative schedules and written narrative justifications. 
  • Perform quarterly forecasts of Airline and non-Airline revenue and prepare written reports to explain variances to the budget.
  • Perform ad hoc financial estimates and forecasts given changing business conditions and Airport operations.

Activity Analysis and Economic Impact

  • Track relevant financial and operational metrics at the Airport and quantify impacts on the metrics under differing assumptions.  Compile management reports and dashboards.  Identify trends and explain material variances.
  • Use stakeholder input and other sources of information to understand and explain the trends.  Advise management on its financial impacts.
  • Collaborate with external consultants to analyze and understand economic conditions and the impact the Airport has to the nearby counties and municipalities.
  • Perform cost/benefit analyses and business cases in support of various Airport business opportunities and capital projects.

Collaboration

  • Collaborate with other Airport departments and external consultants on various items including but not limited to:  Bond disclosure documents, investor/rating agency presentations, audit documentation, Management Discussion and Analysis (MD&A), airport feasibility studies, competition studies, economic impact studies, air traffic forecasts and other ad hoc evaluations.
  • Develop underlying assumptions for models in conjunction with other Airport business managers, and collaborate with them to validate and explain results.

Communication

  • Produce written reports to document and explain activity and financial performance.
  • Prepare and deliver oral presentations.

Others

  • Perform contract management tasks per City policies, including conducting Requests for Proposals (RFP) and actively manage contracts & business subscriptions.
  • Produce ad hoc analyses, responses to inquiries and surveys, and other related duties as assigned.
  • May supervise professional and support staff.

Nature of Work
This position includes: computer work and prolonged sitting and working off flat screen monitors to perform analytical tasks and generate reports; ability to work effectively with support staff, colleagues within the unit and other departments, managers and directors, the public, airline personnel, and governmental agencies in a tactful, diplomatic manner; ability to identify issues and problem solve.

 

Minimum Qualifications

Education
Possession of a Baccalaureate degree from an accredited college or university with major coursework in Economics, Business, Accounting, Airport Management, International Relations, Administration, Public Administration, or a related field.

Experience 
Five (5) years of professional experience performing or overseeing one or more of the following areas:

  • Preparing and presenting budgets

  • Conducting financial and economic analyses

  • Computing Airport rates, fees, and charges for use of Airport facilities and services

Substitution
Education Substitution: Additional qualifying experience as described above may substitute for the required education on a year-for-year basis (up to a maximum of 2 years).  Note: One year (2000 hours) of additional qualifying work experience will be considered equivalent to 30 semester units/45 quarter units. (2000 hours of qualifying work experience is based on a 40 hour work week.)

Note: Residential property management experience is not qualifying.

Desirable Qualifications
The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred to hiring.

  • Strong written and oral communications skills 
  • Proficiency in developing summary data tables and graphs
  • Advance computer applications related to data analysis, modeling and reporting skills
  • Proficiency in technical writing, authoring reports and delivering presentations to management
  • Proficiency in reviewing and editing others’ reports
  • Experience with analyzing, summarizing and presenting activity based statistics in aviation or other transportation industries 
  • 3 - 5 years of supervising contractors/consultants or staff in the above functions

Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.

One year full-time employment is equivalent to 2,000 hours (2,000 hours of qualifying work experience is based on a 40 hour work week). Any overtime hours that you work above 40 hours per week are not included in the calculation to determine full-time employment.

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 Department of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103, or the Airport Commission Human Resources office at 710 N. McDonnell Road, 3rd floor, San Francisco, CA 94128.

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, Charlene Cun, by telephone at 650-821-2018, or by email at Charlene.cun@flysfo.com.

Resumes may be attached to the application; however, resumes will not be accepted in lieu of a completed City and County of San Francisco application.

Verification
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 here.

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. 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 or inability to receive full credit for scoring purposes. Any new information concerning work experience, education, training and other information that is submitted after the filing deadline may not be used for scoring or considered to determine whether you meet the minimum qualifications.

Selection Procedures

Minimum Qualification Supplemental Questionnaire (Weight: Qualifying)
Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application. This Minimum Qualification Supplemental Questionnaire is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications for this position. Applicants must also complete the official application. It is essential that applicants provide complete information in identifying their education, experience and training. The Minimum Qualification Supplemental Questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications.  

Training & Experience Evaluation (Weight: 30%)
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 rating process. The Training & Experience is designed to measure the knowledge, skills and abilities required for the Airport Economic Planner position in the Financial Planning & Analysis section (e.g., ability to set priorities, meet goals and control and manage several projects simultaneously; ability to communicate effectively with subordinates, peers, supervisors, other agencies, tenants and the public in a clear and effective manner; ability to write, read, comprehend, and interpret complex written materials; ability to use a personal computer and business related software programs; ability to use financial and reporting software; ability to analyze and solve problems/issues and make recommendations; knowledge of statistical and analytical methods; and knowledge of financial and accounting principles.).

Supplemental Questionnaire Evaluation (Weight: 70%)
Candidates will be evaluated and scored based on the information provided in supplemental questionnaire for the position of 9255 Airport Economic Planner. The Supplemental Questionnaire is designed to measure knowledge, skills and/or abilities in job-related areas which may include, but not limited to: ability to set priorities, meet goals and control and manage several projects simultaneously; ability to communicate effectively with subordinates, peers, supervisors, other agencies, tenants and the public in a clear and effective manner; ability to write, read, comprehend, and interpret complex written materials; ability to use a personal computer and business related software programs; ability to use financial and reporting software; ability to analyze and solve problems/issues and make recommendations; knowledge of statistical and analytical methods; and knowledge of financial and accounting principles. Candidates will be placed on the eligible list in rank order according to their responses. 

Note: Only those applicants meeting the minimum qualifications will be notified of the exact date, time and place to report for the Examination.  Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process. A passing score on all Exams must be achieved in order to be placed/ranked on the Eligible List.

The department may utilize additional selection procedures to make a final hiring decision. Candidate scores on this examination may also be applied to other announcements involving other titles, when directed by the Human Resources Director.

Transportation Security Administration (TSA) Security Clearance
Candidates for employment with the San Francisco Airport Commission are required to undergo a criminal history record 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.

Certification Rule
The certification rule for the eligible list resulting from this examination will be Rule of Three Scores pending approval on expansion of certification rule. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

Eligible List
A confidential eligible list with names of candidates who have passed the civil service examination process will be created and used for certification purposes only. An examination score report will be established so interested parties can view the ranks, final scores, and number of eligible candidates. Applicant information, including names of candidates on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once that eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process 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 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/score report resulting from this announcement may be used by other departments that also use this classification or a similar classification. To find other Departments that use this classification, please click here. Search that document by title or job code to see which departments use the classification.

 

Conviction History

As a selected candidate 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 selected candidate. 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 a selected candidate, 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.

Conclusion

Reasonable Accommodation Request
Applicants with disabilities requiring reasonable accommodation for this examination can find information on requesting a reasonable accommodation here.

Seniority Credit in Promotional Exams
Information regarding seniority credit can be found here.

Veterans Preference
Information regarding requests for veteran’s preference can be found here.

Terms of the Announcement
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
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.

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 online here or hard copy at 1 South Van Ness Avenue, 4th Floor.

Exam Type: Combined Promotive & Entrance
Issued: 3/1/19
Micki Callahan
Human Resources Director
Department of Human Resources
Recruitment ID #: 093678
AIR/CC/650-821-2018

 

Benefits

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.

 


Click on a link below to apply for this position:

Fill out the Supplemental Questionnaire and Application NOW using the Internet.
View and print the Supplemental Questionnaire. This recruitment requires completion of a supplemental questionnaire. You may view and print the supplemental questionnaire here.

Powered by JobAps