Housing and Community Solutions Consultant

Job Family: Capital Projects & Infrastructure Consulting Travel Required: Up to 25% Clearance Required: None What You Will Do: 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: 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 (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 * This position is intended to support anticipated project needs, and hiring timelines will be determined based on project requirements and start dates. The annual salary range for this position is $74,000.00-$124,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 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 View phone number on click.appcast.io or via email at View email address on click.appcast.io. 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 View email address on click.appcast.io. Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Must reside within a 50-mile radius of a Guidehouse office with a focus on the following offices: Sacramento, CA or Arlington, VA 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 #J-18808-Ljbffr US101 Guidehouse Inc.