Program Budget Analyst (Budget and Grant Manager)

Program Budget Analyst (Budget and Grant Manager)
Arapahoe County Government Community Resources Department
 Littleton, Colorado
Job Description

The Program Budget Analyst duties will cover the full field of the accounting spectrum including governmental accounting, grant accounting, financial reporting and analysis, internal auditing, and the review, analysis, design, and monitoring of internal controls, regulations, and governance. This position works independently with minimum supervision and provides assistance on behalf of the Finance and Administrative Services division manager.


This position will oversee the coordination, reporting and review across all duties. This includes collaboration with other team members to clarify information, data research, provide recommendations and education when needed.


  • Manages the month-end close process under areas of responsibility to include analysis, budget reporting, reconciliation, and compliance oversight.
  • Reviews source documents for completeness, mathematical accuracy, proper authorization, sufficiency of information and budget, proper fund/account combinations, and overall allocability and allowability.
  • Assists division manager with the review, update and evaluation of internal controls, policies and procedures over program and accounting activities.
  • Develops, establishes, and maintains various in-house spreadsheets, schedules, and governing documents to ensure compliance and reconciliation.
  • Records a variety of accounting transactions as needed to complete the month-end close process including journal entries, accounts receivables, and more.


  • Monitors and tracks grant budgets and assists program supervisors with the interpretation, monitoring, and management of respective budgets.
  • Meets with department leaders, program supervisors, and external agencies on a monthly/quarterly basis to provide comprehensive financial analysis and budget reporting, to include trends, performance, and projections.
  • Completes financial projects, models, analyses, and studies as directed. Prepares detailed reports outlining the data, findings, and conclusions.
  • Enters, verifies, and maintains data within SAP and partners’ budget and financial software systems and additional spreadsheets. Creates and modifies custom reports from budget and financial software to assist in the development of budget reports and analyses.
  • Serves as subject matter expert on program management and processes. Educates and informs team of new funding streams, funding provisions, allowability, and applicable regulations.
  • Responsible for creating grant budgets in SAP and related schedules.
  • Analyzes and reviews department accounts payable, accounts receivable, and various accounting transactions within SAP to ensure compliance with regulations and governing documents.


  • Develops grant compliance monitoring and reporting processes to ensure compliance with all applicable regulations.
  • Division representative for audits and monitoring reviews under area of responsibility; provides deliverables, manages the process, and answers requests as required.
  • Ensures compliance of sub-recipient monitoring.


  • Contract and grant review to ensure regulatory and governance compliance, adequacy of billing and budget information, coding, budget, and schedule set up.
  • Ad-hoc financial reporting and modeling as requested.


  • Ability to communicate effectively, both orally and in writing; ability to establish and maintain working relationships with elected officials, department directors, supervisors, contracted auditors, consultants, financial institutions, professional peers, other employees, and the general public. Ability to exercise good judgement with all interactions and decision-making.
  • Experienced in recognizing, investigating and analyzing a variety of financial, operational and administrative problems within an ERP system and some ability to develop alternatives and appropriate solutions.
  • Working knowledge of pronouncements of Generally Accepted Accounting Principles (GAAP), Governmental Accounting Standards Boards (GASB), American Institute of Certified Public Accountants (AICPA), principles of specialized accounting areas such as governmental funds, debt service, capital assets, internal controls and risk management.
  • Working knowledge of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards (Uniform Guidance)
  • Working knowledge of Generally Accepted Auditing Standards (GAAS).
  • Experience in working in an accurate, independent and organized manner.
  • In-depth knowledge and ability to prepare and interpret comprehensive financial reports, special reports, and spreadsheets as requested.
  • Strong Microsoft Excel skills to include LOOKUPs, pivot tables, and INDEX formulas.

BEHAVORIAL COMPETENCIES (these are required for all positions at ACG):

  • Service First
  • Excellent Quality
  • Responsive Government
  • Visionary Thinking
  • Innovation
  • Caring Leadership
  • Effective Communication
  • Fiscal Responsibility
  • Integrity
  • Respect for Others
  • Safety
  • Teamwork


Education and Experience:

  • Bachelors Degree in Accounting, Finance or Business Administration
  • 3+ years accounting and grants/contract program administration experience
  • Any equivalent combination of education and work experience that satisfies the requirements of the job will be considered.


Pre-Employment Additional Requirements:

  • Must successfully pass pre-employment testing which includes a background check.


  • Work is generally confined to a standard office environment.


The following are some of the physical demands commonly associated with this position.

  • Spends 90% of the time sitting and 10% of the time either upright or walking.
  • Occasionally lifts, carries, pulls or pushes up to 20 lbs.
  • Occasionally uses cart, dolly, or other equipment to carry in excess of 20 lbs.
  • Occasionally climbs, stoops, kneels, balances, reaches, crawls and crouches while performing office or work duties.
  • Verbal and auditory capacity enabling constant interpersonal communication through automated devices, such as telephones, radios, and similar; and in public meetings and personal interactions.
  • Constant use of eye, hand and finger coordination enabling the use of automated office machinery or equipment.
  • Visual capacity requiring constant use of computer or other work- related equipment.


  • Occasionally: Activity exists less than 1/3 of the time.
  • Frequently: Activity exists between 1/3 and 2/3 of the time.
  • Constantly: Activity exists more than 2/3 of the time.