Create Alert
Apply now »
Requisition ID:  116890

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


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


Preferred Qualifications
  • 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 

 

 

Total Rewards
The referenced base salary range represents the low and high end of Johns Hopkins University’s salary range for this position. Not all candidates will be eligible for the upper end of the salary range. Exact salary will ultimately depend on multiple factors, which may include the successful candidate's geographic location, skills, work experience, market conditions, education/training and other qualifications. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here: https://hr.jhu.edu/benefits-worklife/.

Education and Experience Equivalency
Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines: JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.

Applicants Completing Studies
Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.

Background Checks
The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate's conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.

Diversity and Inclusion
The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion.

Equal Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

EEO is the Law
https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf

Accommodation Information
If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the Talent Acquisition Office at jhurecruitment@jhu.edu. For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit https://accessibility.jhu.edu/.

Vaccine Requirements
Johns Hopkins University strongly encourages, but no longer requires, at least one dose of the COVID-19 vaccine. The COVID-19 vaccine does not apply to positions located in the State of Florida. We still require all faculty, staff, and students to receive the seasonal flu vaccine. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry. This change does not apply to the School of Medicine (SOM). SOM hires must be fully vaccinated with an FDA COVID-19 vaccination and provide proof of vaccination status. For additional information, applicants for SOM positions should visit https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/ and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/.

The following additional provisions may apply, depending upon campus. Your recruiter will advise accordingly.
The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.
Hybrid: On-site 3-4 days a week

Apply now »