Affordable Housing Finance Consultant

US101 Guidehouse Inc.; New York (NY); On-site; USD 81,000 - 135,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401k Retirement Plan

Paid Holidays

Parental Leave

Tuition Reimbursement

Learning Opportunities

Mobility Stipend

Job summary

Guidehouse is seeking a Consultant to support affordable housing engagements, focusing on housing finance, LIHTC projects, and program design. You will develop budgets, underwriting models, and feasibility analyses as part of a project team for public‑sector clients.

The role requires a BA/BS and at least 1 year in related fields; exposure to 4% and 9% LIHTCs is a plus. Strong Excel skills and clear communication are essential for client deliverables.

Qualifications

• Bachelor’s degree from an accredited college or university.
• 1+ years of experience in affordable housing finance or related fields.
• Experience with LIHTC, public funding, and HUD regulations is preferred.
• Strong analytical, research, and client‑facing communication skills.
• Proficiency with Microsoft Office and Excel financial modeling.

Responsibilities

• Support affordable housing finance and program implementation engagements.
• Develop project budgets, sources and uses, and underwriting models.
• Conduct feasibility studies and subsidy layering reviews.
• Assist with transactions, due diligence, and closing deliverables.
• Prepare memos, reports, and client‑ready deliverables.

Skills

LIHTC experience

Underwriting

Budget analysis

Cash flow projections

Excel modeling

HUD regulations

Education

Bachelor's degree

Tools

Excel

Word

PowerPoint

Power BI

ArcGIS

Job description

Job Family: Capital Projects & Infrastructure Consulting Travel Required: Up to 25% Clearance Required: None

What You Will Do:

• Guidehouse works with state and local housing agencies, public housing authorities, U.S. Department of Housing and Urban Development (HUD), and other mission‑driven clients to design, implement, and improve affordable housing programs. As a Consultant, you will support client engagements focused on affordable rental housing finance, program design, policy implementation, and operational improvement.
• You will work as part of a project team and contribute to high‑impact client work, including: Supporting affordable housing finance and program implementation engagements for public‑sector clients
• Evaluating affordable housing development proposals, including 4% and 9% Low Income Housing Tax Credit (LIHTC) projects
• Developing and analyzing project budgets, sources and uses, financial pro formas, and underwriting models
• Conducting feasibility analyses, benefit‑cost analyses, and subsidy layering reviews
• Assisting with transactions and project due diligence, including review of development, financing, closing package deliverables, land use, and regulatory documentation.
• Supporting client use of HOME, CDBG, ARPA, and other public funding sources
• Researching and interpreting HUD regulations (24 CFR), Qualified Allocation Plans (QAPs), and program guidance
• Developing supporting deliverables such as memos, reports, tools, templates, Standard Operating Procedures, and presentations for internal and external stakeholders
• Conducting quantitative and qualitative analysis and synthesizing findings into clear, client‑ready outputs
• Supporting stakeholder engagement activities, including interviews, workshops, and coordination with partner agencies with a focus on affordable housing financial products for a variety of loan execution types. This includes coordination with development, legal, lending, and compliance teams
• Managing assigned tasks, timelines, and deliverables in coordination with project leadership

What You Will Need:

• No sponsorship available for this position
• Bachelors degree from an accredited college or university
• ONE (1+) years of experience in affordable housing finance, real estate lending, underwriting, LIHTC development, housing finance agency programs, community development finance, or public‑sector housing program administration, including experience evaluating affordable housing transactions and financial feasibility
• Experience supporting affordable housing development, finance (ex. underwriting, lending, origination) or program implementation projects
• Experience working with public‑sector organizations, housing authorities, housing finance agencies, community development organizations, or affordable housing developers.
• Experience with different project types including workforce, mixed‑income, rehabilitation, and permanent supportive housing
• Experience participating in one or more phases of affordable housing transactions, including application review, underwriting, due diligence, entitlement, financing, closing, construction monitoring, or asset management
• Experience developing and analyzing affordable housing development budgets, sources and uses statements, operating pro formas, cash flow projections, and debt sizing analyses
• Experience analyzing, underwriting, developing, financing, or administering affordable housing developments utilizing 4% and/or 9% LIHTCs
• Understanding of QAPs, equity pricing, tax credit structuring, and affordable housing capital stacks
• Familiarity with the development process (entitlement, subsidy review, underwriting, due diligence, and closing) for affordable housing transactions
• Working knowledge of HUD multifamily programs and relevant federal regulations
• Advanced Excel skills including financial modeling, scenario analysis, pivot tables, lookup functions, and sensitivity testing
• Strong analytical and research skills with attention to detail
• Clear and effective written and verbal communication skills
• Ability to manage multiple priorities and meet deadlines in a consulting environment
• Proficiency with Microsoft Word, Excel, and PowerPoint

What Would Be Nice To Have:

• Master’s degree in a related field
• Certification or training in rental housing finance
• Experience with housing‑related data analysis, monitoring, or evaluation
• Exposure to syndication, underwriting, or housing finance software systems
• Experience with GIS platforms, such as ArcGIS, and data visualization tools such as Power BI

#LI-DNI

The annual salary range for this position is $81,000.00-$135,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

What We Offer:

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Position may be eligible for a discretionary variable incentive bonus
• Parental Leave and Adoption Assistance
• 401(k) Retirement Plan
• Basic Life & Supplemental Life
• Health Savings Account, Dental/Vision & Dependent Care
• Flexible Spending Accounts
• Short-Term & Long-Term Disability
• Student Loan PayDown Tuition Reimbursement, Personal Development & Learning Opportunities
• Skills Development & Certifications
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Emergency Back-Up Childcare Program
• Mobility Stipend

About Guidehouse Guidehouse is an Equal Opportunity Employer–Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation. Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco. If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at [e-mail]. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation. All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or [e-mail]. Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process. If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse’s Ethics Hotline. If you want to check the validity of correspondence you have received, please contact [e-mail]. Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant’s dealings with unauthorized third parties. Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee. Guidehouse is a global AI-led professional services firm delivering advisory, technology, and managed services to the commercial and government sectors. With an integrated business technology approach, Guidehouse drives efficiency and resilience in the healthcare, financial services, energy, infrastructure, and national security markets. Built to help clients across industries outwit complexity, the firm brings together approximately 18,000 professionals to achieve lasting impact and shape a meaningful future. guidehouse.com