Budget Analyst II

$91,000 - $99,500/Yr

Weill Cornell Medicine - New York, NY

Full-time - Mid Level

New York, NY

Educational Services

About the position

The Budget Analyst II at Weill Cornell Medicine is responsible for managing budgetary and financial reporting activities under the direction of the Budget and Planning unit. This role involves developing the annual operating budget, maintaining budget databases, preparing budget forecasts, and ensuring adherence to institutional policies. The analyst will work closely with grants and clinical trials administrators to confirm funding and expenditures, while also providing guidance on budget policies.

Responsibilities

• Develops the annual operating budget and associated policies and guidelines.
• Gathers industry or peer data for comparison and best practices.
• Responsible for the administration of departmental budget(s) and the implementation of budgets into the enterprise resource financial system.
• Prepares and distributes allocations and associated schedules to calculate funding sources for allocations.
• Updates and maintains changes to allocations as needed.
• Maintains budget databases and models used for allocations and trending analysis.
• Prepares preliminary budget forecasts.
• Assists in the development and execution of budgeting modules/templates.
• Identifies and recommends improvements to previous versions of budgeting modules and participates in training sessions surrounding the use and features of the modules.
• Works with grants and clinical trials administrators to confirm funding and expenditures.
• Provides guidance on budget policies to ensure adherence to institutional policies and standards.
• Develops and maintains budget vs. actual reports.
• Analyzes variances to identify and assist in rectifying any budget discrepancies.
• Escalates any unresolved issues.
• Monitors and performs funding and revenue/expense transfer transactions as needed.
• Prepares report of faculty earning $500,000 or more in total compensation.
• Calculates faculty compensation payout to determine supplemental accruals.

Requirements

• Bachelor's Degree in Finance, Accounting, Economics, or Business Administration.
• Approximately 3 years of finance related experience, preferably within an academic medical center.
• Fund accounting knowledge is highly desired.
• Experience with database software or an enterprise resource planning system, SAP preferably, is highly desired.
• Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, and data analysis.
• Strong analytical and problem-solving skills.
• Attention to detail and accuracy in numerical work.
• Ability to manage multiple projects and meet deadlines.
• Excellent communication skills, both written and verbal.