Projects and Bond Accountant - Educational Services Center

Cherry Creek Schools•Denver, CO

7d•Onsite

About The Position

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, central departments, and outside entities. Using the enterprise resource planning (ERP) 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. Assignments include Grant Funding, Projects and Bond, and Projects and Fixed Assets.

Requirements

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

Nice To Haves

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

Responsibilities

Utilizing the ERP platform, compile and analyze data, monitor the coding and recording. Prepare and input correcting journal entries resulting from in depth ERP analysis of accounting information. Partner with Payroll specialists to facilitate payroll corrections as needed.
Create and manage ERP report tracking documentation (i.e. spreadsheets) to assist in the monitoring, reporting, and recording of accounting activities.
Prepare monthly reports and presentations as needed or requested for district administration, Superintendent’s Cabinet, and Board of Education.
Maintain ERP accounting system databases, tables, and programs.
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.
Perform other duties as assigned or requested.
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.
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.
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.
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.
Perform monthly reconciliation on grant accounts, ensuring all transactions are posted to the general ledger.
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.
Perform system development tests for ERP system patches and upgrades. Create and monitor ERP system case support tickets.
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.
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.
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 and compliance with debt requirements and Board policies.
Determine the value of capital asset additions, disposals, and adjustments, and record them in accordance with Generally Accepted Accounting Principles (GAAP).
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.
Provides professional consulting, training, advising, directing, and mentoring services to district personnel related to capital/operating projects, fixed assets and debt related to such projects and/assets.
Prepare monthly, quarterly and annual capital asset reports and end-of-year capital asset financial audit schedules. 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.
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.
Maintain ERP accounting system databases, tables, and programs. Test the ERP system patches and upgrades in relation to FA (Fixed Assets), PPM (Project Portfolio 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.
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.
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.
Assist district personnel with maintenance of physical inventory and tracking of assets.
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.
Provide professional consulting, training, advising, directing, and mentoring services to district personnel related to capital/operating projects and fixed assets.
Prepare annual capital asset reports and end-of-year capital asset financial audit schedules.