Financial Analyst 3

Position Focus :

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.

Essential Duties

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.

Required Education and Experience

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.

Required Skill / Ability 1 :

Demonstrated high level analytical skills and experience with analyzing large volume of financial information.

Required Skill / Ability 2 :

Proficient in Microsoft Excel and ability to effectively translate and share financial information independently.

Required Skill / Ability 3 :

Demonstrated knowledge of financial management, internal controls, risk, and financial systems.

Required Skill / Ability 4 :

Excellent written and verbal communication skills, and ability to adapt communication style to address the needs of the department.

Preferred Education, Experience and Skills :

Prior experience with grant and contract accounting as well as cash receipt application. Working knowledge of Yale’s financial system (Workday) and Power BI.

Drug Screen

Health Screening

Background Check Requirements

All candidates for employment will be subject to pre-employment background screening for this position, which may include motor vehicle, DOT certification, drug testing and credit checks based on the position description and job requirements.

All offers are contingent upon the successful completion of the background check. For additional information on the background check requirements and process visit "Learn about background checks" under the Applicant Support Resources section of Careers on the It's Your Yale website.

COVID-19 Vaccine Requirement

The University maintains policies pertaining to COVID-19. All faculty, staff, students, and trainees are required to comply with these policies, which may be found here :

Posting Disclaimer

The intent of this job description is to provide a representative summary of the essential functions that will be required of the position and should not be construed as a declaration of specific duties and responsibilities of the particular position.

Employees will be assigned specific job-related duties through their hiring departments.