Career Opportunity

Senior Budget and Financial Planning and Analysis Analyst – SF Municipal Transportation Agency – Multiple Units (TPV – 1823 – 139118)

Recruitment: RTF0139117-01117052

Published: October 16, 2023

Apply using SmartRecruiters, the City and County of San Francisco's application portal Learn More

About:

The SFMTA, a department of the City and County of San Francisco, oversees Muni (the historic Municipal Railway), parking and traffic, bicycling, walking and taxis. Over one million people get around San Francisco and rely on us to ensure safe and reliable travel.
Our Vision: Excellent transportation choices for San Francisco.
Our Mission: We connect San Francisco through a safe, equitable, and sustainable transportation system.

Application Opening: October 04, 2023
Deadline to Apply: May close at any time but not prior to October 17, 2023
Annual Salary: $113,386 - $137,800 (More information, here)
Recruitment ID: 139118
Appointment Type: Temporary Provisional. This is not a permanent appointment. A provisional appointee must participate and be successful in a Civil Service examination for this classification and be selected through an open competitive process in order to be considered for permanent appointment. Provisional appointments may not exceed three (3) years.

Role description

Under general direction, the Senior Administrative Analyst is responsible for directing and performing difficult, complex, and/or sensitive projects for departmental management, such as: plans, organizes, leads and/or participates in complex, sensitive, and detailed analytical work in the areas of budget, financial/fiscal, economic, data analysis, legislative and administrative policy and/or contract administration. Class 1823 Senior Administrative Analyst is the senior journey-level class of the series.

The San Francisco Municipal Transportation Agency’s (SFMTA) Budget, Financial Planning and Analysis (BFPA) section is recruiting for a pool of Senior BFPA Analysts to support various assignments within the section.

The Budget team includes the following groups - operating budget, financial analysis, capital budget, and project control. This team manages the development and ongoing implementation of the SFMTA’s operating and capital budgets and provides accurate, timely, and meaningful analytical and financial management expertise to support the effective management of SFMTA resources. The office oversees the implementation of the Agency’s fiscal policy strategy, including the 2-Year Operating and Capital Budgets and 5-Year Capital Improvement Program that establish the policy, programmatic and capital investment priorities for the Agency. Staff in this office review the sufficiency and quality of programmatic or project proposals; analyze performance against budget, and act as the lead communicator on processes between various sections, project teams, divisions and departments.

The Grant team includes the grant administration and funding strategy groups. This team leads the efficient financial and programmatic management of state, federal, or other public or private grant or capital funds. The office applies for and manages more than $1 billion in grants received from state, federal and local sources, as well as manages Revenue and General Obligation Bond programs issued by the SFMTA and by the City and County of San Francisco.  The Grant team serves as the primary liaison and contact with external funding agencies. It is also responsible for the management of the funds under their purview providing fiscal, programmatic and administrative monitoring; reporting on behalf of the SFMTA to funding agencies, elected officials and the public on the use of grant and bond funds; managing the acceptance and expenditure appropriation of grant and bond funds, and supporting audits and reviews conducted by the Agency’s funding partners.

Positions can be in any of the following units within SFMTA’s BFPA Section:
Budget: Under general direction of the Budget Manager, the Senior Budget and FP&A Analyst operates in a  fast-paced environment to develop the Agency operating and capital budgets; ensure operating  divisions and capital programs are properly resourced; ensure transactions conform to internal policies, charter requirements, generally accepted accounting principles and related local, State and Federal legislation policies and procedures; ensure expenditures are within budgeted amounts; and analyze the viability of projects and programs, and review position requests. This position supports Agency staff with training and tools to address and resolve budgetary questions and challenges.

Grant: The Grant Senior Financial Analyst plans, organizes, and oversees regional grant, competitive grant, bond, and other project funds for the Agency’s Grant Administration Office. Under general administrative direction of the Manager, Programming & Grants, the position monitors and administers the implementation of formulaic and competitive grants and revenue and general obligation bonds; develops and administers complex management systems for fund oversight; maintains a comprehensive list of reporting requirements and a system for meeting reporting deadlines; maintains a process to monitor for changes in grant terms and conditions that occur after the acceptance of a grant and provides programmatic monitoring and program and policy management as-needed. This position will confer with principal analysts, and middle and senior management staff to discuss, evaluate and make fiscal planning recommendations for bond and grant programs. As a fund manager, the position coordinates and submits progress reports for local, state and federal agencies, the San Francisco Board of Supervisors, SFMTA Board, executive management, and others. The position works in close partnership with key funding partners including the Bay Area region’s Metropolitan Transportation Commission, the San Francisco County Transportation Authority, Caltrans, the Federal Transit Administration, and other funders.  The analyst will be the subject matter expert on revenue and general obligation bond reporting. This position will support grant and bond procurement and management responsibilities based on: bringing the right parties to the table to facilitate solutions, understanding and acting on grant submittal and reporting deadlines, identifying and reporting out on unused funds, and sharing all job-related information and working productively in a team-oriented environment that is constantly striving for and achieving efficiencies.

