Oklahoma City Public Schools
Financial Accounting and Reporting Analyst
Oklahoma City Public Schools, Oklahoma City, Oklahoma, United States, 73116
Financial Accounting and Reporting Analyst
Join to apply for the
Financial Accounting and Reporting Analyst
role at
Oklahoma City Public Schools
Reports To:
Director of Financial Accounting and Reporting
FSLA Status:
Exempt
Compensation:
806
Work Days:
242
FTE:
100
Position Summary:
The Financial Accounting and Reporting Analyst reports to the Director of Financial Accounting and Reporting and is responsible for:
Assisting with the development and monitoring of the District's financial accounting and reporting in compliance with Government Accounting Standards Board (GASB), Generally Accepted Accounting Policy (GAAP), board policy, as well as local, state, and federal laws.
Working with all applicable District departments to maintain accuracy and proper controls in the administration of bond funds in compliance with all applicable standards and laws, including producing and maintaining required weekly, monthly and annual reports.
Essential Duties:
Process and compile financial activity ensuring completeness, accuracy, timeliness and compliance with applicable guidelines.
Analyzes, monitors and makes changes/updates/corrections to specific project or department expenditure and revenue reports.
Completes financial analysis and special projects as requested, including testing of data and completeness of information.
Assists in developing and presenting 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.
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.
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 and reviews applicable Bond weekly/monthly/yearly reports.
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 positive relationships with external and internal customers and other departments. For the safety and convenience of all customers, provides 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).
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:
Bachelor’s degree in accounting, finance, or related field.
Knowledge of GAAP (generally accepted accounting principles).
Strong experience with Microsoft Office Suite (Word, Outlook, Excel, 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. Ability to work with minimum supervision.
Ability to train and mentor other staff.
Excellent decision making and analytical skills.
Preferred Qualifications:
Certified Public Accountant (CPA) or five (5) years of accounting experience.
Data analytics skills including advanced Excel knowledge (formulas, VLOOKUPs, pivot tables, VBA, etc.)
Prior accounting or audit experience.
Oracle software or other general ledger/accounting 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.
Working Conditions and Physical Requirements:
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.
May periodically require work outside of normal business hours, including weekends, under sometimes stressful conditions in order to meet business needs and strict deadlines.
Additional Information:
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.
Senior Level:
Mid‑Senior level
Employment Type:
Contract
Job Function:
Accounting/Auditing and Finance
Industry:
Education Administration Programs
#J-18808-Ljbffr
Financial Accounting and Reporting Analyst
role at
Oklahoma City Public Schools
Reports To:
Director of Financial Accounting and Reporting
FSLA Status:
Exempt
Compensation:
806
Work Days:
242
FTE:
100
Position Summary:
The Financial Accounting and Reporting Analyst reports to the Director of Financial Accounting and Reporting and is responsible for:
Assisting with the development and monitoring of the District's financial accounting and reporting in compliance with Government Accounting Standards Board (GASB), Generally Accepted Accounting Policy (GAAP), board policy, as well as local, state, and federal laws.
Working with all applicable District departments to maintain accuracy and proper controls in the administration of bond funds in compliance with all applicable standards and laws, including producing and maintaining required weekly, monthly and annual reports.
Essential Duties:
Process and compile financial activity ensuring completeness, accuracy, timeliness and compliance with applicable guidelines.
Analyzes, monitors and makes changes/updates/corrections to specific project or department expenditure and revenue reports.
Completes financial analysis and special projects as requested, including testing of data and completeness of information.
Assists in developing and presenting 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.
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.
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 and reviews applicable Bond weekly/monthly/yearly reports.
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 positive relationships with external and internal customers and other departments. For the safety and convenience of all customers, provides 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).
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:
Bachelor’s degree in accounting, finance, or related field.
Knowledge of GAAP (generally accepted accounting principles).
Strong experience with Microsoft Office Suite (Word, Outlook, Excel, 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. Ability to work with minimum supervision.
Ability to train and mentor other staff.
Excellent decision making and analytical skills.
Preferred Qualifications:
Certified Public Accountant (CPA) or five (5) years of accounting experience.
Data analytics skills including advanced Excel knowledge (formulas, VLOOKUPs, pivot tables, VBA, etc.)
Prior accounting or audit experience.
Oracle software or other general ledger/accounting 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.
Working Conditions and Physical Requirements:
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.
May periodically require work outside of normal business hours, including weekends, under sometimes stressful conditions in order to meet business needs and strict deadlines.
Additional Information:
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.
Senior Level:
Mid‑Senior level
Employment Type:
Contract
Job Function:
Accounting/Auditing and Finance
Industry:
Education Administration Programs
#J-18808-Ljbffr