Senior Financial Analyst

San Francisco Bay Area Rapid Transit District (BART); Oakland (CA); On-site; USD 128,000 - 156,000; Full time

Job summary

San Francisco Bay Area Rapid Transit District (BART) seeks a Senior Financial Analyst to administer and monitor complex, multi-year Professional Service Agreements, review invoices for compliance, and perform financial analyses from concept through decommitment.

The successful candidate will bring advanced Excel skills, experience with ERP systems such as Oracle/PeopleSoft, and the ability to prepare budgets, forecasts, and management reports for senior leadership.

Qualifications

• Bachelor’s degree in business administration, accounting, economics or related field.
• Three years of professional budgetary, financial, or management analysis experience.
• Additional professional experience may substitute for education on a year-for-year basis.

Responsibilities

• Administer and monitor complex, multi-year professional service agreements.
• Review invoices for budget conformity and cost control.
• Prepare budgets and five-year forecasts for capital projects and programs.
• Coordinate with other departments, divisions and external agencies to monitor funds and ensure compliance.

Skills

Financial analysis

Budgeting/forecasting

Communication skills

Project management

Education

Bachelor’s degree in business administration, accounting, economics or related

Tools

Oracle/PeopleSoft Financials

Excel

Word/PowerPoint

Job description

Pay Rate

AFSCME Pay Grade 13

Annual Salary: $128,356.80 (Step 1) - $156,020.80 (Step 5)

Note: Initial negotiable annual salary will be commensurate with education and experience.

Reports To

Senior Manager of Agreement Management

Days Off

Saturday/Sunday

Who May Apply

All current BART employees and Future BART employees

Current Assignment

San Francisco Bay Area Rapid Transit (BART) is seeking to fill one (1) Senior Financial Analyst position.

The Senior Financial Analyst will be responsible for administering and monitoring complex, multi-year Professional Service Agreements, including reviewing invoices for contractual and financial compliance, performing financial, statistical, and comparative analyses of actual and budgeted costs, conducting overhead true-ups, and developing work plans from initial conception through decommitment. The position will also perform related financial and agreement management duties as assigned by the Senior Manager of Agreement Management.

The most qualified candidate for this position will have highly developed competencies beyond the minimum qualifications in the following areas, which will be reinforced with related work experience and will be clearly articulated during the selection process:

1. Principles and practices of capital budgeting and financial management.
2. Familiarity with general accounting principles and Federal Acquisition Regulation (FAR)

1. Ability to reconcile data from multiple sources, ensure data accuracy and consistency, and support the automation and enhancement of financial reports and analyses.

1. Strong presentation and communication skills to effectively articulate project financial management information derived from data and analytical reports.
2. Ability to develop and foster relationships with all levels of the organization, as well as external entities and/or customers.
3. Problem-solving skills, including the ability to identify and frame issues, analyze relevant data, and develop clear statistical or narrative summaries for presentation to management.
4. Ability to develop, evaluate, and continuously improve systems and processes to enhance efficiency, accuracy, and effectiveness.
5. Strong prioritization skills with the ability to manage multiple projects and maintain high attention to detail.
6. Advanced proficiency in Microsoft Excel (e.g. Pivot table, lookup and reference functions, if statements, data importing and linking), Microsoft Word and PowerPoint.
7. Experience with ERP financial software such as Oracle/ PeopleSoft Financials including budgeting, planning, commitment control and procurement.

Application & Selection Process

The selection process for this position may include one or more of the following: a skills or performance demonstration, written examination, and/or panel or individual interview.

All applications will be reviewed by the Talent Acquisition Division to determine whether applicants meet the established Minimum Qualifications (MQs). Applicants who meet the MQs may be referred to the hiring department for further evaluation as part of the selection process.

The selected candidate must demonstrate a work history reflecting reliability and dependability and may be required to provide copies of certificates, diplomas, or other documentation required by law, including proof of authorization to work in the United States.

Pre-employment processing will include a background check. This requirement does not apply to current full-time District employees unless the position requires additional evaluations or clearances.

