Active Search

Real Estate Financial Analyst

  • Industry: Facilities Management
  • Location: Baltimore, Maryland
  • Client: Institution - Higher Education
  • Search ID: 19-0206-15

Johns Hopkins University has retained Helbling to conduct an executive search to secure a Real Estate Financial Analyst. Reporting to the Real Estate Finance Manager, the Real Estate Financial Analyst is responsible for assisting the Real Estate Finance Manager and Real Estate Department with all aspects of real estate finance, budgeting, accounting, analytics and reporting related to asset management, leasing, strategic endeavors, and new projects as may be assigned. This position also directly supports the Chief Real Estate Officer and other team members on special projects as needed.

The wholly owned Johns Hopkins portfolio includes 19 buildings with approximately 2.1 million square feet and an aggregate annual operating budget in excess of $60 million plus related capital projects. The University also leases over two million square feet of space in third party buildings, owns a hotel / conference center under third party management, has several ground leases to third parties, owns a residential portfolio of 265 units in four properties, and is considering other significant prospective development sites.

Essential Job Functions

  • Assist the Real Estate Finance Manager with all accounting functions including, annual budgets, long term financial forecasts, debt reconciliation, and P&L statements for a very diverse portfolio of assets. 
  • Analyze and assist with analytical aspects of strategic real estate endeavors including acquisition pursuits, ground leases, development projects, financing, underwriting joint venture agreements, financial projections, lease alternatives, and the general evaluation of opportunities and risks. 
  • Prepare and build Excel based financial models for the above, including extensive sensitivity analysis.
  • Prepare cash flow projections. Assist with the preparation of materials for internal and external meetings. 
  • Work with accounting department to prepare and analyze reports. 
  • Prepare and analyze budgets and reporting statements. 
  • Prepare various analyses of proposed lease transactions. 
  • Prepare memoranda and presentation materials for presentations to senior leadership related to all of the above.

This position specification is a general statement of required major duties and responsibilities performed on a regular and continuous basis. It does not exclude other duties as assigned.

The Organization

The Johns Hopkins University is one of the world’s leading research universities. Based in Baltimore, Maryland, the University comprises 10 academic and research divisions and numerous centers, institutes, and affiliated entities throughout the Baltimore-Washington area and abroad. Divisions of the university include: the Zanvyl Krieger School of Arts and Sciences, the G.W.C. Whiting School of Engineering, and the School of Education on the Homewood campus; the School of Medicine, the Bloomberg School of Public Health, and the School of Nursing located nearby in East Baltimore; the Peabody Institute and the Carey Business School in downtown Baltimore; the Paul H. Nitze School of Advanced International Studies in Washington, D.C. with campuses in Bologna, Italy and Nanjing, China; and the Applied Physics Laboratory in Laurel, Maryland. In the fall term of academic year 2017- 2018 Johns Hopkins had a total enrollment of 25,151 students. The University attracts the finest undergraduate, graduate, and professional students and more federal research and development funding than any other university in the United States.

The mission of the University is to educate its students and cultivate their capacity for life-long learning, to foster independent and original research, and to bring the benefits of discovery to the world. Johns Hopkin’s real estate initiatives are closely tied to both the mission of the university as well as President Daniels’ vision for the university as expressed in his Ten by Twenty goals. Johns Hopkins is extraordinarily entrepreneurial and excellence-driven, and this entrepreneurial spirit generates the innovation for which Johns Hopkins is known internationally—innovation that often happens through
collaborations that harness complementary strengths to find solutions to our greatest societal, philosophical, and scientific challenges. 

The Johns Hopkins Medicine:
The mission of Johns Hopkins Medicine is to improve the health of the community and the world by setting the standard of excellence in medical education, research and clinical care. Diverse and inclusive, Johns Hopkins Medicine educates medical students, scientists, health care professionals and the public; conducts biomedical research; and provides patient-centered medicine to prevent, diagnose and treat human illness. Johns Hopkins Medicine pushes the boundaries of discovery, transforms health care, advances medical education and creates hope for humanity.

In 1997, leaders of the Johns Hopkins University School of Medicine and the Johns Hopkins Health System Corporation came together to form Johns Hopkins Medicine, and this blended governance structure has contributed to the success of the organizational mission – excellence in patient care, research and education. Johns Hopkins Medicine employs more than 40,000 full-time faculty and staff members, making it among Maryland’s largest private employers and the largest in Baltimore City. Johns Hopkins Medicine operates six academic and community hospitals, four suburban health care and surgery centers, and has more than 2.8 million outpatient encounters per year.

Education

  • Bachelor’s Degree required.
  • Finance or Business concentration preferred.

Experience

  • Three (3) years of progressively responsible financial analysis experience, preferably in real estate, capital markets, or underwriting required. 
  • 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.

Essential Knowledge, Skills and Abilities

  • Expert experience with the full capabilities of Microsoft Excel, including advanced analytical tools, pivot tables, macros, and the overall financial modeling process. 
  • Advanced general computer skills including working in Microsoft Office programs, including Word and PowerPoint. Argus and/or Kardin experience is preferred. 
  • Solid problem-solving, quantitative, and analytical skills required to conduct financial analysis, scenario analysis, and sensitivity modeling. 
  • Strong understanding of key components of financial models and how variables impact results. 
  • Ability to understand ownership documentation, typical land record and title documentation, deed restrictions, master leases, joint venture agreements, debt agreements, contracts, and other documentation related to real estate assets, strategic pursuits, and projects. 
  • Strong positive interpersonal skills and ability to build good working relationships with all members of the Real Estate team, its clients, and senior leadership. 
  • Excellent communication skills and ability to communicate concisely and effectively, both in writing and orally. 
  • Composed demeanor, professional appearance, positive attitude, and customer-oriented approach. 
  • Good judgment and discretion where appropriate. 
  • Ability and confidence to explain and defend work product, but flexibility to quickly understand and consider other opinions and direction. 
  • Independent worker who can prioritize and coordinate tasks to accomplish large amounts of work in a timely fashion. Ability to keep processes moving forward and take initiative as  appropriate. 
  • Ability to work well under pressure and competing priorities. 
  • Ability to shift from one project to another very quickly without loss of work quality and with minimal supervision. 
  • Self-directed and motivated, organized, detail-oriented, and demonstrates quick turnaround, follow-through and follow-up. 
  • Ability to work flexible or extended hours to accommodate increased workload/assignments during critical time periods, and to occasionally attend industry-related meetings and events outside of normal business hours. 
  • Reliable, dependable, with excellent attendance and punctuality; flexible and versatile.

Search Consultant: Aubrey Allen

Johns Hopkins University is an equal opportunity employer and does not discriminate on the basis of gender, marital status, pregnancy, race, color, ethnicity, national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, other legally protected characteristics or any other occupationally irrelevant criteria. The University promotes Affirmative Action for minorities, women, individuals who are disabled, and veterans. Johns Hopkins University is a drug-free, smoke-free workplace

Submit Resume

Subscribe to Helbling's eNewsletters & Search Alerts