Portfolio Analytics & Strategy Analyst Senior - Real Estate Market Analytics

PNC; Pittsburgh (Allegheny County); On-site; USD 90,000 - 130,000; Full time

Job summary

PNC is seeking a Senior Portfolio Analytics & Strategy Analyst for the Real Estate Market Analytics group. The role focuses on vetting real estate collateral for loans and forecasting market performance using industry data sources.

Based in Pittsburgh, with flexibility to base in Chicago or Cleveland, the analyst will support relationship managers and credit officers, deliver concise data-driven summaries, and contribute to term sheet development.

Qualifications

• Bachelor's degree or higher with 3+ years related experience.
• Analytical mindset and ability to synthesize data from multiple sources.
• Strong relationship building and communication skills.

Responsibilities

• Provides financial and regulatory reporting and analyses to maintain controls over the financial and regulatory reporting processes.
• Leverages business/product expertise to analyze large datasets, improve risk adjusted returns, deliver profitable growth, and communicate conclusions.
• Applies predictive models and data to develop portfolio strategies and risk insights.
• Works with business, credit, data, and model teams to support lending decisions.

Skills

Analytical mind

Relationship building

Interpersonal skills

Communication skills

Education

Bachelor's Degree or higher

Tools

Argus

Job description

Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company’s success. As a Portfolio Analytics & Strategy Analyst Senior within PNC's Data, Modeling & Analytics Real Estate Market Analytics organization, you will be based in Pittsburgh, PA, Chicago, IL or Cleveland, OH.

Job Profile

R235001

Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company’s success. As a Portfolio Analytics & Strategy Analyst within the Real Estate Market Analytics (REMA) group you will be responsible for vetting real estate collateral for potential and existing PNC loans prior to ordering a third-party appraisal. Emphasis is placed on prospective asset performance due to a large level of new construction lending. Analyst will cross-check forward-looking developer proformas with existing market performance using industry leading data sources such as CoStar, CBRE-EA, MSCI, Yardi Matrix etc. and forecast future results. Forecasts include absorption (during lease-up), stabilized vacancy, market rent, rent growth, and concessions. Analyst must have a strong understanding of how local submarket performance is impacted by both MSA/regional and national economic trends and how to forecast appropriate market supply and demand trends. In addition to the primary real estate types (i.e., multifamily, office, retail, & industrial), the analyst will evaluate mixed use, senior housing, student housing, tax credit, and lodging properties. While the analyst will focus largely on property level research for individual deals, macro-level industry data analysis is also routinely required for review and reporting of PNC portfolio performance or for macroeconomic reviews. The analyst will serve internal customers; the ability to multi-task and communicate timely and effectively with relationship managers, underwriters, and credit officers is instrumental in allowing PNC to develop an accurate picture of an asset and to issue competitive term sheets to gain new business. As part of the review, interviews of market experts, customers, brokers, leasing agents, and appraisers to get local views on the market are incorporated into the analysis. The analyst then writes a clear and concise summary of the supportive data and analysis for their conclusions/forecasts and presents to senior loan committee in conjunction with the deal team. Other functions of the REMA group that the analyst may work on include criticized asset valuations, reconciling appraisal findings to internal underwriting, and quarterly sector studies. Appraisal, brokerage, real estate research, urban planning, macroeconomics, real estate property management, lending, or underwriting skills are all relevant. Argus skills are not required but are helpful.

Preferred Skills And Experience

Bachelor's Degree and or an advanced degree plus 3+ years of related experience

Analytical mind and the ability to analyze a variety of data sources Relationship building skills

Strong interpersonal skills, communication skills and presentation skills

PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. We encourage candidates to connect with their recruiter and hiring manager to understand workplace expectations and ensure the role aligns with their goals.

PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.

Job Description

• Provides financial and regulatory reporting and analyses to maintain adequate controls over the financial and regulatory reporting processes. Responsible for running complex business performance, risk and operational analytics. May include the development of analytical methods/models to assess market, credit and/or operational risk of new and existing financial products.
• Leverages business / product expertise to rigorously analyze large datasets, improve risk adjusted returns, deliver profitable growth, and communicate conclusions. Synthesizes analytical results and develops, recommends, and implements business strategies that improve lending decisions, assist in managing risk, increase revenues, reduce exposure to losses, meet business goals, and improve performance. Establishes baselines for strategies and tracks actual performance to expectations.
• Applies predictive models, third party data, and other tools to develop and execute appropriate segmentation and targeting for acquisition and portfolio strategies to provide insight into portfolio risk. Manages engagements with internal and external information suppliers ensuring solution is fit for purpose while maintaining appropriate governance and oversight.
• Works with business, credit, data, and model