Asset Management: Under general direction of the Asset Management Lead Analyst, the Senior Analyst will work with contracts/procurement personnel, budgets and subject matter experts to develop contract requirements, budgeted amount, determine experience and expertise needed to develop Asset Condition Assessment  contract language and have it ready to be advertised and bid on.  The purpose of this contract is to create a Master Agreement that can encompass various disciplines and expertise so that the various SFMTA capital programs can utilize the selected firm to conduct State of Good Repair activities without having to spend valuable time and resources to develop their own contract for assessments. The senior analyst will also work with Enterprise Asset Management System (EAMS) team to create the foundational linkages between our current work order management system, as-built assets, curb regulations and the Asset Management's team PSD Asset Management Database.

Other projects may include working with the Curb Management group to plan, coordinate and manage the possible integration of curb assets into PSD (Asset Management Database) and explore the use of PSD's mobile app in updating street asset data with the curb regulation data to the Digital Curb while in the field to provide near-real time updates as it happens. 

Examples of Essential Duties and Responsibilities:

General

• Performs complex policy and financial analyses.
• Clearly communicates findings and strategy recommendations to management in verbal, written, and other visual forms.
• Works collaboratively across SFMTA units, funding partners, and other stakeholders toward solutions.
• Proactively identifies and solves problems.
• Participates in special projects as assigned.
• Performs other duties as required.

Operating and Capital Budget Unit

• Participates in the development of the two-year annual budget, including preparation of technical budget documents, review of budget change requests from assigned departments, development of staffing plans for operating and capital budget, analysis and programming of capital projects in five-year Capital Improvement Plan (CIP), completion of budget entries and balancing budget exercise.
• Provide ongoing support for administration and monitoring of operating and capital budgets for assigned divisions and capital programs, including preparation of monthly budgetary reports, advising budget adjustments, reviewing and approving budget transfers and budget revisions, preparation and coordination of work orders, performing position control and processing requisition requests.
• Works closely with assigned CIP program managers on scope, schedule, and funding needs; Identifies funding sources for proposed projects and projects' cash flow requirements, maintains budgetary records for proposed projects, responds to and effectively manages all CIP program requests and conducts regular quality control.
• Undertakes process improvement projects related to budgetary issues.
• Analyzes and reports cost variances to ensure that cost control methods are implemented and applied to program objectives.
• May train assigned employees in their areas of work, including budgeting and financial analysis methods, procedures and techniques.

Financial Analysis Unit

• Tracks complex issues facing SFMTA and the Bay Area transportation sector impacting financial outlook.
• Develop and update models that provide fee levels for services such as towing, residential parking permits, etc. including development of associated materials required for budget package. Coordinate with internal business owners who manage the services and Streets leadership.
• Forecasts operating revenues including fare revenue and discounts, other operating revenue, and financial assistance; Develop recommendations for fine revenues adjustments and city transportation code updates.
• Monitors performance and make recommendations for process improvements.
• Analyzes and interprets staffing costs including provisions in respective MOUs.
• Participates in the more difficult work of staff responsible for complex financial, statistical, and program management analysis in assigned division area.
• Develops and recommends improvements to computerized financial management system; and
• Conducts financial and management studies to evaluate system performance and operating efficiencies; presents studies to communicate findings and recommendations to senior management and the Board of Directors.

Grants Administration Unit

• Manages Funds: Monitors the progress of grants and tracking expenditures; produce delay reports, reports on performance (“burn rates”) of grant and bond sources using in-house tools and spreadsheet analytics, identifies grant and bond reprogramming opportunities to BFPA and CFO.
• Reviews, reconciles, and submits the content reports related to the implementation of Projects by Agency divisions and sections to federal, state, bond oversight committees, and local officials and organizations.
• Serves as grant compliance officer and subject matter expert on assigned transportation grant guidelines, processes, and regulations. Ensures integrity of grant-funded scope throughout the course of the grant and through close-out.
• Leads the coordination of project managers and others to secure grant funding agreements and to track status of projects and programs funded through local, state, regional, and federal programs.
• Updates and maintains electronic database and paper filing systems.
• Informs project managers on budget revisions, prepare as needed.
• Reconciles grants by resolving grant billing issues with the appropriate staff and reconciling grant expenditures as needed.
• Closes out grants promptly based on close out guidelines required by funding agencies.
• Oversees various programs of projects for local capital fund sources, tracks funding plans of both grant and match for capital projects, and provides assistance in fiscal/financial planning activities in support of grant management functions, including: developing primary and matching fund strategies, providing financial and grant perspective in developing priorities for the MTA’s capital programs, and conducting financial cash flow and fund availability analyses
• Combine qualitative, quantitative, and visual skills to create professional and compelling grant applications, as required.
• Manages the stress of last-minute projects in a fast-paced environment effectively and efficiently so that others are not negatively impacted.

