Housing and Community Solutions Consultant

Guidehouse; Arlington (VA); Presencial; USD 74 000 - 124 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Medical, Rx, Dental & Vision Insurance

401(k) Retirement Plan

Tuition Reimbursement

Paid Holidays

Resumo da oferta

Guidehouse in Arlington, VA is seeking a Consultant to support affordable housing finance, program design, policy implementation, and operational improvement for state and local housing agencies and HUD.

You will evaluate LIHTC projects, build budgets and pro formas, perform subsidy analyses, and support client use of HOME, CDBG, ARPA funding, with strong Excel and communication skills.

Qualificações

• Bachelor's degree from an accredited college or university.
• 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.
• Experience supporting affordable housing development, finance or program implementation projects.
• Experience with public-sector organizations, housing authorities, housing finance agencies, community development organizations, or affordable housing developers.
• Experience with project types including workforce, mixed-income, rehabilitation, and permanent supportive housing.
• Experience participating in phases of affordable housing transactions (application review to asset management).
• Experience developing and analyzing budgets, pro formas, cash flow projections, and debt sizing analyses.
• Experience with LIHTCs (4% and/or 9%).
• Understanding of QAPs, equity pricing, tax credit structuring, and capital stacks.

Responsabilidades

• Support affordable housing finance and program implementation engagements for public-sector clients.
• Evaluate LIHTC and other affordable housing development proposals.
• Develop and analyze project budgets, sources and uses, pro formas, and underwriting models.
• Conduct feasibility analyses, benefit-cost analyses, and subsidy layering reviews.
• Assist with transactions, due diligence, and regulatory documentation.
• Support use of HOME, CDBG, ARPA, and other public funding sources.
• Research HUD regulations (24 CFR) and QAP guidance.
• Produce memos, reports, tools, templates, SOPs, and client-ready presentations.
• Synthesize quantitative and qualitative findings for clients.
• Coordinate with development, legal, lending, and compliance teams.

Conhecimentos

Excel modeling

Pivot tables

Lookup functions

Sensitivity analysis

PowerPoint

Word

Verbal communication

Written communication

Time management

Analytical thinking

Formação académica

Bachelor's degree

Ferramentas

Power BI

ArcGIS

Descrição da oferta de emprego

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.

• 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
• Must reside within a 50‑mile radius of a Guidehouse office with a focus on the following offices: Sacramento, CA or Arlington, VA

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

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits Include

• 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.