The Johns Hopkins University School of Medicine (SOM) Central Finance Office is seeking a Financial Analyst, Capital Planning & Budgeting . 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 supporting 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 JHUSOM fiscal policies.

• Collaborate with SOM Departments and JHU Controllers Office personnel to coordinate timely and accurate funding transactions needed to properly balance accounts.

Capital Planning & Budgeting

• Utilize spreadsheet expertise to synthesize functional data for development of the consolidated SOM’s Capital Plan.

• Develop & maintain budget models to input forecasted spend of current capital projects alongside incremental department requests for new asset additions.

• Integrate SOM Fund Accounting principles into budget modeling to properly source the funding plan of each asset addition.

• Collaborate with departments to collect detailed capital planning data requirements.

• Integrate total and annual project cost estimate revisions based on updated forecast data from Project Managers, Facilities personnel and department stakeholders.

• Prepare summarized budget data analyses for leadership review of capital requests, incorporating comprehensive viewpoints of departmental trends, funding sources, and departmental affordability.

• Translate and reconcile detailed budget data into multiple reporting platforms for consolidated budget reporting at multiple organizational levels, including integration with alternate Excel models, Oracle EPM Budget tools, and others as required by JHU/JHM stakeholders.

Applies Knowledge & Critical Thinking Skills

• Apply knowledge of Excel, SAP Business Objects, Budget system applications, and other computing tools to develop analysis and manage data effectively and accurately.

• Combine knowledge of Capital Planning & Budgeting processes, the financial health of both SOM overall and departmentally to inform the capital budget and conduct reporting and analysis for decision making purposes.

• Develop a mastery of system and accounting structures across financial and capital project activities, including the assignment of project numbers, system request numbers, and categorizations of critical project details.

Trains/Communicates

• Use effective communication to ensure that School and department colleagues are familiar with internal controls, budgetary guidelines, fiscal and supply chain policies.

Collaborates

• Partner with several stakeholders and colleagues across JHU and JHHS, including the Executive Director of FP&A, the Associate Director of Finance for Capital Planning & Budgeting, all other SOM Central Finance colleagues; SOM Academic & Administrative Departments, Johns Hopkins Medicine Facilities, Johns Hopkins University Facilities & Real Estate, Johns Hopkins Fixed Asset Shared Services, other JHHS/JHM colleagues and the Johns Hopkins University Controllers Office.

Any specific physical requirements for the job

• Sitting in a normal seated position for extended periods of time.

• Finger dexterity required to manipulate objects with fingers rather than with whole hand(s) or arm(s), for example, using a keyboard.

• Occasionally lifting, carrying objects weighing 10lbs. or less.

• Occasionally pushing, pulling objects weighing 30lbs. or less.

Minimum Qualifications

• Bachelor's Degree in Finance, Accounting, Business or related field.

• 3 years progressively responsible related financial and business operations experience.

• Advanced Excel skills, with demonstrated knowledge of pivot tables, formulas, database management, and use/integration of additional reporting tools/applications.

• Demonstrated knowledge of other Microsoft Office products, including Word and PowerPoint.

• Additional education may substitute for required experience and additional related experience may substitute for required education, to the extent permitted by the JHU equivalency formula.

Preferred Qualifications

• Experience in Academic Financial Operations.

• SAP accounting knowledge preferred.

Classified Title: Financial Analyst

Job Posting Title (Working Title): Financial Analyst, Capital Planning & Budgeting

Role/Level/Range: ATP/03/PC

Starting Salary Range: $53,300 - $93,500 Annually ($73,400 targeted; Commensurate with experience)

Employee group: Full Time

Schedule: Mon-Fri, 8.30am-5.00pm

Exempt Status: Exempt

Location: Hybrid/School of Medicine Campus

Department name: ​​​​​​​SOM Admin Finance FP&A

Personnel area: School of Medicine

Equal Opportunity Employer:

Johns Hopkins University is an equal opportunity employer and does not discriminate on the basis of race, color, gender, religion, age, sexual orientation, national or ethnic origin, disability, marital status, veteran status, or any other occupationally irrelevant criteria. The university promotes affirmative action for minorities, women, disabled persons, and veterans.