Pay Grade: 3550

Position Control: 5000

Department: Federal Programs

Accountable To:  Director of Federal Programs

FLSA Status: Exempt

FTE/Funding:  1.0 FTE ESSER III grant funds

Summary:  

To support the implementation of the District’s ESSER grant funds (Elementary & Secondary School Emergency Relief Fund). This position will develop and manage complex spreadsheets and databases; create comprehensive reports for forecasting, trending, and results analysis; prepare financial statements, budget and expense reports, and project completion reports; analyze grant expenditures and evaluate outcomes of grant funded activities.  In addition, this position will provide technical assistance and grant support to a variety of stakeholders.

Essential Functions:

• Budget Management
  • Manages the daily budget tasks for all ESSER grants
  • Weekly budget management, expenditure review and tracking of budget activities
  • Completes budget journal entries, uploads, and transfers
  • Utilizes complex electronic financial information from district systems and databases
  • Reviews and ensures data and other pertinent information is accurate
  • Assists in planning and budget forecasting
  • Manages/coordinates purchase orders with Academic Services classified support team
  • Tracks orders, closes out purchase orders, monitors all inventory
  • Reviews, tracks and submits invoices and receipts for payment
  • Monitors staff pay from grants and resolves payroll issues as needed
  • Coordinates stipends with Academic Services classified support team
  • Tracks stipend submissions from schools
• Grant Compliance/Project Oversight
  • Assists with grant program compliance requirements and audits including reporting, documentation and tracking
  • Submit grant revisions to ADE in coordination with Federal Programs Director
  • Provides technical assistance and grant support to school and district administration
  • Collaborates with Finance to review expenditures and grant activities
  • Evaluate outcomes of grant funded activities, based on established metrics, in coordination with the district and school leadership, assessment and evaluation team, and other pertinent departments
  • Maintain various databases for all related data tracking needs
  • Assist with preparation of reports and studies for the purpose of providing information to the Governing Board, Superintendent, and other stakeholders
  • Coordinates grant activities with a variety of district departments including Payroll, Purchasing, Finance, Human Resources, Transportation, Capital Projects, MIS, Nutrition Services, etc.
• Time & Effort Reporting for ESSER Funds
  • Assists with the district Time and Effort Reporting process
  • Analyzes employee data to facilitate the generation of certification documents
  • Serves as a point of contact for questions/troubleshooting with staff
  • Collects all Time and Effort forms and organize submissions for grant manager review
  • Coordinates with the internal auditor to ensure compliance with federal and district guidelines

• Private School Services in ESSER I
  • Budget planning and management as well as all procurement of goods and services (POs, invoice reconciliation, inventory tracking)
  • Provide budget support and technical assistance for ESSER I funding to 18 participating private schools, located throughout Maricopa County.

Knowledge & Experience:

• Experience and knowledge of school business management
• Experience and knowledge with grants management and USFR guidelines

• Effectively use a variety of computer programs to include, but not limited to: Excel and MUNIS accounting software, Power BI Reports, Microsoft Office applications, Google Suite and data collection.
• Complex databases, spreadsheets, financial systems
• General accounting and mathematic functions

• A motivated self-starter, learner and investigator
• Excellent communication and customer service

• Demonstrates the ability to analyze data and disseminate program effectiveness.
• Demonstrates strong organizational skills that are detail-oriented.
• Demonstrates the ability to work effectively with schools, departments and district leadership.
• Strong verbal and written communication skills.

Skills required, but not limited to, for this position include:

• Adhering to pertinent state and federal laws and guidelines;
• Understanding principles and techniques in program management and program evaluation;
• Conducting data analysis and problem solving to assess large amounts of information in order to make recommendations;
• Applying policies, procedures, rules and regulations established for the District;
• Handling confidentiality regarding sensitive issues;
• Analyzing data and compiling and presenting materials;
• Making independent decisions;
• Composing, writing and editing reports and other correspondence;
• Knowing local, state, and federal guidelines governing area of assignment;
• Creating and delivering presentations;
• Using various financial and other information systems;
• Using computer software related programs, including Microsoft Office applications;
• Engaging and encouraging communication skills while interacting with supervisors, staff, students, etc. to exchange information.

Physical Requirements:

The physical requirements described here 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.

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

Working Conditions:

The working environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.