Modeling Manager/Analyst/PM

The Modeling Manager will lead financial and tax credit modeling for LIHTC equity investments, supporting underwriting, structuring, and closing activities. This role requires deep technical LIHTC knowledge, strong partnership tax understanding, and advanced Excel modeling skills.

Client Details

This opportunity is with a nationally recognized affordable housing equity investor specializing in Low-Income Housing Tax Credit (LIHTC) transactions. The firm partners with developers and nonprofit sponsors to structure and invest in complex, high-impact affordable housing projects across the U.S.

Description

• Build, maintain, and review detailed LIHTC partnership and yield models
• Analyze minimum gain, capital accounts, depreciation, and loss allocations
• Model impacts of elections such as 168(h) and 266 on credit basis
• Evaluate deferred developer fees, federal grants, and financing structures
• Support underwriting, structuring, and closing of LIHTC transactions
• Collaborate with investment, legal, and asset management teams
• Prepare model outputs, sensitivities, and presentations for stakeholders
• Ensure models align with LIHTC regulations and IRS requirements

MPI does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or based on an individual's status in any group or class protected by applicable federal, state or local law. MPI encourages applications from minorities, women, the disabled, protected veterans and all other qualified applicants.

Profile

A successful Modeling Manager/Analyst/PM should have:

• Extensive experience with LIHTC financial and partnership tax modeling
• Strong understanding of minimum gain, credit allocation, and basis rules
• Advanced Excel skills, including INDEX MATCH, XLOOKUP, and yield functions
• Ability to analyze complex data and communicate results clearly
• Strong attention to detail and ability to manage multiple transactions

Job Offer

• Competitive salary ranging from $80000 to $130000 USD annually.
• Opportunity to work in a leading financial services company in New York.
• Engaging and challenging work environment with growth potential.
• Collaborative and professional company culture.

If you are a dedicated and analytical professional ready to make an impact in the financial services industry, we encourage you to apply!

MPI does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or based on an individual's status in any group or class protected by applicable federal, state or local law. MPI encourages applications from minorities, women, the disabled, protected veterans and all other qualified applicants.