Description

POSITION OBJECTIVE 

Functioning as a contributing member of the finance team, the Senior Financial Analyst will contribute to the comprehensive budgeting and forecasting for all departments in the School of Medicine. The senior financial analyst will manage all monthly reporting and ensure the proper recording of financial transactions relating to grants, projects, and endowments in conjunction with external (NIH, etc.) and internal policies for the School of Medicine clinical and bridge science departments and centers. In addition, the senior financial analyst will be involved in more advanced day-to-day functions of the Finance and Planning Office. The senior financial analyst may play a role in supporting the finance director in the School of Medicine's initiative of business process re-engineering and improved reporting/data analytics via Robotic Process Automation (RPA).

ESSENTIAL FUNCTIONS 

Responsible for management and monitoring of annual operating budgets for a select group of academic and administrative departments representing over $28M in annual expenses. Serve as a resource to the departments on budgeting and forecasting matters. Prepare monthly expense projection/ forecast models for departments. Develop expertise in the operations of the basic science departments and coordinate coverage in the temporary loss of the department administrator. Responsibility for managing month-end reporting including database updates, commitment database maintenance, monthly END reporting, cross training for other month END responsibilities, monthly Projections report (backup), school level SmartView (PBCS) reporting and analysis, and development and updating of newly introduced R&T templates. Responsible for compilation of base and finalization of final IFM schedules (in coordination with dept administrators), DA funding/IDC return analysis, compilation of Basic Sciences final budget binders for Budget meeting ¿ IFM, END reporting, R&T reporting, 10-year grants rending, faculty profile reporting, helped set agendas and scheduled binder review. Manage entry and validation/reconciliation of all information in PBCS for clinical and bridge sciences and assigned administrative department budget materials. (20%)
Lead monthly financial review meetings with assigned departments. Review financial portfolios (grants and funded projects, operating accounts, faculty startup packages, and endowments) across the School of Medicine and identify trends and variances that will be useful to department leadership/management. Monitor finances for administrative departments and update monthly reports for each of the departments. Develop quarterly (and ongoing) forecasts for departments; research variances to budgets, communicate issues and concerns to the assistant dean in a timely manner. Monitor departments to ensure that budgets are achievable. Make recommendations to adjust forecasts as required.  (20%)
Conduct salary analysis. Review and approve faculty salary changes, process and deliver appropriate documents to relevant parties, and maintain organized records of the changes. Verify funding for salaries. Follow up with the departments if questions arise. For human resource requests, approve renewal of academic positions and replacements for faculty positions. identify positions that may require future commitments other than salary and verify that these commitments are in the forecast model. Perform Exhibit A review for personal data and salary authorization (Personnel Data) form review to ensure they are accurate, appropriate and comply with policy, including increase pool and budget guidelines are followed which may require compiling benchmarking data for equity and promotion salary adjustments. Assist with templates, compilation and review of department submitted materials (and related updates) as part of annual faculty salary recommendation process. Conduct ad hoc salary reporting at request of dept, admin departments, finance office. Create individual salary history timelines and explanations of changes/processes. Provide backup to scrub data and manage FIS salary records, cross referencing with HCM records, maintain constant communication with affected departments and central HR Records to ensure changes are made in a timely manner, are accurate, address any question/concerns from them and ensuring alignment with University Hospital (UH) Exhibit A process for UH Dual paid faculty and other non-dual paid faculty salary changes. (10%)
Manage tuition return processes including for Masters and PhD programs. Pull and manipulate data out of the system; correspond with departments on student and tuition data to ensure alignment. Track and compile data for final tuition return calculation and files. Provide analysis and assessment of data and provide recommendations for final departmental tuition return calculation and files.  (10%)
Manage annual space invoicing process, including working with Space & Facilities on verifying space inventory across SOM and shared spaces with UH, calculating appropriate amounts to be charged in affiliate invoicing process. (10%)
 

NONESSENTIAL FUNCTIONS 

Conduct financial analysis of large datasets to support the re-engineering and development of new reports and analysis using enterprise-reporting tools such as Tableau and Oracle Planning Budget Cloud Services (PBCS). Aid the finance director in the re-engineering of the current forecast process to improve accuracy and identify budget to actual variances. (5%)
Responsibility to review transactions and financial activity of medical school departments including postdoc requisition requests, staff HR requisitions, faculty payroll changes and financial purchase requisitions. Support and assist with maintenance of school user access to mission critical systems like PeopleSoft Financials, Human Capital Management (HCM), Oracle Planning Budget Cloud Services (PBCS), and other university internal systems. (5%)
Manage database records for faculty commitments and identify potential future upgrades/ improvements. Work closely with Faculty Affairs to process promotions, Board of Trustees approvals, full-time equivalent (FTE) changes, title/appointment changes etc. Work with Faculty Affairs to determine eligible faculty, creating/updating/maintaining recommendation file template. Compile master data, split data by dept and distribute and track/log dept recommendations which is changing constantly throughout process. Communicate recommended changed to departments and update the Master file and individual department salary files. (5%)
Manage affiliate invoicing process for MetroHealth system including several hundred indirect cost invoices and salary invoices. Assist with affiliate Cleveland Clinic Lerner College of Medicine tuition invoicing and PhD student tuition and fee invoicing processes to validate and verify data. Create PhD student tuition and fee invoices. Assist with UH Crossbill invoicing process including validating data. (5%)
Perform other duties as assigned. (5%)
 

CONTACTS 

Department: Contact with finance director, assistant dean for finance and planning, assistant dean for administrative operations, assistant dean of space & facilities, finance and planning staff, business managers/administrators, vice deans and associate deans.

University: Contact with the Controller's Office, Office of Research Administration, central Budget and Planning Office and University Technology.

External: Contact with software vendors, affiliated hospitals, practice plan administrators, and peers from other institutions.

Students: Contact with student interns.

SUPERVISORY RESPONSIBILITIES

No direct supervisory responsibility.

QUALIFICATIONS

Experience: 4 or more years of progressive experience in a related field required; experience in an academic and/or medical center environment preferred; experience with fund accounting desired; project management experience preferred.

Education: Bachelor's degree in finance or related field required.

REQUIRED SKILLS

Knowledge of financial management, analysis, budgeting, and reporting skills.
Effective communicator. Ability to work independently and as part of a team.
Excellent organizational skills. Detailed oriented.
High degree of professionalism and discretion.
Proven solid decision making skills. Sound analytical reasoning.
Self starter. Customer service oriented.
Ability to meet consistent attendance.
Ability to interact with colleagues, supervisors, and customers face to face.
Working knowledge of Microsoft Office programs with advanced skills in Excel. Familiarity with ERP system value flows (Peoplesoft) including queries is a plus. Knowledge and familiarity of database design and prior experiences with SQL coding is preferred.
Demonstrated history of successful support, education, and advocacy for all students, aligned with the values, mission, and messaging of the university, while adhering to the staff policy on conflict of commitment and interest.
Ability to meet consistent attendance.
Ability to interact with colleagues, supervisors, and customers face to face.
Willingness to learn and work with artificial intelligence (AI) tools and technologies.
 

WORKING CONDITIONS

General office environment.