Senior Financial Analyst

The Bay Area Rapid Transit District (BART) is seeking Sr. Financial Analysts to join the Office of Infrastructure and Delivery (OID) Department. This job announcement will be used to establish a list of eligible candidates for vacancies that may occur within the next 12 months.

The selected incumbents will be responsible for:

• Complex, multi-year capital project operations and financial support, including but not limited to monitoring / administrating contracts, service agreements, various source of funding grants, setting budgets / plans, ensuring project compliance, monitoring and controlling expenditures, highlighting risk areas and proposing/executing/monitoring corrective actions, periodic reporting to stakeholders on project financials, etc.
• Data analytic support, including but not limited to data mining, cleansing and structuring to enable automatic dashboards to highlight relative business trends, risks and opportunities, etc.

Key responsibilities for these positions include identifying and resolving complex financial and analytical issues, which require strong analytical and execution abilities, such as:

• Working independently and defining workload
• Project planning and project management
• Taking initiative, including the introduction and support of changes to processes and procedures; identifying and understanding issues, problems and opportunities; and devising appropriate solutions
• Building and maintaining good work relationships with cross functional teams
• Clearly communicating findings and strategy recommendations to stakeholders in verbal, written and other visual forms
• Advanced skills using Excel (e.g. Pivot table, lookup and reference functions, if statements, data importing and linking), Word and PowerPoint
• Experience with ERP financial software such as Oracle/PeopleSoft Financials including budgeting, planning, commitment control and procurement

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.

• Operations, services and activities of a comprehensive budget and financial control program.
• Principles of lead supervision and training.
• Principles of financial and operational analysis.
• Federal, State and local funding programs, associated guidelines and processes.
• Principles and practices of project management.
• Principles and practices of engineering and construction management.
• Advanced principles, practices, and procedures of accounting.
• Financial, statistical and comparative analysis principles, techniques and formulas.
• Principles and practices of project budget development, administration and control.
• Principles and practices of procurement.
• Methods and techniques for assessing performance against established objectives.
• Principles and practices of project scheduling.
• Principles and practices of financial record keeping and reporting.
• Current office procedures, methods and equipment including computers.
• Applicable financial computer software applications.
• Related Federal, State and local codes, laws and regulations.

• Independently performing the most difficult financial and statistical analyses.
• Interpreting and explaining department policies and procedures.
• Leading, organizing and reviewing the work of assigned staff.
• Monitoring and reporting budget variances.
• Analyzing problems, identifying alternative solutions and implementing recommendations.
• Identifying funding sources for proposed and current projects.
• Creating timely purchase requisitions and disbursements of purchase orders.
• Performing accurate complex financial calculations.
• Utilizing, maintaining and updating computerized financial/project management systems and reports.
• Developing, organizing, reviewing and analyzing technical documents, proposals, contracts, and reports.
• 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.

Salary : $120,931 - $146,973