Real Estate Financial Analyst
Johns Hopkins is America's first research university, founded on the belief that teaching and research are interdependent, and that a modern university must do both well. Nearly 140 years later, Johns Hopkins remains a world leader in both teaching and research, with more than 21,000 undergraduate and graduate students studying with esteemed faculty members across nine world-class academic divisions. The school overall is currently 11th in U.S. News & World Report’s best universities rankings, with nationally ranked programs in public health, nursing, medicine, engineering, education, and several others.
Johns Hopkins University is based in Baltimore, but has 10 divisions spread out across 10 campuses on three continents. There are four Baltimore campuses: Homewood, where the schools of Arts and Sciences, Engineering, and Education are located; East Baltimore, home to the schools of Medicine, Nursing, and Public Health, as well as the world-renowned Johns Hopkins Hospital; the Peabody campus, site of the Peabody Institute, the nation's oldest conservatory; and Harbor East, the waterfront home of the Carey Business School. The School of Advanced International Studies is based in Washington, D.C., about an hour south of Baltimore, but also has campuses in Italy and China. Additionally, Johns Hopkins has regional satellite campuses in Montgomery County, Maryland, a burgeoning biotech hub north of Washington, D.C.; and in Columbia, Maryland, located just outside Baltimore. Johns Hopkins Applied Physics Laboratory, the nation's largest university-affiliated research center, is based in nearby Laurel, Maryland.
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. Johns Hopkins Medicine is regularly ranked as one of the best medical schools and health systems in the world.
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.
- Bachelor’s Degree required.
- Finance or Business concentration preferred.
- 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.
Johns Hopkins University has retained Helbling & Associates to assist in the search for the Real Estate Finanical Analyst.. Nomination, inquiries, and applications may be sent in confidence to:
Aubrey Allen, Search Consultant
+(724) 935-7500, x115
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.
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