Financial Analysis and Reporting Analyst

The Financial Reporting Analyst supports the Business Office and LAFS by providing timely financial reporting for the school. The role includes month end reporting, and budget and forecast preparation, so that management can make timely and informed financial decisions.

Essential Duties and Responsibilities:

(Those that must be performed with or without an ADA Accommodation)
Financial Reporting

• Prepare monthly financial statement reporting package utilizing advanced excel macros.
• Compile, prepare and distribute monthly statistical reports including KPI metrics, trends, analytics, sales conversion rate, headcount analysis and program margin analysis.
• Assist in the year-end financial audit and insurance and regulatory compliance reporting.
• Review and approve bi-weekly payroll entries for accuracy and completeness.

Budget and Forecast

• Assist in the preparation of the annual budget and monthly updates of the forecast.
• Maintain operating budgets, track, investigate and report on variances of actual expense to budget.
• Distribute quarterly financial operating reports to department heads.
• Assist in the preparation of the monthly cash and balance sheet forecast, CAPEX and marketing analytics.
• Prepare the detailed payroll budget and ongoing payroll forecast updates.
• Monitor open positions, terminations and headcount activity as it relates to forecast and required ratios.
• Review of monthly, quarterly and year end reports including headcount, W2 reconciliations and validation, and year end payroll reconciliations for audit.

Other

• Supporting role in audits, insurance and regulatory compliance reporting.
• Perform these responsibilities with collaboration and the highest professional standards consistent with the vision, mission and strategy of the Los Angeles Film School.

Non
- Essential Duties and Responsibilities:

(Those that must be performed with or without an ADA Accommodation) –

• Assist in ad-hoc or special projects as required.

Other Responsibilities:

(Those that must be performed with or without an ADA Accommodation)

• Contribute to, recommend and implement best practices in reporting and analysis, streamline and automate workflow and identify opportunities for improvement.

Competencies/Knowledge/Skills/Abilities: (Those that must be performed with or without an ADA Accommodation)

• Positive attitude and a desire to help others
• Accounting knowledge including GAAP
• Proficient in advanced Excel with the ability to program and maintain pivot tables (works with large amounts of data.) — High degree of computer literacy
• Clear, concise effective communication (both written and verbal) – cross- departmental collaboration with multiple stakeholders.
• Ability to work independently in a fast-paced environment.
• Ability to pivot and assist in department where needed.
• Detail-oriented, attention to details and ability to prioritize projects.
• Effective customer service skills inter-department and cross-departmental
• Effective organizational skills and strong attention to detail
• Maintain a high degree of confidentiality in the management of information.

Job Requirements

• Bachelor’s degree in accounting or finance required.
• Minimum of 5-8 years in financial reporting, budget and analysis, financial reporting software and data automation.
• Experience in the Education sector preferred.
• CPA preferred.

Computer

Skills:

are those that are required and performed with or without an accommodation

• Highly proficient computer skills including advanced Excel skills (Pivot, VLOOKUP, etc.) and the ability to program in excel.
• Proficient with standard office applications (Microsoft Office Suite, Google Drive, SharePoint)
• Great Plains or other mainframe accounting system preferred.

Environmental Factors are those that are required and performed with or without an accommodation:

• Frequent use of computer screens
• Fluorescent lighting
• General office environment and office equipment
• Physical Demands are those that are required and performed with or without an accommodation.
• The ability to lift and carry equipment up to twenty-five pounds
• Ability to bend, stand, sit, and reach
• Use of keyboards
• Effectively operate general office equipment such as a computer, scanner and other LAFS office equipment

Emo…