Logo
Mapleton Public Schools

Grant Accountant

Mapleton Public Schools, Denver, CO


Position Type:
Professional/Administrative/Accountant

Date Posted:
8/5/2024

Location:
Finance Department

Closing Date:
08/12/2024AN EQUAL OPPORTUNITY EMPLOYER
Mapleton Public Schools, Adams County District #1 does not unlawfully discriminate on the basis of race, color, creed, sex, sexual orientation, religion, national origin, ancestry, age, genetic information, marital status, or disability in admission or access to, or treatment or employment in, its educational programs or activities. Inquiries may be referred to the Deputy Superintendent of Human Resources, 7350 Broadway, Denver, CO 80221. ([redacted], or the US Dept. of Education, Office for Civil Rights, 1961 Stout Street, Denver, CO 80204.

CLASSIFIED VACANCY

POSITION: Grant Accountant
LOCATION: Business Services
PAY RANGE: EO-5 Range, $71,061.74 - $105,047.04
CALENDAR: 260 Days, 8 hours a day
FLSA STATUS: Exempt
REPORTS TO: Director of Business Services

SCHOOL DESIGN OVERVIEW:
Rigor, relevance, relationships, and choice make Mapleton Public Schools a destination district for both families and staff. In 2006, Mapleton challenged the traditional delivery of education by introducing schools that are small-by-design. Standards-based instruction is offered through the lens of engaging education models, including EL, International Baccalaureate, Big Picture, STEM, Performing and Visual Arts, Project-based Learning, Young Adult, and online.

In Mapleton's full-choice system, families select their school based on how their child likes to learn, not where they live. Mapleton serves more than 6,700 students - from toddlers to young adults - in unincorporated Adams County, Thornton, and north Denver. With an unyielding commitment to academic success and personal growth, Mapleton is committed to raising expectations by removing obstacles to learning and supporting all students in achieving their dreams.

According to a recent community survey, parents/guardians are proud that their children attend Mapleton Public Schools and believe Mapleton schools are full of highly skilled and compassionate staff. Students view the quality of their education as favorable, and most students say they enjoy coming to school.

For more information about Mapleton Public Schools please visit our website.

WORK LIFE AND BENEFITS:
In Mapleton, we believe you deserve every opportunity to maximize your unique potential. We offer a comprehensive benefits package focused on choice, quality, and value. To learn more about any one of the benefits and advantages of being a part of the Mapleton family, please visit our Benefits page.

SUMMARY:
Performs administrative and technical activities related to federal, state, and local grants within the district, ensuring compliance with regulations and guidelines. Responsible for completing all accounting related to grants provided to the school district. Analyzes grant related internal controls implementing control procedures to ensure compliance with all grant requirements. Responds to internal and external customer inquiries regarding new and existing grants. Monitors grant budgets and assists the Finance Director throughout the grant cycle providing guidance to instructional staff to most effectively manage grant funds. Provides consultation on writing new grants, including assisting with preparation of grant budgets based on information provided. Provides the CFO with a financial forecast of all grants. Develops, maintains, and reconciles the annual (COFR) from the Colorado Department of Education to district records. Supports in the preparation of the Annual Comprehensive Financial Report (ACFR) and the Schedule of Expenditures of Federal Awards (SEFA).

ESSENTIAL DUTIES AND RESPONSIBILITIES:
  1. Monitor and maintain district grants to ensure compliance with federal, state, and local regulations and guidelines by reviewing grant applications, designing and documenting District grant related internal control procedures, developing account codes, developing and maintaining budgets, charging indirect costs, establishing year-end accruals, and preparing financial reports for Colorado Department of Education (CDE) and Annual Comprehensive Financial Report (ACFR) ,and ensuring that assigned grants/funds do not exceed the allotted budgets and grant funds are used effectively.
  1. Provide information and direction to and from administrators by the preparation of financial reports including but not limited to monthly grant budget vs actual reports, grant specific expenditures reports, cash flow, etc. to ensure all grant funds are expended appropriately and timely. Coordinates the flow of information to building sites and other external entities.
  1. Primary liaison/resource between the district and funding agencies for all fiscal grant issues including independent decision-making responsibilities. Reviews internal controls for revenues, expenditures, journal entries of grants and other funds/programs. Trains district staff concerning grants, compliance requirements, related internal controls and generally accepted accounting principles.
  1. Develop and coordinate with Executive Directors, School Directors, Grant Coordinators, and recipients in preparing and projecting grant budgets. Prepares monthly Grants monitoring reports to assist the CFO and Finance Director with providing grant information for Executive Review. Creates and maintains spreadsheets to report and project expenditures and to forecast ending balances on a monthly basis.
  1. Prepare and submit requests for funds to maintain cash flow, record and reconcile grant accounts receivable as grant draw requests are made, account for matching funds, and receive revenue into appropriate grants. Creates monthly, quarterly, and annual financial reports required by the state and federal governments including budgets for grant applications and end-of-year financial reports.
  1. Contact fiscal and program personnel in state and federal offices and responds to requests for clarification of grant information. Monitors updates from the Office of Management and Budget of the annual compliance supplement for each federal grant. Maintains current knowledge of Generally Accepted Accounting Principles (GAAP), Governmental Accounting Standards Board (GASB) statements and grant fiscal accounting best practices including Education Department General Administrative Regulations (EDGAR) and Uniform Grant Guidance by attending workshops and conferences or using online sources.
  1. Assist in the preparation of various statements, schedules, and reports as needed for the completion of the ACFR and SEFA. Serves as the primary contract for auditors related to the audit of the District's grants. Provides auditors with requested documentation, analysis and clarification for annual single audits.
  1. Perform other duties as assigned.

