Financial Analyst: Transportation Forecasting & Budgeting

Temple Health; Alexandria (VA); On-site; USD 70,000 - 90,000; Full time

Job summary

RM Advisory Services is seeking a Financial Analyst to support WMATA’s Office of the Chief Financial Officer. You will build Excel-based models and forecasting tools for personnel costs, revenue, contracts, grants, and operating expenses, and support two-year and six-year financial forecasting and long-range affordability analyses.

You will prepare clear summaries for leadership in Excel, PowerPoint, and Word.

Qualifications

• Bachelor’s degree required in Finance, Accounting, Economics, Business, Public Administration, Data Analytics, or a related field.
• 2–5 years of relevant experience in financial analysis, budgeting, forecasting, or data analysis specific to the government or transportation field.
• Must be located in the Washington, DC metropolitan area.
• Strong Excel and financial modeling skills.
• Strong analytical, problem-solving, communication, and organizational skills.
• Government and/or transportation sector experience strongly preferred.

Responsibilities

• Build Excel-based financial models and forecasting tools for personnel costs, revenue, contracts, grants, and operating expenses.
• Support two-year and six-year financial forecasting and long-range affordability analysis.
• Perform budget-to-actual variance and expense trend analysis.
• Develop business cases, cost-benefit analyses, and staffing alternative analyses.
• Forecast fare and non-fare revenue and perform scenario and sensitivity analysis.
• Support grant, subsidy, contract, operational, and energy cost analyses.
• Create reusable templates, dashboards, and reporting tools.
• Prepare clear Excel, PowerPoint, and Word summaries for leadership.

Skills

Excel modeling

Financial analysis

Forecasting

Data analysis

Communication

Organizational skills

Education

Bachelor’s degree

Job description

RM Advisory Services is seeking a Financial Analyst to support WMATA’s Office of the Chief Financial Officer. You will build Excel-based models and forecasting tools for personnel costs, revenue, contracts, grants, and operating expenses, and support two-year and six-year financial forecasting and long-range affordability analyses.

You will prepare clear summaries for leadership in Excel, PowerPoint, and Word.