Grants & Projects Accounting Specialist

Job Title : Financial Services Accountant FLSA Exemption Status : Exempt Classification Group : Professional Technical Supervising Position : Controller or designee Pay Plan : Professional Technical Pay Range : Range 04 Last Updated : 11/14/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, 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. 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 Across Assignments Frequency Percentage of Time 1. 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. Daily 10% 2. Create and manage ERP report tracking documentation (i.e. spreadsheets) to assist in the monitoring, reporting, and recording of accounting activities. Weekly 5% 3. Prepare monthly reports and presentations as needed or requested for district administration, Superintendent’s Cabinet, and Board of Education. Monthly 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% Grant Funding Assignment Job Task Descriptions 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. 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% 4. 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% 5. Perform monthly reconciliation on grant accounts, ensuring all transactions are posted to the general ledger. Monthly 10% 6. 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% 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% Projects and Bond Assignment Job Task Descriptions 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 and compliance with debt requirements and Board policies. 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. 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. Daily 5% 5. 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. Monthly 5% 6. 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% 7. 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. Monthly 5% 8. 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. 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% 10. Assist district personnel with maintenance of physical inventory and tracking of assets. Quarterly 5% TOTAL 65% Projects and Fixed Assets Assignment Job Task Descriptions 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. Provides professional consulting, training, advising, directing, and mentoring services to district personnel related to capital/operating projects and fixed assets. Daily 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. 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. 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% 8. 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% 9. Assist district personnel with maintenance of physical inventory and tracking of assets. Quarterly 5% 10. Prepare annual capital asset reports and end-of-year capital asset financial audit schedules. Annually 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 #J-18808-Ljbffr