Financial Analyst

Case Western Reserve University Cleveland, OH

The financial analyst functions in a professional capacity for Case Western Reserve University in the Office of Research Administration (ORA) and reports directly to the Manager, Cash Management. The principal objective of the position is maintaining effective and efficient cash management of the university's sponsored projects. General responsibilities include: 1) prepare the Letter of Credit (LOC) cash drawdowns of federal funds, 2) manage sponsored projects accounts receivable, 3) coordinate payments received on sponsored projects, 4) perform sponsored projects collection activities, and 5) prepare reports and reconciliations for management. The financial analyst has the knowledge, skills, and abilities to independently analyze problems, and devise and implement solutions in accordance with university policies and procedures.


* Coordinate and execute various LOC processes. The federal LOC cash drawdown process. Determine the dollar amount that the university should request to reimburse sponsored projects that are funded via LOC by utilizing reports generated from PeopleSoft and other approved department methodology. Obtain approval from Assistant Vice President, Sponsored Projects and Manager, Cash Management regarding draw amount and oversee the Accounting Clerk to draw the approved amount from sponsor system. Compare the sponsor authorization amount to CWRU budget records to determine if the approved draw is within the authorization limits. Document the sponsor authorization amount for each draw. Coordinate posting of LOC revenue with the Treasurer's Office. Reconcile posted deposits to general ledger to actual draw amounts to approved draw amounts. Provide reconciliation to Associate Director, Sponsored Projects Accounting for review. Maintain detailed records of LOC draws, supporting documentation and approvals. 30%

* Reconcile accounts receivable sub ledger with the general ledger in PeopleSoft. Identify reconciling items and prepare adjusting entries as needed (entries subject to the review and approval of the Associate Director, Sponsored Projects Accounting). 20%

* Post, monitor and track electronic funds transfers (EFT) and checks to the appropriate account in PeopleSoft. For unidentified payments received, identify the purpose and determine the appropriate sponsored project for the revenue or to the unapplied cash account (send to appropriate departments that are not associated with a sponsored project). Record deposits into PeopleSoft and ORA deposit log, coordinate deposit of checks with courier and reconcile documentation from the Cashier's Office to ORA's deposit log. Identify problems and communicate with the departments and post-award leadership when there is a question on the project's status. 25%

* Update collections database which includes the addition of new and closed collection items, recording communications with sponsors/principal investigators and/or administrative staff. Compose and send dunning (past due) letters to sponsors in coordination with an accounting clerk.

Communicate the status of collections with: sponsoring agencies, director/associate directors, grant accountants, General Counsel Office, and principal investigators/administrative staff. 15%

* Prepare various accounts receivable and collection reports for management review. 10%


Perform other duties as assigned.


Department: Daily contact with Assistant Vice President, Sponsored Projects, Manager, Cash Management and other staff within the department.

University: Weekly contact with management center representatives, department administrators and faculty. Occasional contact with audit services and the Office of General Counsel.

External: Weekly contact with federal and non-federal sponsor agencies and peers at other universities and research institutions. Annual contact with audit agencies.

Students: Occasional contact with work-study students.


No supervisory responsibility.


Education/Experience: High School Diploma and 5 years of experience in sponsored projects administration, cash management and/or audit; OR Bachelor's degree and 2 years of experience in sponsored projects administration, cash management and/or audit required. Professional designation (e.g. CPA or CRA) preferred.


* Foundational knowledge of sponsored program administration, policies, OMB Circular A-21, A-110, federal and sponsor regulations, and guidelines.

* Knowledge of and familiarity with internal controls over accounting, financial reporting and research activities.

* Foundational knowledge of A-133 and financial audit requirements and audit reporting.

* Foundational knowledge of governmental accounting and budgeting, accounting principles and practices.

* Knowledge of PeopleSoft grants management and accounting modules preferred.

* Proficient knowledge and practical abilities working with the Microsoft Office suite of tools, including advanced Excel skills.

* Foundational analytical skills to analyze accounting data, formulate and present conclusions.

* Foundational analytical skills to analyze a variety of complex regulations, apply sound judgment, and draw logical conclusions.

* Foundational organizational skills with attention to details and accuracy.

* Strong written and verbal communication skills.

* Ability to adhere to departmental and university policies.

* Ability to make ethical decisions and act with integrity.

* Ability to interact and communicate professionally with others and to establish meaningful relationships with deans, faculty, administrators, and sponsors.

* Ability to produce accurate and timely work products when working under pressure.

* Ability to maintain confidentiality and exercise appropriate discretion with information.

* Highly motivated with a strong service orientation.

* Ability to work as part of a team of professionals.

* Ability to meet consistent attendance.

* Ability to interact with colleagues, supervisors, and customers face to face.


General office working environment.

Diversity Statement

In employment, as in education, Case Western Reserve University is committed to Equal Opportunity and Diversity. Women, veterans, members of underrepresented minority groups, and individuals with disabilities are encouraged to apply.

Reasonable Accommodations

Case Western Reserve University provides reasonable accommodations to applicants with disabilities. Applicants requiring a reasonable accommodation for any part of the application and hiring process should contact the Office of Inclusion, Diversity and Equal Opportunity at 216-368-8877 to request a reasonable accommodation. Determinations as to granting reasonable accommodations for any applicant will be made on a case-by-case basis.


Similar jobs you might like

Sr. Financial Analyst - Bendix
Bendix Commercial Vehicle Systems LLC, Elyria, OH
IT Financial Analyst
AmTrust Financial Services, Inc. Cleveland, OH