Grant Funding Accountant - Office of Fiscal Services

Job Description
Job Title : Grant Funding Accountant
FLSA Exemption Status : Exempt
Classification Group : Professional Technical
Supervising Position : Controller or designee
Pay Plan : Professional Technical
Pay Range : Range 04
Last Updated : 7/22/2024
Pay Information
Benefits Information
JOB SUMMARY : Under minimal direct supervision, proactively perform accounting activities related to specific reporting and compliance requirements. Support and assist in the proper recording and reporting of general accounting activities. Demonstrate professionalism while coordinating and collaborating with schools, district departments, and outside entities that are involved with capital projects and grants funding as well as the district's federal, state, and private financial assistance programs. Using the Oracle platform, monitor the proper accounting for and reporting of such programs for the district. Ability to interact and collaborate efficiently and effectively District wide. Provide support to the Controller and Assistant Controller.
ESSENTIAL DUTIES AND RESPONSIBILITIES : The following tasks describe the basic functions of the job and represent the type of work performed. They do not constitute an exhaustive list of the duties and responsibilities performed on the job. The following frequencies and percentage of time spent are approximations only and are subject to flexibility dependent on organizational needs.
Job Task Descriptions - SHARED JOB DUTIES ACROSS ASSIGNMENTS Frequency Percentage of Time
1.
Utilizing the ERP platform, compile and analyze data and monitor the coding, recording, and reporting of projects and activities through various district departments and other relevant sources. Prepare and input correcting journal entries resulting from in depth ERP reporting analysis of accounting information. Partner with Payroll specialists to facilitate payroll corrections as needed.
Daily 10%
2.
Prepare monthly reports and presentations as needed or requested for district administration, Superintendent's Cabinet, and Board of Education.
Monthly 10%
3.
Create and manage ERP report tracking documentation (i.e. spreadsheets) to assist in the monitoring, reporting and recording of accounting activities.
Weekly 5%
4.
Maintain ERP accounting system databases, tables, and programs.
Monthly 5%
5.
Work in partnership with external auditors and provide data analysis as required, including work papers, schedules, and access to accounting records for federal, state, and private programs.
Annually 5%
6.
Perform other duties as assigned or requested.
Daily 5% TOTAL 35%
Job Task Descriptions - GRANT FUNDING ASSIGNMENT JOB DUTIES Frequency Percentage of Time
1.
Utilizing the ERP platform, compile, analyze, and monitor the coding, recording, and reporting of grant projects and activities through the Special Populations Department, Federal Projects Office, Cherry Creek Schools Foundation, and other relevant sources. Daily 10%
2.
Maintain the district's Grants Activities reporting system in ERP platform to ensure the accurate accounting and reporting of grant projects and activities, including the monitoring and assistance in the tracking, recording and closing of multiple year grant accounts. Daily 10%
3.
Perform monthly reconciliation on grant accounts, ensuring all transactions are posted to the general ledger. Monthly 10%
4.
Utilizing the ERP platform, analyze detail, and compile data for selected federal, state, and private programs regularly scheduled reports. Prepare monthly, quarterly, and annual financial reports for other federal programs. Coordinate the timely filing of accurate reports to appropriate external agencies. Monthly 10%
5.
Advise school bookkeepers and department staff of Generally Accepted Accounting Principles (GAAP) and other federal regulations and provide guidance for the proper accounting reporting for compliance with federal, state, and private requirements relating to the financial assistance programs. Advise and assist in formulating corrective action plans as needed. Daily 5%
6.
Maintain up-to-date information relating to the compliance requirements of federal, state, and private financial assistance programs. Distribute and communicate current results with appropriate district personnel. Daily 5%
7.
Perform system development tests for ERP system patches and upgrades. Create and monitor ERP system case support tickets. Monthly 5%
8.
Provide support and assistance in maintaining the accounting records and reports for the Cherry Creek Schools Foundation. Utilizing ERP system reports, assist with the preparation of the Foundation's annual financial audit. Monthly 5%
9.
Work in partnership with the Grants team in formulating budgets for the Grants programs. Provide accurate analysis and data collected from the ERP system, including calculated account totals. Forecast remaining grant activity and project balances for district administration and Grant personnel. Annually 5% TOTAL 65%
Job Task Descriptions - PROJECTS AND FIXED ASSETS ASSIGNMENT JOB DUTIES Frequency Percentage of Time
1.
Manage the district's capital projects activities system within the ERP platform to ensure the accurate accounting for the reporting of capital construction projects and capital assets. Daily 10%
2.
Determine the value of capital asset additions, disposals, and adjustments, and record them in accordance with Generally Accepted Accounting Principles (GAAP). Daily 10%
3.
Stay abreast of the requirements and best practices of financial and accounting compliance related to capital project activities and capital assets. Keep department and school staff appraised of GAAP. Daily 10%
4.
Prepare annual capital asset reports and end-of-year capital asset financial audit schedules. Annually 5%
5.
Participate in formulating budgets for the capital project programs, including checking details and calculating account totals. Assist with forecasting remaining capital project activity and project balances for district administration and other personnel. Monthly 5%
6.
Test the ERP system patches and upgrades in relation to AC (activities), AM (asset management), and GL (general ledger) modules. Create and monitor ERP system case support tickets. Perform monthly close process for the applicable modules in the ERP system. Monthly 5%
7.
Maintain district's financial leases. Perform monthly reconciliation on fixed asset accounts, ensuring all transactions are posted to the general ledger. Prepare and input correcting journal entries resulting from analysis of such accounting information. Monthly 5%
9.
Assist district personnel with maintenance of physical inventory and tracking of assets.
Quarterly 5%
10.
Monitor, analyze and report the capital project accounting activities. Create monthly reconciliation reports on capital project accounts, ensuring all transactions are posted to the general ledger. Monthly 5%
11.
Provides professional consulting, training, advising, directing, and mentoring services to district personnel related to capital/operating projects and fixed assets. Daily 5% TOTAL 65%
REPORTING RELATIONSHIPS : This job has no direct supervisory responsibilities.

