Job Abstract

The Financial Analyst is responsible for providing financial information through analysis and reporting, under the direction of the Deputy Director of Sponsored Projects Financial Administration (SPFA). The Financial Analyst will provide seasoned, independent experience and assistance to the Deputy Director of SPFA in managing and reconciling the balance sheet accounts, and revenue and expenses. The Financial Analyst will identify risks and trends that enable SPFA or University leadership to make informed decisions.
This position is hybrid and requires a minimum of two days in the office.

Responsible for performing complex account reconciliation and producing financial and management reports for all sponsored awards on a monthly basis. Investigate and resolve any irregularities that are identified during the reconciliation process.

Co-Lead the monthly reconciliation and certification of all AR ledger accounts and ensure compliance with institutional procedures and in accordance with GAAP. Certifies the accounts by the internal deadline as defined by the Controller’s Office.

Independently ensures the accuracy of the financial position of all sponsored awards that are reported on the University’s financial report. Provides reports that can be relied on by
SPFA’s leadership, Controller’s office, and/or external auditors.

Identify the need for any journal entries during the reconciliation of the Accounts Receivable billed and unbilled receivables, unapplied cash, deferred revenue, allowance for doubtful accounts, and other accounts. Collaborate with the University Controller’s Office, General Accounting, and other internal offices as deemed necessary.

Provide subject matter expertise to various University central units as well as department business offices.

Reconcile cash receipt balances in the Workday financial system to identify discrepancies and initiate appropriate correcting action.

Prepare monthly unapplied cash aging report and reconcile it to the general ledger. Research unapplied sponsor payment and take appropriate actions to identify correct account for payment application. Incumbent will often work with the pre-award team and financial reporting team to trigger funding increases in both the pre-award system (IRES) and Workday.

Collaborate with Financial Reporting Accountants to resolve cash related issues and provide excellent customer service to faculty, staff, other internal departments, and external sponsors.

Perform semiannual funding review and reconciliation for awards funded in foreign currency.

Crosstrain in letter of credit management for all federal sponsors.

Participate in semiannual financial system upgrade testing and participate in the development and implementation of new financial systems and procedures.

Perform all projects and other assigned duties as necessary at the direction of the Deputy Director, SPFA.

Recommends improvements to systems, methods, practices, policies, and procedures through information review.
Excellent written and verbal communication skills, and ability to adapt communication style to address the needs of the department.
1. Financial modeling and forecasting: Provides specialized technical analysis to determine present and future financial performance. Organizes information from a variety of sources to establish data banks for use in analyzing and creating future plans and forecasts. Guides and collaborates with all levels of management, both internally and externally, to gather, analyze, summarize, prepare, and present recommendations regarding financial plans, trended future requirements, operating forecasts and/or similar complex financial matters. Researches and evaluates information to resolve issues and/or influence decisions. Conceptualizes, develops and executes multi-variable complex financial models. 2. Financial Analysis and Reporting: Analyzes and synthesizes information and designs and creates accurate and timely reports. Designs financial reporting to meet the compliance needs of internal and external users. Extracts and consolidates data from multiple sources. 3. Financial methods and systems: Influences, plans, and designs methods to improve practices, processes and systems. Leads and partners with all levels of internal and external contacts to execute departmental and/or institutional level goals. Provides a high level of service that cultivates and maintains strong working relationships and effectively communicates information; takes ownership and accountability for timeliness, accuracy and relationship management. 4. Strategic Resource: Translates department finance strategies into goals. Anticipates, identifies, and raises potential financial opportunities, issues, risks, ideas and solutions. Employs judgment and expertise in identifying the appropriate stakeholders to include in consultations, communications, approvals or buy-ins for designing and implementing changes. 5. Compliance and risk management: Establishes, implements and/or maintains strong internal controls in areas of assigned responsibility to provide reasonable assurance of effective and appropriate resources use, accurate financial information, and adherence to contractual obligations and agreements, policies, procedures, and external regulatory requirements. 6. Mentors, leads and/or supervises staff. 7. May perform other duties as assigned. Bachelor’s degree in Accounting, Business, Economics or Finance and six years of related experience or an equivalent combination of education and experience. Demonstrated application of financial, accounting and economic concepts.