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 Departmental agreements.

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.

Physical Requirements 

• 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.

• Bachelor's Degree in Finance, Accounting, Business or related field.
• Three years progressively responsible related financial/accounting 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.

• Experience in academic financial operations.
• SAP accounting knowledge.

Classified Title: Financial Analyst 
Job Posting Title (Working Title): Financial Analyst, Capital Planning & Budget   
Role/Level/Range: ATP/03/PC  
Starting Salary Range: $53,800 - $94,400 Annually ($74,100 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 

About Johns Hopkins University

Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130 years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Bal...timore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.

Show more

Show less

Connections working at Johns Hopkins University