Funding Strategy Unit

• Leads the development of strategies to expand and enhance the transportation system through planning, strategic thinking, project management, policy analysis, historical research, and preparation of budget and cost analytical reports.
• Leads the coordination activities to aid in building consensus and resolve conflicts on projects and policy matters; support communication and coordination of activities among SFMTA staff, other governmental agencies, and the public during the various phases of assigned projects.
• Develops project plans; coordinates internal staff support, financing/cost strategies, service cost estimates, and policy analysis; meets with Agency planning and policy teams to discuss work underway, upcoming assignments and issues, and strategizes about next actions/steps.
• Designs, conducts, analyzes and evaluates reports and plans for technical, social, economic and physical data for various transportation planning projects and grant requests.
• Leads complex financial analysis in support of long-range financial outlook.
• Reviews federal, state and local legislation and regulations for potential impact on transportation plans and programs and informs transportation policy recommendations.
• Prepares transportation models, maps, charts and other graphic materials to illustrate plans and reports; applies computer-assisted analytical techniques to evaluate transportation planning programs.
• Supports the grant and funding advocacy efforts in the region, attends funding partner meetings, and provides strategy and staff support to MTA Board members and executives/managers on issues related to grants and funding advocacy.
• Prepares winning grant requests, project justifications, requests for proposals, budgets, schedules and contracts for transportation planning projects.

Asset Management Unit

• Plans, organizes, leads and/or participates in the design and preparation of the request for proposals for an “As Needed” contract for Condition Assessments.
• Plans, organizes, leads and/or participates in the implementation of the Transit Asset Management Plan and SFMTA State of Good Repair Policy through data gathering, analysis, asset condition assessments and policy development and program implementation.
• Plans, organizes, leads and/or participates in complex long-range fiscal forecasts and plans for financing long-range capital infrastructure programs.
• Plans, organizes, leads and/or participates in the design and preparation  of new asset data integration into PSD (Asset Management Database).

How to qualify

These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification. Please note, additional qualifications (i.e. special conditions) may apply to a particular position and will be stated on the job ad.

Education:
Possession of a baccalaureate degree from an accredited college or university

Experience:
Three (3) years full-time equivalent experience performing professional-level analytical work. Qualifying professional-level analytical work includes analysis, development, administration, and reporting in major programs and functions of an organization in the areas of budgets, contracts, grants, policy, or other functional areas related to the duties of positions in the 182X Class series.

Substitution:
Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework 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 the Class series may be substituted for one (1) year of required experience.

Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of 2 years). Thirty (30) semester units or forty-five (45) quarter units equal one year.

Desirable Qualifications:
The stated desirable qualifications may be used to identify candidates advancing to the interview process and/or to identify job finalist(s) at the end of the selection process when referred for hiring.

• Exercising a high degree of individual initiative, discretion, diplomacy, accuracy, and judgment
• Understanding and following oral and written instructions.
• Communicating clearly and concisely, both orally and in writing.
• Establishing and maintaining effective working relationships with those contacted in the course of work including internal departments, vendors, and consultants.
• Experience using Power BI, Tableau, Excel, Asset Management Databases, familiarity with databases and economic analysis tools.
• Knowledge of the principles, practices, purposes, scope and techniques of various phases of city and/or transportation planning; project and program financing, estimating and budgeting.
• Knowledge of the principles and practices of organization, administration, fiscal and personnel management; Federal, State, and local laws, rules and regulations pertaining to asset management and capital planning.

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

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 at https://sfdhr.org/how-verify-education-requirements

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.

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.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application.

What else should I know?

Selection Procedures:
The selection process will include evaluation of applications in relation to minimum requirements. Depending on the number of applicants, the Department may establish and implement additional screening mechanisms to comparatively evaluate qualifications of candidates. If this becomes necessary, only those applicants whose qualifications most closely meet the needs of the Department will be invited for an interview.

Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process.

Additional Information Regarding Employment with the City and County of San Francisco:

• Information About The Hiring Process
• Conviction History
• Employee Benefits Overview 
• Equal Employment Opportunity
• Disaster Service Worker
• ADA Accommodation
• Right to Work
• Copies of Application Documents
• SFMTA Employee Wellness Program 
• Diversity Statement

How to Apply: 
Applications for City and County of San Francisco jobs are only accepted through an online process.
1. Visit Careers with Purpose | City and County of San Francisco (sf.gov)
2. Type "1823" in to the "Search by class or keyword" field.
3. Click the link to open the Job Announcement.
4. Select the “Apply Now” button and follow instructions on the screen.

Applicants may be contacted by email about this recruitment 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, @famsf.org, @ccsf.edu, @smartalerts.info, and @smartrecruiters.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.

Exam Analyst Information: If you have any questions regarding this recruitment, please contact the exam analyst, Susan.Lee@sfmta.com.

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.