Financial Analyst 2

Reporting to the Associate Director, Accounting and Compliance, this position is responsible for providing financial information through analysis, reconciliation and reporting for patient services billing (Epic) accounts receivable (AR) and for clinical trial revenues and associated accounts receivable along with preparing and analyzing YSM's financial statements. Identifies risks and trends that enable unit and/or University leadership to make informed decisions. Recommends improvements to systems, methods, practices, policies, and procedures through information review.

Responsible for verifying and correcting balance sheets, preparation of monthly financial statements, including multiple supporting reports requiring detailed variance analysis. Performs reconciliations; navigates through systems and reporting tools to independently resolve routine and non-routine discrepancies. Applies entries to the general ledger or subsystems and ensures adherence to Generally Accepted Accounting Principles (GAAP), where applicable, regulatory requirements, University policies and financial reporting considerations. Communicates effectively to unit leadership.

Calculates monthly provisions for Epic system AR and Epic manual AR; reviews with YSM Controller's Office team and creates journal entries during the month-end close period.

Researches Epic system and manual AR inquiries received from Yale Medicine (YM) and YSM management. Explains variances and takes corrective actions. Identifies and interprets trends within YSM and departments. Communicates results and findings to department leadership. Provides support to

department’s business offices for financial inquiries.

Reconciles contractual adjustments, denials, bad debts, and charity care for patient AR (Epic subsystem) and clinical trial AR (OnCore clinical trials billing subsystem).

Completes various Workday balance sheet account certifications on a quarterly basis as required by the University Controller's Office.

Plays a significant role in the preparation and an analysis of YSM's monthly financial statements and related exhibits. Develops detailed account analyses and communicates with YSM departments to gain an understanding of fluctuations and trends. Responds to leadership feedback and develops deliverables.

Responds to the University Controller’s Office's quarterly account fluctuation requests. Responds to interim and annual external audit requests.

Analyzes industry sponsored clinical trials revenue and working in conjunction with other departments (e.g., Yale Center for Clinical Investigation and the Comprehensive Cancer Center), checks accuracy of billing and associated invoices integrated into the Workday AR system. Collaborates with YSM departments to monitor the open invoices in Workday and compares to open OnCore invoices, reconciling the two systems.

Contributes to the budget and forecast processes as it relates to patient revenue through close collaboration with YM; Updates budgeting model accordingly and presents various scenarios to the YM and YSM Controller's Office teams; Inputs final results into the Yale Budgeting Tool (YBT).

Monitors YSM Dean fund balances, reviews internal revenue assessment rebate agreements, and processes corresponding journal entries.

Contributes significantly to YSM's fiscal year-end close through completion of annual financial analyses, journal entry preparation, and monitoring of fund balances deficits across YSM.

Required Skills and Abilities 1. Advanced organizational, analytical, and problem-solving skills with attention to detail. Ability to multi-task and prioritize work. 2. Understanding of GAAP. Demonstrated ability with accounts receivable and general accounting.

3. Effective oral and written communication skills and well-developed interpersonal skills with the ability to work effectively with a diverse group. 4. Ability to adapt communication style to address the needs of individuals at all levels and to represent the department in a professional manner. Ability to lead projects, particularly with staff from other departments. Ability to guide and train departments in enhancing their systems/processes. 5. Well-developed computer knowledge and demonstrated ability with a strong proficiency with Microsoft Office Suite, including Word, Excel and PowerPoint. Preferred Skills and Abilities

1. Demonstrated knowledge of Yale University’s accounting and financial systems including Workday, Epic, Microsoft Power BI, OnCore, and Yale Budgeting Tool (YBT).

2. Thorough working knowledge of Yale University business, accounting, and financial policies, and procedures.

3. Understanding of clinical trial processes and electronic medical record systems.

Salary offers are determined by a candidate’s qualifications, experience, skills, and education in relation to the position requirements, along with the role’s grade profile and current internal and external market conditions.

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 position. Employees will be assigned specific job-related duties through their hiring department.

The University is committed to basing judgments concerning the admission, education, and employment of individuals upon their qualifications and abilities and seeks to attract to its faculty, staff, and student body qualified persons from a broad range of backgrounds and perspectives. In accordance with this policy 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).

Yale University is a tobacco-free campus.