Resource Mgmt Analyst II - Rail Div.

Texas Department of Transportation; Austin (TX); In loco; USD 60.000 - 90.000; Tempo pieno

Descrizione del lavoro

Texas Department of Transportation seeks a budget professional to monitor and analyze budget activities, forecast resources, and generate reports for administrative planning. You will interact with governmental officials and set your own work plan to meet objectives.

Responsibilities include reconciling databases, developing FHWA Tableau reports, and managing project closeouts in PeopleSoft, while ensuring accuracy in financial analyses and records.

Competenze

• Bachelor's Degree in Accounting, Finance or related discipline; experience may substitute for degree.
• 3 years budget analysis and forecasting experience; graduate education may substitute for experience.

Mansioni

• Lead rail grade crossing reconciliations between databases.
• Assist with development of FHWA Tableau reports.
• Finalize quarterly budget submission to Finance.
• Manage FHWA inactive list and close out projects in PeopleSoft.
• Oversee replanking program scope, tracking, and closeouts.
• Oversee railroad signal maintenance payment program.

Conoscenze

Budget analysis

Forecasting

Data analysis

Project coordination

Formazione

Bachelor's Degree in Accounting or Finance

Strumenti

PeopleSoft

Tableau

Descrizione del lavoro

Monitors budget activities and assists with budget preparation; analyzes human resources, equipment and resource data management; and performs complex budget/resource forecasting and reporting for District or Division. Analyzes expenditures, revenues, economic trends, and process effectiveness to develop and run scenarios for administrative planning purposes. Work requires contact with other governmental officials. Employees at this level establish their own work plan and priorities to meet set objectives. Issues are rarely referred to the supervisor but are handled at the occurrence.

Essential Duties

• Lead Rail Grade Crossing Section reconciliations between two databases (RRD-TRIMS and FIN-PeopleSoft).
• Assist the Finance team with the development of FHWA Financial System Tableau reports.
• Finalize the quarterly Section 130 submission to Finance.
• Manage FHWA inactive list, close out projects in PeopleSoft, and process Division's railroad invoices.
• Oversee the replanking program, which consist of drafting the scope of work, tracking projects, completing agreements, monitoring work orders and closing out projects.
• Oversees the signal maintenance payment program for existing railroad signals at public grade crossings.
• Performs advanced and complex database management and related reporting.
• Compiles data for specials reports and troubleshoots for data discrepancies.
• Create standard operating procedures and may train other employees.
• Performs other job responsibilities as assigned

Minimum Qualifications

Substitutions for Minimum Qualifications

• Education : Bachelor's Degree in Accounting, finance or related discipline. Relevant work experience may be substituted for degree on a year per year basis.
• Experience : 3 years budget analysis and forecasting and related experience. (Experience can be satisfied by full time or prorated part time equivalent). Related graduate level education may be substituted for experience on a year per year basis.
• Licenses and Certifications : Valid driver's license. This position requires driving a state vehicle.

Competencies

• Planning, coordinating, and handling multiple projects within area of responsibility to meet short/long term deadlines
• Analyzing and organizing business data
• Concepts, techniques, and tools used in designing and implementing database management and related technologies
• Financial management and accounting systems
• Fiscal planning and management practices
• Performing financial analysis
• Generally accepted accounting principles, procedures and terminology
• Maintaining effective working relationships with individuals and groups, both internal and external
• Communicating complex information clearly, concisely, and effectively.
• Persuasion and negotiation of critical issues
• Preparing and maintaining confidential and sensitive records, files and reports
• Training in a classroom, office, or field environment
• Using computers and applicable programs, applications, and systems

Physical Requirements and Working Conditions

• Sedentary work: Lift up to 10 lbs at a time and occasionally carry files/small tools
• Light work: Lift up to 20 lbs at a time and frequently lift or carry objects up to 10 lbs
• Talking-expressing or exchanging ideas by spoken words
• Close Visual Acuity-work includes data/figures; view a computer screen; extensive reading
• Sitting for prolonged periods of time.
• Standing for prolonged periods of time.