Budget & Reporting Analyst I

Title : Budget & Reporting Analyst I

Location : Midtown

Org Unit : Budget and Planning

Work Days : Weekly Hours : 35.00

Exemption Status : Exempt

Salary Range : $79,700.00 - $88,900.00

• 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 WCM?s 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

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 organizational skills and ability to pay close attention to detail.

Demonstrated strong interpersonal skills; ability to interact with multiple constituencies and faculty / staff from all levels of the organization and exercise good "people skills".

Strong oral and written communication skills.

Immediate to expert knowledge with Excel and PowerPoint.

Demonstrated ability to manage multiple priorities efficiently and diplomatically in a high-pressure, complex environment.

Licenses and Certifications

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, actual or perceived disability (including persons associated with such a person), 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) and qualified individuals with disabilities under Section 503 of the Rehabilitation Act. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.