Budget Analyst I

Weill Cornell Medicine; New York (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

Weill Cornell Medicine in New York City seeks a budget analyst to support the development, implementation and maintenance of the medical college’s operating budget and to build financial models for reporting.

You will assist in budgeting, prepare monthly revenue and expense reports, analyze variances and trends, and contribute to presentations for senior leadership and committees.

Qualifications

• Degree in finance, economics, or related field and 2–3 years of financial analysis or budgeting experience.
• Proficient MS Office, especially Excel (VLOOKUPs, pivot tables) and Access; ERP/database familiarity.
• Ability to gather data, prepare budgets, and develop financial models for reporting.

Responsibilities

• Support annual operating budget development and policy guidance, with data for benchmarking.
• Administer departmental budgets and integrate them into the enterprise system.
• Prepare monthly revenues and expenses reports, analyze variances and trends.
• Develop budget forecasting models and accompany presentations for leadership.
• Create schedules for allocations and funding sources; maintain budgets and models.
• Produce ad-hoc budget and financial reports as requested.

Skills

Excel

PowerPoint

Interpersonal skills

Organizational skills

Written and verbal communication

Education

Bachelor's Degree

Tools

SAP

Oracle

PeopleSoft

Job description

*As required under NYC Human Rights Law Int 1208-2018 - Salary range for this role when Hired for NYC Offices

Position Summary

Responsible for assisting in the development, implementation and maintenance of the Medical College’s operating budget, as well as creating and maintaining financial models and schedules to assist with the overall budgeting and reporting needs of the department.

Job Responsibilities

• Assists in the development of the WCM annual operating budget and associated policies and guidelines. Gathers industry or peer data for comparison and best practices.
• Responsible for the administration of departmental budgets and the implementation of these budgets into the enterprise financial system.
• Works on the preparation & distribution of institutional allocations; prepares related schedules for funding sources; updates & maintains changes to allocations as necessary; maintains budget databases & models used for allocations & trending analysis.
• Assists in the preparation and maintenance of monthly revenues and expense reports for WCMs operating budget. Analyzes reports for data integrity, variances, trends and cyclical events.
• Assists in the development and maintenance of budget models and tools for forecasting used in the development of the budget.
• Assists in the preparation of presentations and financial materials for meetings with WCM senior leadership, Board of Trustees and the Board of Overseers and the Business and Finance Committees.
• Meets with financial officers from institutional departments on budgetary requests or issues; communicates and explains budget policies to ensure adherence to Medical College policies and standards.
• Develops and maintains monthly budget vs. actual reports; analyzes variances; identifies and rectifies any budget discrepancies; escalates any unresolved issues as needed.
• Prepares and updates various schedules of institutional resources including institutional endowments, scholarships, and research funds, etc.
• Performs funding and transfer mechanisms including revenue/expense transfers and funding of institutional subsidies. Prepares ad-hoc budget/financial reports as requested.
• Performs other related duties as assigned.

Education

• Bachelor's Degree

Experience

Finance, economics or related degree is preferred.Approximately 2-3 years financial analysis, finance, or budgeting experience.Proficient knowledge of Microsoft Office Suite, including Excel - vlookups, pivot tables, etc and MS Access.Experience with databases and reporting software.Budget related experience in higher education institution is highly desired.Fund accounting knowledge helpful. Experience with enterprise resource planning system such as SAP, Oracle or PeopleSoft is a plus.

Knowledge, Skills and Abilities

• Demonstrated strong interpersonal skills; ability to interact with multiple constituencies and faculty/staff from all levels of the organization and exercise good “people skills”.
• Demonstrated ability to manage multiple priorities efficiently and diplomatically in a high-pressure, complex environment.
• Demonstrated strong organizational skills and ability to pay close attention to detail.
• Strong oral and written communication skills.
• Immediate to expert knowledge with Excel and PowerPoint.

Working Conditions/Physical Demands

Cornell welcomes students, faculty, and staff with diverse backgrounds from across the globe to pursue world-class education and career opportunities, to further the founding principle of “any person, any study.” No person shall be denied employment on the basis of any legally protected status or subjected to prohibited discrimination involving, but not limited to, such factors as race, ethnic or national origin, citizenship and immigration status, color, sex, pregnancy or pregnancy-related conditions, age, creed, religion, arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual’s genetic information, domestic violence victim status, familial status, marital status, or any other characteristic protected by applicable federal, state, or local law.
Cornell University embraces diversity in its workforce and seeks job candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. We hire based on merit, and encourage people from historically underrepresented and/or marginalized identities to apply. Consistent with federal law, Cornell engages in affirmative action in employment for qualified protected veterans as defined in the Vietnam Era Veterans’ Readjustment Assistance Act (VEVRRA). We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.