Financial Analyst 3 (92332BR)

University Job TitleFinancial Analyst 3Bargaining UnitNone - Not included in the union (Yale Union Group)Time TypeFull timeDuration TypeRegularCompensation GradeAdministration & OperationsCompensation Grade ProfileManager; Program Leader (26)Wage RangesClick here to see our Wage RangesSearchable Job FamilyAccounting/ Financial, FinancialTotal # of hours to be worked:37.5Work WeekStandard (M-F equal number of hours per day)Work LocationCentral CampusWorksite Address150 Munson StreetNew Haven, CT 06511Work ModelHybridPosition FocusThe 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• 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 ExperienceBachelor’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 1Demonstrated high level analytical skills and experience with analyzing large volume of financial information.Required Skill/Ability 2Proficient in Microsoft Excel and ability to effectively translate and share financial information independently.Required Skill/Ability 3Demonstrated knowledge of financial management, internal controls, risk, and financial systems.Required Skill/Ability 4Excellent written and verbal communication skills, and ability to adapt communication style to address the needs of the department.Preferred Education, Experience And SkillsPrior experience with grant and contract accounting as well as cash receipt application. Working knowledge of Yale’s financial system (Workday) and Power BI.Drug ScreenNoHealth ScreeningNoBackground Check RequirementsAll 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.Health RequirementsCertain positions have associated health requirements based on specific job responsibilities. These may include vaccinations, tests, or examinations, as required by law, regulation, or university policy.Posting DisclaimerThe 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.EEO StatementUniversity policy is committed to affirmative action under law in employment of women, minority group members, individuals with disabilities, and protected veterans. Additionally, in accordance with Yale’s Policy Against Discrimination and Harassment, and as delineated by federal and Connecticut law, Yale does not discriminate in admissions, educational programs, or employment against any individual on account of that individual’s sex, sexual orientation, gender identity or expression, race, color, national or ethnic origin, religion, age, disability, status as a special disabled veteran, veteran of the Vietnam era or other covered veteran.Inquiries concerning Yale’s Policy Against Discrimination and Harassment may be referred to the Office of Institutional Equity and Accessibility (OIEA).NoteYale University is a tobacco-free campus