1. Participates in the more difficult work of staff responsible for complex financial, statistical, and program management analysis in assigned division area.
2. Participates in the preparation, administration, and monitoring of District-wide budgets; compiles and analyzes budget data; monitors funding agreements and maintains budget schedules to assure conformance with funding agencies; ensures maintenance of expenditure records which conform to funding agency and District reporting requirements.
3. Analyzes contract provisions and change orders related to approved cost of work and budget allocations; analyzes and reports cost variances, ensures that cost control methods are implemented and applied to program objectives; analyzes funding and cost data for management inquiries regarding work plans, consultants, and contract authority.
4. Monitors and administers construction or funding agreement contracts in accordance with District and mandated guidelines; compiles actual costs by project; performs financial, statistical and comparative analysis of actual and budget costs.
5. Identifies funding sources for proposed projects; projects cash flow requirements; maintains budgetary records for proposed projects.
6. Provides support to project managers in setting budgets, schedules and estimates; tracks progress on projects versus original budgets and schedules; works closely with project staff and consultants to ensure project compliance.
7. Develops and recommends improvements to computerized financial management system.
8. Coordinates project activities with other departments, divisions and external agencies; works closely with other divisions to apply for and monitor the use of fund grants from city, county, state, and federal sources; monitors work in progress and authorizes contract payments.
9. 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.
10. May train assigned employees in their areas of work including budgeting and financial analysis methods, procedures and techniques.
11. Prepares quarterly, semi-annual, and special analytical and statistical reports on operations and activities for management, regulatory and outside agencies.
12. Reviews invoices; determines budget conformity; reports discrepancies and billing adjustments.
13. Prepares the Annual Budget and the 5-Year forecast for each capital project and program assigned; involves budgeting for staffing requirements and coordinating with various departments who support the projects; includes budgeting for non-labor expenses for the budget year and for the out years.
14. Participates in special projects as assigned.

Education

A Bachelor's degree in business administration, accounting, economics or a closely related field from an accredited college or university.

Experience

Three (3) years of (full-time equivalent) verifiable professional budgetary, financial, or management analysis experience.

Substitution

Additional professional experience as outlined above may be substituted for the education on a year-for-year basis. A college degree is preferred.

Knowledge of

• Operations, services and activities of a comprehensive budget and financial control program.
• Principlesofleadsupervisionandtraining.
• Principlesoffinancialandoperationalanalysis.
• Federal,Stateandlocalfundingprograms,associatedguidelinesand processes.
• Principlesandpracticesofprojectmanagement.
• Principlesandpracticesofengineeringandconstructionmanagement.
• Advancedprinciples,practices,andproceduresofaccounting.
• Financial,statisticalandcomparativeanalysisprinciples,techniquesand formulas.
• Principlesandpracticesofprojectbudgetdevelopment,administrationand control.
• Principlesandpracticesofprocurement.
• Methodsandtechniquesforassessingperformanceagainstestablished objectives.
• Principlesandpracticesofprojectscheduling.
• Principlesandpracticesoffinancialrecordkeepingandreporting.
• Currentofficeprocedures,methodsandequipmentincludingcomputers.
• Applicablefinancialcomputersoftwareapplications.
• Related Federal, State and local codes, laws and regulations.

Skillin

• Independently performing the most difficult financial and statistical analyses.
• Interpretingandexplainingdepartmentpoliciesandprocedures.
• Leading,organizingandreviewingtheworkofassignedstaff.
• Monitoringandreportingbudgetvariances.
• Analyzingproblems,identifyingalternativesolutionsandimplementing recommendations.
• Identifyingfundingsourcesforproposedandcurrentprojects.
• Creatingtimelypurchaserequisitionsanddisbursementsofpurchaseorders.
• Performingaccuratecomplexfinancialcalculations.
• Utilizing,maintainingandupdatingcomputerizedfinancial/projectmanagementsystems and reports.
• Developing,organizing,reviewingandanalyzingtechnicaldocuments,proposals, contracts, and reports.
• Exercising a high degree of individual initiative, discretion, diplomacy, accuracy, and judgment.
• Understandingandfollowingoralandwritteninstructions.
• Communicatingclearlyandconcisely,bothorallyandinwriting.
• Establishingandmaintainingeffective working relationships with those contacted in the course of work including internal departments, vendors, and consultants.