Financial Analyst, Capital Planning & Budget

The Johns Hopkins University School of Medicine (SOM) Central Finance Office is seeking an additional Financial Analyst, Capital Planning & Budget in the Capital Planning and Budgeting functional unit. SOM Central Finance is the financial management unit responsible for oversight of SOM wide financial performance and partnering with departments to move forward strategic financial initiatives. The Capital Planning and Budgeting functional unit is responsible for the consolidated planning, development, and comprehensive financial analysis of SOM’s ~$500M net Capital asset portfolio. This unit works collaboratively with Johns Hopkins Medicine Facilities, Johns Hopkins Fixed Asset Shared Services, and the Johns Hopkins University Controllers Office to develop and manage the consolidated capital workflow and budgeting processes across 54 distinct academic and administrative SOM departments.

This position will report to the Associate Director of Finance in the Capital Planning and Budgeting unit under the Financial Planning and Analysis (FP&A) vertical of SOM’s Central Finance Office. The Financial Analyst will be primarily responsible for supporting the annual capital planning and budgeting process, maintaining financial models that track the funding sources and perform ongoing actual and budget-based financial analyses on renovation and equipment projects to assist management in adhering to organizational fiscal policies.

Primary responsibilities will also include budget reconciliations of SOM operating and capital lease agreements, as well as supporting the Central SOM ‘s financial review of departmental equipment and renovation request workflows. Performing comprehensive and accurate budget analyses, ensuring compliance to fiscal and supply chain policies, and using critical thinking to help align departmental needs with organizational objectives are vital aspects of the role that directly supports the management of the SOM Capital Budget. The individual will extract financial data effectively from various accounting and information systems to perform basic to moderately complex cost and financial analyses with accuracy and consistency and serve as a project manager to ensure the Capital Planning & Budgeting team is making progress toward annual goals. The individual should have the ability to work independently and collaboratively to complete assignments, meet deadlines, and deliver key results.

Specific Duties & Responsibilities

Capital Request Workflow Management

• Manage departmental requests of equipment and renovations.
• Coordinate workflow between departments, Fixed Asset Shared Services, SOM Central Finance, and Accounts Payable to drive efficient workflow processes from requisitioner to purchase order.
• Evaluate financial impacts of each request by using budgetary guidelines, fiscal policies, supply chain policies, and departmental affordability.
• Utilize evaluation data to make approval status recommendations to leadership and work with departments where additional documentation/analysis is needed.
• Communicate acquisition approvals with departments and Fixed Assets.
• Maintain a database of requests versus budget to analyze departmental affordability of ongoing requests during each fiscal year.

Capital Reporting & Analyses

• Analyze ERP Business Objects data alongside budget data to review capital additions data on a monthly basis; prepare budget variance analysis reporting that summarize key drivers of actual capital additions compared to plan.
• Collaborate with Facilities personnel and SOM Finance leaders to identify critical areas that require closer monitoring to achieve budget goals and objectives.
• Support the development of capital activity presentations for quarterly financial reporting to leadership/stakeholders.

Capital Funding

• Support the reconciliation and management of funding sources identified for SOM capital projects and equipment.
• Maintain and organize financial models that efficiently track the funding source(s) used for each capital addition across departmental and total SOM views.
• Identify reconciliation adjustments where needed to ensure each Capital Addition is properly funded/sourced in accordance with SOM fiscal policies.
• Collaborate with SOM Departments and JHU Controllers Office personnel to coordinate timely and accurate funding transactions needed to properly balance accounts.

Operating and Capital Lease Budget Reconciliation

• Manage a total SOM budget reconciliation of all SOM Operating and Capital Lease agreements, working with JHHS Facilities Finance personnel to ensure space cost allocations are accurately allocated in accordance with SOM Financial policies and