Accountant II - Program Accountant

Overview

This position is open to current Colorado residents only. Remote Work/Hybrid:
In office 2 days a week, Remote 3 days a week. Fort Logan/1575 Sherman.

Most State of Colorado employees are eligible for a great benefit package. Remote Work/Hybrid arrangements are subject to change.

About this Unit:
Program Accounting exists to provide accountable financial information about the Human Services Programs, both State and Federal, to the Management of the Department of Human Services, the State Controller's Office, the federal government, the county departments of social/human services and others in need of information in an efficient and timely manner.

This is a professional accounting position that generates, compiles, analyzes, and interprets all the accounting and reporting functions for all State and Federal programs assigned. The position will be responsible for understanding and maintaining the accounts and records in CORE.

Daily Accounting Activities:

• Accesses fiscal systems to produce, correct, audit, approve, and input financial and budget transactions that pertain to the Federal and State Programs. Also analyzes information on an as-needed basis for all assigned programs. This includes accessing all systems for the financial, budget, and payment information as needed by supervisors, peers, program staff, auditors, and county staff producing accurate auditable data using established procedures and manuals.
• Provide specific examples of regular, ongoing decisions made by this position related to this duty.

Reconciliation of Program Expenditures and Revenues:

• Reconciles all general and grant ledger accounts relative to all expenditures, revenue, obligations for all assigned programs, both federal and state, by analyzing and investigating various types of errors and interpreting the account expenditures and balances of funds available and using the data received from all financial systems to produce accurate and complete information for federal and management reporting.
• Provide specific examples of regular, ongoing decisions made by this position related to this duty.

Financial Analysis:

• Prepares and interprets system reports for all assigned programs, and Budget by utilizing a variety of excel spreadsheets to manipulate, enhance, combine the elements and different levels of detail present in CORE and the reports they produce. Said spreadsheets to be used in the budgeting and reporting process pertaining to all assigned programs.
• Assist program in budgeting process and proper spending activities.

Monitoring:

Monitors budget balances and resolves any problems with the budget division by preparing budgetary documents for allocations, transfers, increases, decreases, and corrections for the appropriations belonging to the programs assigned.

Year End Close:

Executes year end closing of all accounts related to programs assigned by utilizing and analyzing CORE and other financial information. Make adjusting JV entries, clean up general ledger accounts, and produce required financial exhibits using the information available in CORE.

Experience:
Six (6) years of relevant experience in an occupation related to the work assigned to this position, specifically accounting, finance, payroll.

OR Education and Experience:

• A combination of related education (27 semester hours in accounting or auditing) and/or relevant experience equal to six (6) years
• Current, valid licensure as a CPA by the Colorado Board of Accountancy will count for six (6) years of the requirement

Additional Requirements: The ideal candidate will have strong analytical skills and advanced proficiency in Microsoft Excel, including VLOOKUP, XLOOKUP, Pivot Tables, and data analysis. Candidates must complete and pass an Excel skills test as part of the hiring process to demonstrate these abilities.

Professional Experience Definition:See details below for components typically involved in professional accounting experience (examples provided).

• Analysis of financial transactions to determine accuracy, completeness, and conformance to established policies and procedures and generally accepted…