2021-2022 Analyst Senior - Federal Programs 50013203
Reports To: Director of Budget
FSLA Status: Exempt
Work Days 242
FTE: 8 hours per day
Analyst Senior – Federal Programs
Position Summary: The Analyst Senior - Federal Programs reports to the Budget Manager and is responsible for:
Administering and tracking the CARES/ESSER/ARP federal programs including applications, budgeting, spending, claims, resolving discrepancies, accounting for receivables, etc.
Working with all District Administrators on CARES/ESSER/ARP allocations for instruction, professional development, supplies, etc.
The Analyst Senior – Federal Programs will review all CARES/ESSER/ARP related federal program activity and claims and assists with reporting to ensure completeness, accuracy, timeliness and compliance with applicable program restrictions. This position will also assist in updates for all State Department of Education validation rules in the SAP Financial system and ensuring compliance with board policy, federal and state law, and GAAP.
Process and compile financial activity ensuring compliance, accuracy, timeliness and completeness with applicable Federal program guidelines.
Assists with OCAS coding for all expenditures including requisitions, stipends, and extra-duty assignments.
Analyzes, monitors and makes changes/updates/corrections to Federal program expenditures and revenue reports and claims.
Performs and reviews monthly audits on budget and expenditures for internal departments, State and Federal programs. Maintains permanent files by project.
Prepares and reviews grant (Federal) claims and reporting for all assigned programs.
Assists with organizational management position changes, additions, and deletions.
Prepares Federal program budgets and completes year-end financial analysis on Federal projects, ensuring completeness and accuracy of data.
Serves as project leader on special projects.
Develops and presents training related to department specific functions to all applicable district personnel.
Understands department/desktop manuals, department webpage, and training materials and provides feedback for improvements and corrections.
Remains current through self study or sponsored professional development, keeping informed of business and financial laws, policies, and regulations affecting the business affairs of the District and monitors for adherence and compliance.
Shares responsibilities of other members of the department/division during peak periods or when there is an overload of duties, or fill in when an individual is away from the work station. Cross trains with co-workers to serve as department back up.
Performs SAP system testing for mandated/requested configuration maintenance and updates.
Identifies and recommends improvements to policies, regulations, and procedures to achieve maximum accuracy, efficiency and internal control.
Provides training and leadership to other department staff.
Supports the department's activities of the annual financial audit.
Assists with documentation, maintenance and completion of closing processes (monthly, quarterly or annually) to ensure accurate financial reporting in accordance with GAAP.
Prepares balance sheet reconciliations documenting identified variances and resolutions, escalating unforeseen variances as appropriate.
Prepares department monthly/quarterly/yearly financial statements and reporting for internal and external use.
Responds and provides documentation and analytical information as requested by management, external auditors, internal investigation teams or when issues are identified for further review.
Understands department related policies, regulations, and procedures to achieve maximum accuracy, efficiency and internal control.
Maintains and develops customer service relationships with external and internal customers and other departments. For the safety and convenience of all customers, provides prompt and courteous virtual customer service and robust website resources for 24/7 access (when these options may not work, ensuring opportunities for in-person customer service as needed). Handles more complex accounting discrepancies and customer service calls.
Utilizes resources and technology to maximize efficiencies and savings.
Utilizes teamwork by working collaboratively with fellow employees and others to achieve identified goals and objectives.
Maintains confidentiality with all sensitive information.
Develops interpersonal relations by building productive rapport with employees at all levels within and outside the department. All employees are treated with fairness, dignity and respect.
Performs other duties as assigned.
Job Specifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required.
Minimum Qualifications (Knowledge, Skills and/or Abilities Required):
Bachelor’s Degree in Business Administration, Finance, and Accounting or related field required.
Three (3) years of related experience required.
Experience with Compliance issues, grant funded programs, accounting or finance services in an education environment preferred.
Advanced experience with Microsoft Office Suite (Word, Outlook, Excel, including - formulas, vlookups, pivot tables, etc.).
Demonstrate dependability by consistently working the set work schedule.
Excellent interpersonal and written/verbal communication skills, including emails, by phone, and in person.
Excellent time management skills with the ability to multi-task and prioritize to meet deadlines.
Strong attention to details and organizational skills.
Ability to identify, research and resolve discrepancies and problems.
Ability to collaborate and work in a team environment and independently.
Ability to train and mentor other staff.
Excellent decision making and analytical skills.
Preferred Qualifications (Knowledge, Skills and/or Abilities Preferred):
Prior budget experience.
SAP software or other general ledger/accounting/ERP software experience.
Public education or governmental (fund) accounting knowledge and/or experience.
Knowledge about School Finance and the organizational structure of the school District functions.
OCAS (Oklahoma Cost Accounting System) knowledge.
Knowledge of GAAP (generally accepted accounting principals).
*Relevant experience may be substituted for formal education at a 2:1 ratio. Therefore, for every 1 year of college lacking, 2 years of directly relevant experience may be substituted.
Working Conditions and Physical Requirements:
The working conditions and 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 accommodation may be made to enable individuals with disabilities to perform essential functions.
Able to sit and stand for extended periods of time.
Exhibit manual dexterity to enter data into a computer.
Able to see and read a computer screen and printed material with or without vision aids.
Hear and understand speech at normal levels, outdoors and on the telephone.
Speak in audible tones so that others may understand clearly.
Physical agility to bend, stoop, climb stairs, walk, reach and lift up to 25 pounds.
Duties are normally performed in an office environment.
The noise level in the work environment is usually moderate.
This job description is not intended to be all inclusive. The employee will also perform other reasonably related business duties as assigned by the supervisor or appropriate administrator. Oklahoma City Public Schools reserves the right to, update, revise or change job duties as the need prevails. This document is for communication only and not intended to imply a written or implied contract of employment. The Board of Education and Superintendent may approve alternatives to the listed qualifications.