Trinity Metro has an immediate opening for a Financial Planning Analyst to prepare and monitor our annual operating, capital, revenue and debt service budgets. In this role, the incumbent will perform analytical studies, prepare, and support the development of various reports to present in quarterly meetings. The incumbent performs a variety of functions in support of financial and statistical reporting related to budgets, forecasts and reporting as well as conducts cost-benefit analysis. The incumbent will gather and analyze information on operations, financial and management strategies, budgeted vs. actual expenditures, capital spending, debt service, and other tasks including administrative and technical work designed to meet departmental and organization-wide objectives.
This position’s responsibilities include:
Prepares reports and information for management (monthly variance reports, detail by vendor reports,
etc.) ensuring work of top quality both in accuracy and presentation.
Uploads budget reports to Microsoft Teams and assigns reviews to departments head and their
respective executive staff. Reviews the responses from the department heads and meets with
departments as needed. Prepares a summary report of budget to actual variations and sends out to
department heads and executive staff.
Monitors monthly activities and expenditures to ensure conformance with budgetary limits and the
Authority’s objectives. Receives comments from management after their review of the monthly
Works in conjunction with the Accounting Department to correct errors discovered during regular
analysis and prepares re-classification journal entries.
Works with the Procurement department to make sure if any errors were related to incorrect coding on
purchase orders the code is corrected and the requesting department is notified.
Periodically updates the 5-year and monthly financial cash flow models and reviews with the CFO and
Reviews the monthly financial statements and provides a detail of budget to actual variations. Meets
monthly with the Chief Financial Officer, the Controllers, and the Assistant Treasurer to discuss
variations and impacts on the budget.
Provides a list of approved capital projects to project managers at the start of the new fiscal year.
Sets up capital projects in the JD Edwards ERP system and sets up sets up contract levels to ensure the
transactions feed into the grants module in JD Edwards. Provides the project managers with capital
Updates the monthly CIP schedule and runs the monthly CIP Allocation entry in JD Edwards for the
month end. Ensures that the CIP schedule and CIP Allocation entry are in sync. If any issues arise the
analyst investigates the issues and works with the accounting department to resolve. Once the CIP
allocation is run the analyst notifies the controller the entry is ready to post.
Works with the accounting department to identify projects ready for capitalization and closes the
projects once complete.
Works with the grants department to identify grant funding opportunity for projects and identifies
projects for the quarterly Milestone Progress Reports (MPR’s) to review all the project status’s.
Works with the grants department to send out monthly Project Management Reports. Once the reports
are received from the project managers, the analyst reviews the reports and prepares summary reports
that are sent out to project managers and ELT members.
Stays abreast of current laws and regulations governing public transportation entities’ operations and
Calculates costs allocations for different modes of service based on the approved budget and actual
Projects funding needs and other expenditure requirements for various activities, including capital
Coordinates the tracking of Accounting & Finance department’s monthly KPI’s.
Maintains cost codes and business units in the JD Edwards ERP System including setting up new codes
and deactivating old codes. Periodically sends a list of codes to departments as updates are made and
assists with any coding questions departments may have.
Works with the Procurement department when a new business unit is set up to make sure approval
routes and budget holds are set up and requisitions are able to be entered for the new business units.
Meets monthly with counterparts at DART to review TRE capital and operating expenditures and
budget to actual variations.
Reviews departmental written plans and proposals for conformance to FWTA’s strategic business plan
and to ensure adequate budget funding.
Maintains a schedule of budgeted positions in Full Time Equivalents (FTE’s) and reviews with the HR
department for accuracy.
Knowledge of the JD Edwards ERP system and ability to run various queries and reports to export
accurate financial data used in the preparation of the annual budget and other various reports as needed.
Knowledge of eCivis grant management software.
Knowledge of Granicus software
Conducts research on operations and policies as they affect the budget and the budgetary process, and
develops recommendations for improvement.
Coordinates with the procurement and administration departments for the review of monthly committee action items and makes edits to ensure the financial section is in agreement with approved funding levels.
Updates the monthly Contracted Services report and sends to the A/R clerk and Assistant Treasurer for
review. Once final the sends out the report to the Senior Staff.
Prepares administrative and public information reports, including graphs, charts, summaries, and other
illustrative materials as required.
Maintains confidential information.
Any other relevant duties as assigned pertaining to the service of public transit in any capacity as
Bachelor’s Degree with major course work in business administration, accounting, budgeting, finance, or other fields applicable to financial analysis and budgeting; government and/or transit experience is a plus.
Four years’ experience in research, statistical analysis, accounting and/or budgeting; municipal or transit
operations experience is a plus with two years of experience preferred. Proficient use of spreadsheets, word processing, and presentation and graphics software.
Any combination of experience, training and/or education that provides the required knowledge, abilities and skills may substitute for the required experience.