EDUCATION AND TRAINING:
Bachelor's degree with major coursework in accounting or finance.

EXPERIENCE:
At least 2 years' experience with governmental accounting, school district accounting, budgeting, and analysis strongly preferred.

TECHNICAL SKILLS, KNOWLEDGE, & ABILITIES:
  • Extensive experience and mastery of Excel functions including pivot tables.
  • CPA or CPFO certification preferred.
  • Oral and written communication and interpersonal skills
  • Time management and problem-solving skills.
  • Customer service and public relations skills.
  • English language skills.
  • Advanced accounting and bookkeeping skills.
  • Critical thinking and problem-solving skills.
  • Personal computer and keyboarding skills.
  • Strong knowledge of Generally Accepted Accounting Principles (GAAP), journal entries, double-entry bookkeeping, tax laws, and regulations.
  • Ability to maintain confidentiality in all aspects of the job.
  • Ability to manage multiple tasks with frequent interruptions, use time efficiently, demonstrate attention to detail, follow instructions, and respond to management direction.
  • Ability to work with students with diverse backgrounds and abilities.
  • Ability to promote and follow Board of Education policies, Superintendent policies, and building and department procedures.
  • Ability to communicate, interact, and work effectively and cooperatively with all people including those from diverse ethnic and educational backgrounds.
  • Ability to recognize the importance of safety in the workplace, follow safety rules, practice safe work habits, utilize appropriate safety equipment, and report unsafe conditions to the appropriate administrator.

MATERIALS AND EQUIPMENT OPERATING KNOWLEDGE:
  • Operating knowledge of and experience with personal computers, peripherals, and office software.
  • Advanced operating knowledge of and skill with Microsoft Excel.
  • Operating knowledge of Weidenhammer Alio computer software preferred.
  • Operating knowledge of and experience with typical office equipment, such as telephones, copier, fax machine, E-mail, etc.

CERTIFICATES, LICENSES, & REGISTRATIONS:
Criminal background check required for hire

SUPERVISORY/TECHNICAL RESPONSIBILITY:
This job has no supervisory responsibilities.

PHYSICAL REQUIREMENTS & WORKING CONDITIONS:

The physical demands, work environment factors and mental functions described below are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

PHYSICAL DEMANDS:
While performing the duties of this job, the employee is regularly required to use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee frequently is required to walk and sit. The employee is occasionally required to stoop, kneel, crouch or crawl. The employee must regularly lift and/or move up to 10 pounds and frequently lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision and ability to adjust focus.

WORK ENVIRONMENT:
The noise level in the work environment is usually quiet.

MENTAL FUNCTIONS:
While performing the duties of this job, the employee is regularly required to analyze, communicate, compute, and use interpersonal skills. Frequently required to compare, copy, coordinate, synthesize, evaluate, and compile. Occasionally required to instruct and negotiate.

EVALUATION:
Performance of this job will be evaluated in accordance with the District Classified Performance Evaluation process as indicated in the Classified handbook.

METHOD OF APPLICATION:
  • External applicants must complete a career application online through Frontline Recruiting & Hiring.
  • Current Mapleton employees should create an account and submit their interest as an internal candidate through Frontline Recruiting & Hiring.

SMOKING IS NOT PERMITTED IN SCHOOL DISTRICT BUILDINGS OR ON SCHOOL GROUNDS