Financial Analyst 2

Working at Yale means contributing to a better tomorrow. Whether you are a current resident of our New Haven-based community, eligible for opportunities through the New Haven Hiring Initiative, or a newcomer, interested in exploring all that Yale has to offer, your talents and contributions are welcome. Discover your opportunities at Yale!

Overview
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.

Principal Responsibilities

Job Posting Date

Job Category

Bargaining Unit

Compensation Grade

Compensation Grade Profile

Salary Range