Lead Analyst-Loan Underwriting

Job title: Lead Analyst-Loan Underwriting

Company: Wipro


Job description: Job DescriptionJob Title: ‘Lead Analyst’ SME (Subject Matter Expert)Role Overview
The professional will have the opportunity to work directly with New York stakeholders to primarily perform day-to-day originations/underwriting related tasks for Insurance funds.Function OverviewAssist in the production of “Screening Memos” for the Originations Team:
As part of the loan origination process, the Origination Team produces a screening memo that details property level information (photos, maps, property description, rent roll and cash flows), market information (comparable property metrics and location) and financing information (capital stack, debt yield and loan information). The initial goal is for company to participate in the production of screening memos with the potential to participate in the underwriting and approval process for deals that BREDS elects to finance and refinance as well.Focus is to work on all the asset classes such multifamily, retail, storage, Industrial etc. loans originated by the Insurance. The Candidate would be supporting on the different workflows as mentioned below:

• Agency Pre-screening and ICM: Screening/underwriting of Agency Loans (Fannie Mae), deriving Underwriting Value, using financial spreading, rent roll analysis and creation of Investment Committee Memo.

• Non-Agency/Deal Pre-screening and ICM: Screening/underwriting of Non-Agency Loans, deriving Underwriting Value, using financial spreading, rent roll analysis and creation of ICM.

• Loan Portfolio Stratification and ICM: Stratification of portfolio of loans belonging to various asset classes, assessing their risk exposure using their property level, loan level and performance metrices.

• Draw Review Process: Reviewing draw related Invoices, Proof of Payments, Construction Budget, TI/LC, etc. and updating the Draw Review Trackers accordingly.

• On Boarding the delas on AI Based platform with the help of various closing documents, Offering Memorandum, Loan Agreement etc.

While the initial function will be to take direction from the Origination team members, the aspirational goal is to expand the Wipro scope to include the following:

• Extracting market and asset specific statistics from various data sources (for eg: CoStar or similar platforms) for the pipeline deals which are shortlisted for screening or underwriting.
• Comparing the key deal metrics which includes Occupancy, Cap Rates, Debt Yield, Cash Flow, NOI etc. of the pipeline deals with existing portfolio.
• Analyzing property pictures & map for location-based insights, preparing the capital stack (i.e., Equity vs. Debt) and presenting them in an excel and ppt format.
• Collecting and preparing sales and rent comparable of the target originations with the market data sourced through broker reports or web-based applications.
• Studying the demographics to understand the unit mixes, interpreting all sources of incomes & expenses through review of cash flows, ascertaining vacancy rates & rental income using rent rolls and using NOI to calculate key liquidity ratios i.e., DSCR, DY etc.
• Creating investment memorandums with the deal team ahead of investment committee.
• Conducting due diligence prior to closing of deal as per closing checklist.
• Data input in pipeline tool (i.e., DealPath, Loan Tapes) as and when required.

͏Essential Skills & Experience:

• Must have a good knowledge of US Real Estate Industry and Market in underwriting the CML/CRE loans across all the sectors; along with hand on experience in underwriting the Multifamily agency (Freddie & Fannie) loans.
• Should be aware of the US taxes for different States and Counties; along with knowledge of various rent/sales comparable to be used in accordance with subject properties.
• Must be well versed with concepts of Cap Rate/Index rate/ LTC/LTV/Spreads/Cap Stack, Implied vs Cash Equity and various loan specific terminologies. In addition, should know the implications and effect of UW In-place and Mark to Market assumptions using property financials and its demographics through broker provided offering memorandum.
• Candidate should have the knowledge of US Market and Sub-Market to understand the deal’s demographics and its impact on the subject property.
• Hand on experience and proficient in preparing the dynamic financial models in MS excel.
• Master’s degree – Major in Finance or Banking and Capital Markets, CFA designation a plus.
• Exceptional quantitative aptitude and skill set with a mastery of Microsoft Office applications.
• Ability to manage multiple priorities in a fast paced, fluid environment.
• Previous background with real estate lending required with Debt Underwriting’ in real estate preferable.
• Rigorous analytical mindset with a high level of intellectual curiosity and excellent problem-solving skills.
• Acute focus on attention to detail, accuracy, and data validation.
• Effective communication skills (listening, verbal, and written).
• Excellent interpersonal and teamwork skills.
• Sound judgment and discretion.
• Strong initiative, energy and confidence completing assignments with limited supervision.

If you encounter any suspicious mail, advertisements, or persons who offer jobs at Wipro, please email us at . Do not email your resume to this ID as it is not monitored for resumes and career applications.Any complaints or concerns regarding unethical/unfair hiring practices should be directed to our Ombuds Group at .We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, caste, creed, religion, gender, marital status, age, ethnic and national origin, gender identity, gender expression, sexual orientation, political orientation, disability status, protected veteran status, or any other characteristic protected by law.Wipro is committed to creating an accessible, supportive, and inclusive workplace. Reasonable accommodation will be provided to all applicants including persons with disabilities, throughout the recruitment and selection process. Accommodations must be communicated in advance of the application, where possible, and will be reviewed on an individual basis. Wipro provides equal opportunities to all and values diversity.

Expected salary:

Location: Gurgaon, Haryana

Job date: Sun, 15 Jun 2025 22:55:55 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnear.pro) you saw this job posting.Thanks&Good Luck