• N/A

MINIMUM QUALIFICATIONS : The minimum prerequisites of formal education, professional work experience, certifications, licenses, endorsements, designations, trainings, and other criteria that a candidate must fulfill to be considered for a position. It is essential that certifications, licenses, endorsements, designations, and trainings are fulfilled, valid, and not expired.

• Criminal background check and fingerprinting required
• Bachelor's degree in accounting or similar field
• Three (3) years of accounting, accounts payable, accounts receivable, banking, bookkeeping, budget, or financial planning and analysis experience
• Demonstrated passion for education
• Intermediate knowledge of accounting (e.g. posting, account reconciliation, account analysis)
• Intermediate analytical skills, including statistical analysis and the use of spreadsheets
• Intermediate critical thinking, problem solving, and organizational skills
• Strong written and oral communication skills
• Intermediate Microsoft Office skills, with emphasis on Excel
• Ability to operate a ten-key adding machine
• Ability to be flexible and adjust to changing priorities
• Ability to work independently and collaboratively with others
• Criminal background check and fingerprinting required for hire

PHYSICAL REQUIREMENTS AND WORKING CONDITIONS : The physical demands, mental functions, cognitive capacities, and work environment factors required to perform a position's essential functions.

• Light work strength level (lifting or carrying up to 25 pounds)
• Primarily works indoors
• Sedentary work
• Frequent bending, reaching, and lifting
• Eye/hand coordination (e.g., typing, ten key)
• Visual concentration on equipment
• Concentrated reading/writing/mathematics
• Normal office environment
• Normal school district environment
• Work location is subject to change to meet the requirements of the organization

DESIRED QUALIFICATIONS : Formal education, professional work experience, certifications, licenses, endorsements, designations, trainings, and other qualifications relevant to the position that are strongly preferred but not mandatory for a candidate to be considered.

• Experience working in public education
• Experience working with Oracle software
• Experience working directly with people from diverse racial, ethnic, and socioeconomic backgrounds
• Racially conscious and culturally competent with the skill, will, capacity, and knowledge to commit to a culture of continuous improvement
• Impeccable attention to detail