Budget Analyst I - Denver

State of Colorado•Denver, CO

5d•Hybrid

About The Position

This position assists in the implementation of the state administered capital construction program, the obligation of federal dollars and project level budgeting. It advises regional and Headquarter (HQ) business office staff and other partners on the requirements for Federal authorization and reimbursement and achieving the Division’s financial management goals. Projects are created and funded in the SAP software and as necessary submitted to Federal Highway Administration (FHWA) for authorization and partnership. The Budget Analyst assists with ushering projects through the appropriate planning and budgeting processes as well as providing program level support and monitoring. This position performs routine federal obligation and advance construction conversions of the state administered capital construction program and other Federal and State funded programs such as Asset Management, the 10-Year Plan, Federal Grants and Earmarks. This position supports the work lead and manager with the monthly federal apportionment and obligation balance reconciliation.

Requirements

At least four (4) years of full-time professional work experience in business administration, finance, accounting, economics, public administration, or another field closely related to the duties of this position.
A combination of relevant education and experience equal to at least four (4) years.
Education from an accredited college or university with coursework in business administration, finance, accounting, economics, public administration, or another field of study closely related to the duties of this position will be considered.
Professional work experience in business administration, finance, accounting, economics, public administration, or another field closely related to the duties of this position will be considered.
Must pass a pre-employment screening which may include social security number trace, criminal records check, public court records check, educational records, and driving records checks.

Nice To Haves

Demonstrated success with the duties listed in the Description of the Job section
Years of State service experience related to the duties of this position
Highest work/personal ethics and integrity
Knowledge and understanding of theories, principles, and best practices of public sector financial and budget management, project level budgeting, resource allocation, and annual financial reporting in a large organization
Understanding and experience in financial analysis and budgetary processes
Governmental budget analysis experience, including analyzing project budgeting
Statistical analysis skills and experience
Policy analysis skills and experience
Strong aptitude for, and experience working with data and using integrated software solutions and business intelligence tools
Proven ability to manage multiple assignments, priorities, and projects in a demanding environment
Ability to work under tight deadlines and be adaptable to changing assignments
Ability to take initiative to solve problems in an innovative manner
Interpersonal and relationship building skills
Strong time and project management skills, including prioritization
Excellent reasoning, investigative, analytical, and problem-solving skills
Excellent oral and written communication skills, including presentation and facilitation skills
Strong attention to technical detail and accuracy
Strong research skills
Ability to work effectively in both independent and team situations
Fluency in Microsoft Office Suite (Word, Excel), Gmail and Google Applications, SAP, and the ability to quickly learn other software systems
Strong spreadsheet and other data analysis software experience highly preferred including use of PowerBI or other analysis and reporting tools.

Responsibilities

Compile, analyze, and submit data, including required supporting documentation, to Federal Highway Administration to obtain project authorization for Federal reimbursement of project expenditures to CDOT.
Perform routine reviews for project expenditures and accruals, looking for opportunities for “obligation” and subsequent reimbursement by FHWA, executing numerous monthly transactions to ensure that reimbursement and cash flow from FHWA to CDOT is occurring promptly and appropriately.
Submit daily activities to the FHWA FMIS system and update the CDOT system when projects are approved.
Provide guidance to CDOT headquarter, region, and business office personnel in preparing project budget requests, including recommending funding alternatives and advising on best management practices in the financial management of projects.
Review regional budget actions for projects, ensuring the funding priorities and use of toll credits follow CDOT’s guidelines.
Assist in developing tools and guidance documents that are shared with stakeholders to help managers of projects, programs, and others.
Monitor and analyze the financial status of the various state highway administered programs such as Asset Management and Planning and Research.
Utilize analytical skills and technology such as BigQuery, Datamart, PowerBI to improve the methods for reconciling available funding.
Analyze, model and provide updates on the status of Federal Highway Administration funding including apportionment balances, obligation limitation balances, status of advance construction, projections for federal redistribution of funds and possible lapsing and/or rescissions.
Utilize the applications and processes for interfacing CDOT’s software with FHWA’s software.
Compile and analyze data to provide accurate, up-to-date information in a logical manner with adequate detail to the Department's management.
Utilize Datamart. Queries, PowerBI and other tools to enhance CDOT's current analytical capabilities.
Serve as a back up to the Pool Operation analyst in reviewing transaction data entered into EcoInteractive software for the Statewide Transportation Improvement Program (STIP) and use SAP to allocate funding to the various regions and programs for subsequent budgeting.
Other duties as assigned.