Budget Analyst I - Denver
Colorado Department of Transportation
Stand out for this role — generate a tailored resume and cover letter in about a minute.
Benefits offered by this job
Job summary
Colorado Department of Transportation is seeking a Budget Analyst I to support the Division of Accounting and Finance (OFMB) in Colorado. The role focuses on handling federal obligations, budget monitoring, and project funding using SAP and BI tools.
You will advise regional and HQ staff, manage monthly federal apportionment, and assist in planning and reporting for state and federal programs. A hybrid in-office/remote schedule is available.
Qualifications
- At least four (4) years of full-time professional work experience in budget administration, business administration, finance, accounting, economics, or public administration.
- Preferred qualifications include knowledge and understanding of public sector financial and budget management, project budgeting, resource allocation, and annual financial reporting in a large organization.
- Strong data analysis and use of BI tools such as SAP, PowerBI, and related software.
Responsibilities
- Compile, analyze, and submit data to FHWA to obtain project authorization for Federal reimbursement of project expenditures to CDOT.
- Perform routine reviews for project expenditures and accruals, ensuring timely reimbursement and cash flow from FHWA to CDOT.
- Submit daily activities to the FHWA FMIS system and update the CDOT system when projects are approved.
- Provide budgeting guidance to CDOT HQ, region, and business office personnel, advising on funding alternatives.
- Review regional budget actions for projects, ensuring proper funding priorities and toll credits usage.
- Assist in developing tools and guidance documents shared with stakeholders to aid managers and programs.
- Train to monitor and analyze financial status of programs and utilize BigQuery, Datamart, PowerBI to improve funding reconciliation.
- Utilize SAP and other software to interface CDOT with FHWA systems and allocate funding.
- Compile and analyze data to provide accurate, up-to-date information for management.
- Utilize Datamart, Queries, PowerBI to enhance CDOT analytics.
Skills
Education
Tools
Job description
New employees to the State will be paid biweekly. There are 26 biweekly pay periods in a year.
New employees to the State will be paid biweekly. There are 26 biweekly pay periods in a year.
New employees to the State will be paid biweekly. There are 26 biweekly pay periods in a year.
CDOT employees make a difference by providing freedom, connection, and experience to the traveling public, while also keeping them safe. The State of Colorado offers competitive medical, dental and vision insurance, life and disability insurance, and flexible spending and health savings accounts. Visit the State of Colorado benefits for details, current premium rates and a summary video about benefits. The state also offers PERA retirement, great optional PERA plans such as 401K, a generous paid time off package of annual, sick, holiday and other leave, strong career growth, tuition reimbursement and professional development. Perks include Colorado Employee Assistance Program (CSEAP) counseling, wellness, credit union membership and employee discount program. Visit CDOT Benefits for details. Some positions may qualify for Public Service Loan Forgiveness.
CDOT’s strength is our people, and our commitment to our people is to shape, support, and sustain the employee experience, and ultimately, create a supportive workplace where everyone, regardless of gender, race, ethnicity, religion, national origin, age, sexual orientation, gender identity, citizenship status, education, disability, socio-economic status, or any other identity, has the opportunity to thrive.
The eligible list created from this announcement may be used to fill current and future vacancies for a period of up to 6 months.
The Budget Analyst I works in the Colorado Department of Transportation's (CDOT's) Division of Accounting and Finance Office (DAF) of Financial Management and Budget (OFMB). The Division of Accounting and Finance is responsible for the overall financial management of CDOT. The Office of Financial Management and Budget assists the department through the monitoring of cash, spending authority, program budgets, and project budgets. The Office develops the Statewide Transportation Improvement Program (STIP), develops budgetary forms and procedures and reviews funding actions of State and Federal-Aid projects. Funds are tracked from budget to execution using various software applications. Partnering with internal and external stakeholders, including the Federal Highway Administration (FHWA), is essential.
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.
Your duties and responsibilities are performed under supervision from senior staff and will include, but not be limited to, the following:
- 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.
- With guidance from senior staff, train to:
- 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.
- Your schedule will primarily be 8:00 am – 5:00 pm work hours, Monday-Friday, but we are flexible to meet your work/life balance needs while ensuring CDOT business needs are met.
- You will work a hybrid schedule with a combination of in-office and remote work.
- Work in a politically sensitive environment
- At least four (4) years of full-time professional work experience in budget administration, 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
If you are using education to qualify, a legible copy of your official or unofficial college transcript(s) or an official foreign credential evaluation report must be submitted with your application. Transcripts must show the name of the school, completed credit hours, and (if applicable) that a degree was conferred. Transcripts from colleges or universities outside of the United States must have been assessed for U.S. equivalency by a NACES educational credential evaluation service. The credential evaluation report must be an official report. Failure to provide a transcript or official foreign credential evaluation report may result in your application being rejected and you will not be able to continue in the selection process for this position.
- 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. More information in the supplemental information section.
- 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.
The State of Colorado strives to create a Colorado for All by building and maintaining workplaces that value and respect all Coloradans through a commitment to equal opportunity and hiring based on merit and fitness.
The State is resolute in non-discriminatory practices in everything we do, including hiring, employment, and advancement opportunities.
All correspondence regarding your status in the selection/examination process will be via email. Include your current working email address on your application and check your email frequently as you could receive time sensitive correspondence regarding this position. We highly recommend that you set up your email to accept messages from state.co.us and info@governmentjobs.com addresses. It is your responsibility to ensure that your email will accept these notices and/or review your junk mail and spam filtered email. Immediately after you submit your application you should receive an email that confirms that you successfully submitted an application for this position. If you do not, try submitting again until you receive the confirmation email. Be sure to also check your junk folder for email communications from the State of Colorado's website.
- All applications that are received by the closing of this announcement will be reviewed against the minimum qualifications in this announcement. Candidates who meet the minimum qualifications proceed to the next step.
- Colorado Revised Statutes require that state employees are hired and promoted based on merit and fitness through a comparative analysis process.
- Part, or all, of the comparative analysis for this position may be a structured application review, which involves a review of the information you submit in your application materials by Subject Matter Experts (SMEs) against the preferred qualifications.
- Be sure your application materials specifically address your qualifications, experience, work products, and accomplishments as they relate to the Major Duties, Minimum Qualifications, and Preferred Qualifications sections as listed above. Failure to include adequate information or follow instructions by the deadline for application may result in your application not being accepted for this position and may affect your inclusion as a qualified candidate in any step of the selection process and placement on the eligible list.
- A top group, up to six candidates, will be invited to schedule an interview with the hiring manager.
If you believe that you are eligible to be considered as a transfer, non-disciplinary demotion, or reinstatement to this vacancy, you must submit a completed application following the directions in this job announcement and you will be included in the selection process along with other qualified applicants. If you are the finalist for this position after the selection process, Human Resources will confirm your eligibility to be appointed as a transfer, non-disciplinary demotion, or reinstatement applicant.
If an applicant reaches the finalist stage of the hiring process, the Colorado Department of Transportation may procure a consumer report and/or investigative consumer report on the applicant in connection with his/her application for employment purposes, as defined under the Fair Credit Reporting Act. These reports may be obtained at any time after receipt of the applicant's authorization. As part of the employment screening an applicant will be requested to disclose any deferred judgments and convictions as well as an explanation of the circumstances around any arrest or conviction. In the event that a screening returns information that the applicant believes is not accurate, he or she will have an opportunity to dispute the information with “Accurate.” Accurate
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
