Housing and Community Solutions Consultant

Guidehouse

. Support client engagements focused on affordable rental housing finance, program design, policy implementation, and operational improvement .

Posted 10/16/2026full-timeUnited StatesJunior💰 $74,000 - $124,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in affordable housing finance, including financial modeling, underwriting, and program implementation. Proficient in analyzing development proposals and conducting feasibility studies while effectively managing stakeholder engagement and project deliverables.

Highest-signal resume keywords

Affordable Housing FinanceLIHTC DevelopmentFinancial ModelingHUD RegulationsProject Due Diligence

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Financial Pro FormasBudget DevelopmentFeasibility AnalysisUnderwriting ModelsCash Flow ProjectionsDebt Sizing AnalysisQuantitative AnalysisQualitative AnalysisAnalytical SkillsAttention to Detail

Soft Skills

Clear CommunicationEffective Written CommunicationTime ManagementStakeholder EngagementCoordination Skills

Tools & Technologies

Microsoft ExcelMicrosoft WordMicrosoft PowerPointGIS/ArcGISPower BI

Industry Keywords

Affordable HousingPublic-Sector ClientsCommunity Development FinanceHousing Finance Agency ProgramsRegulatory DocumentationSubsidy Layering ReviewsHOME ProgramCDBGARPAMixed-Income Housing

About the role

Key responsibilities & impact

Support client engagements focused on affordable rental housing finance, program design, policy implementation, and operational improvement
Support affordable housing finance and program implementation engagements for public-sector clients
Evaluate affordable housing development proposals, including 4% and 9% LIHTC projects
Develop and analyze project budgets, sources and uses, financial pro formas, and underwriting models
Conduct feasibility analyses, benefit-cost analyses, and subsidy layering reviews
Assist with transactions and project due diligence, including development, financing, closing package, land use, and regulatory documentation
Support client use of HOME, CDBG, ARPA, and other public funding sources
Research and interpret HUD regulations, QAPs, and program guidance
Develop memos, reports, tools, templates, Standard Operating Procedures, and presentations
Conduct quantitative and qualitative analysis and synthesize findings into client-ready outputs
Support stakeholder engagement through interviews, workshops, and coordination with partner agencies
Coordinate with development, legal, lending, and compliance teams
Manage assigned tasks, timelines, and deliverables with project leadership

Requirements

What you’ll need

Bachelors degree from an accredited college or university
Minimum of 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 or program implementation projects
Experience working with public-sector organizations, housing authorities, housing finance agencies, community development organizations, or affordable housing developers
Experience with workforce, mixed-income, rehabilitation, and permanent supportive housing project types
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 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
Must reside within a 50-mile radius of a Guidehouse office, focusing on Sacramento, CA or Arlington, VA
No security clearance required
Master’s degree, certification or training in rental housing finance, housing-related data analysis, housing finance software, GIS/ArcGIS, and Power BI are nice to have, not required

Benefits

Comp & perks

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
Up to 25% travel