Senior Budget Administrator - Data Support

Metropolitan Transportation Authority

2d • $52

About The Position

Assist in the effective development and analysis of the Maintenance of Equipment department's 5-year annual budget and forecast. Take the lead in streamlining and automating analysis by working with the appropriate departments to ensure key financial data is available and accurately reported. Maintain analysis databases and create various financial reports to help understand and explain financial performance to the budget.

Requirements

• Bachelor's degree in accounting, Finance, Business, Computer Science is required. In lieu of a degree, candidates may be considered with 7 years of related experience with data systems, strong analytical and critical thinking skills, accounting procedures, finance, cost control, budgeting, forecasting, and general business practices.
• A minimum of three years' experience in accounting, finance/business/budget/financial systems is required.
• Must possess knowledge of accounting procedures, Finance, Cost Control, Budgeting, Forecasting and General Business Practices and Data Systems.
• Must possess a strong understanding of Corporate Financial Systems (BSC PeopleSoft, PMS/Hyperion, MPS, CTAMS, Procurement) and how financial data is captured and reported (General Ledger strings and accounts).
• Must possess the ability to work with analytical concepts.
• Must possess strong interpersonal and communication skills (written and oral).
• Must possess advanced PC and software application skills, including Microsoft Excel CV[1]lookups, pivot tables, SmartView, Sybase, Access, Crystal reporting, Adobe, Word, and PowerPoint.
• Must possess knowledge of the Operating Department's operations.
• Strong understanding of Corporate Financial Systems (BSC PeopleSoft, FMS/Hyperion, MPS, CTAMS, Procurement) and how financial data is captured and reported (General Ledger strings and accounts).

Nice To Haves

• Understanding of LIRR and M/E operations preferred

Responsibilities

• Assist in the preparation and analysis of the Maintenance of Equipment department's annual operating and reimbursable budgets and forecasts.
• Utilize the BSC PeopleSoft system and queries to run and download weekly and monthly financial data required to analyze and prepare the monthly budget variance analysis.
• Take lead interfacing with Operating departments, Accounting, Procurement & Logistics, IT, and BSC departments to ensure essential financial data required for variance analysis is accurately reported and available in financial systems. Understand financial systems and the flow of data.
• Recommend and initiate procedures and controls to improve and automate analysis. -Maintain and develop Access databases and complex Excel files using pivot tables and V-lookups to analyze large volumes of data to compare budget plans, budget revisions, and actuals to budget.
• Develop and maintain a budget database and files that calculate manpower and overtime requirements based on projected gross hours of work and employee availability
• Analyze non-payroll services and material consumption and identify and explain variances to budget and forecast.
• Upload and/or input calculated budget information into Corporate Financial Management System (PMS) and run reports and/or extract data using SmartView and Essbase.
• Perform various assignments as required by the Manager-Budget Development and Analysis

Benefits

• Commuting Assistance - based on operating MTA agency (complimentary transportation pass within the MTA's jurisdiction and tax-advantaged accounts)
• Low Premium - High Quality Health Insurance Plans (lifetime coverage for eligible retirees and their dependents)
• Pension plans and retirement savings accounts for eligible employees
• Generous Paid Time Off and Holidays provided.
• Tuition Reimbursement for eligible employees
• Employee Assistance Programs
• MTA Exclusive Employee Discount Programs
• Work Life Services team and Office of the Chaplains unit
• Employee Resource Groups

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees