National Equity Fund Logo

National Equity Fund

LIHTC Modeling & Structuring Manager

Reposted 3 Days Ago
Be an Early Applicant
In-Office
60661, Chicago, IL, USA
Mid level
In-Office
60661, Chicago, IL, USA
Mid level
Lead review, troubleshoot, and maintain LIHTC Excel financial models from bid through closing and lifecycle. Coordinate tax and structuring with underwriting, fund accounting, investor relations, and external counsel. Conduct closing audits, produce stress analyses, manage post-closing changes, and adapt the organization's primary underwriting model to ensure tax and structural accuracy.
The summary above was generated by AI

National Equity Fund Inc. (NEF), is a leading non-profit syndicator of Low-Income Housing Tax Credits (LIHTC) with a mission to create and deliver innovative, collaborative financial solutions to expand the creation and preservation of affordable housing.

NEF is seeking a LIHTC modeling and structuring specialist to ensure the accuracy, consistency, and tax/structural integrity of our Low-Income Housing Tax Credit (LIHTC) investment models, from initial bid through closing and across the full project life cycle. This role combines deep Excel modeling expertise with tax structuring knowledge, working cross-functionally with underwriting, Fund Accounting, Investor Relations, and external counsel to keep financial models accurate, investor-ready, and aligned with current tax law.

Essential Duties:

  • Review and troubleshoot Excel models for new project bids and throughout the project life cycle to support the closing team and ensure accurate inputs, outputs, and alignment with internal modeling standards and tax law

  • Review projections in conjunction with NEF’s Tech Committee, Investment Proposal preparation, and pre-closing for assigned projects

  • Recommend changes that may enhance yield or address structuring issues

  • Coordinate with external counsel on transaction structuring considerations

  • Conduct closing audits to confirm projections accurately reflect technical and business terms

  • Troubleshoot and redesign models as needed, including managing and adapting the organization's primary underwriting spreadsheet model

  • Manage investor and credit requests for stress analyses for multi-fund closings and Investment Proposal packages

  • Manage and assist with post-closing change requests as assigned and support Asset Management in evaluating the impact of post-closing structural or financial changes

  • Assist other departments, including Fund Accounting and Investor Relations, in evaluating and modeling any unique requirements for assigned projects.

The Ideal Candidate:

  • Bachelor's degree in Business, Accounting, Finance, Economics, or Mathematics (Master's or CPA preferred); tax accounting background strongly preferred

  • 4+ years of LIHTC experience, including experience in real estate structuring, debt structuring, and partnership modeling

  • Advanced Excel skills, including the ability to build, manipulate, and troubleshoot complex tax-incentivized real estate models

  • Familiarity with specialized tax structuring conventions and time value of money concepts

  • Specific knowledge of tax issues affecting limited partnerships, entity classifications, and Section 42 (LIHTC) projects preferred

  • Familiarity with other federal or state tax credit programs (historic, solar, new markets) a plus

  • Strong communication skills and ability to work effectively across departments and with external partners

  • High attention to detail, ability to multi-task and work independently in a fast-paced, deadline-driven environment


We offer a competitive salary, along with a comprehensive benefits package.

NEF IS AN EQUAL OPPORTUNITY EMPLOYER


Similar Jobs

An Hour Ago
Hybrid
Chicago, IL, USA
50K-65K Annually
Junior
50K-65K Annually
Junior
Cloud • Fintech • Software • Financial Services
Provide frontline support for YCharts' SaaS platform via email, chat, and phone. Troubleshoot product/data/technical issues, escalate as needed, monitor usage and customer health, share customer insights with product and engineering, create educational resources, and support process improvements to drive engagement and retention.
2 Hours Ago
Remote or Hybrid
United States
135K-185K Annually
Senior level
135K-185K Annually
Senior level
Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Lead and grow a global data engineering team while establishing foundational data platforms and engineering standards. Design and oversee GCP-based pipelines, medallion data models, DataOps, monitoring, SLAs, CI/CD, governance, and data quality practices. Drive AI adoption across engineering workflows and build reliable, AI-ready data. Partner with business and technology stakeholders to prioritize roadmaps, deliver scalable solutions, and support data democratization.
Top Skills: Apache AirflowBigQueryCeligoChatgptClaudeCloud ComposerCloud IamCloud StorageCopilotData Policy TagsDataflowDbtGCPInfrastructure As CodeLookerPub/SubPythonSQL
2 Hours Ago
Hybrid
Chicago, IL, USA
110K-110K Annually
Senior level
110K-110K Annually
Senior level
Information Technology • Professional Services • Financial Services
Designs, implements, and maintains global network and perimeter security infrastructure. Responsibilities include firewall rule analysis and optimization, security solution integration, network monitoring, troubleshooting, technical support, and collaboration on security projects with internal teams and data center partners. The role requires onsite work in Chicago at least three days weekly and occasional nighttime or weekend on-call availability.
Top Skills: Cisco Networking EquipmentFirewallsIntrusion Detection SystemsIntrusion Prevention SystemsNetwork DesignNetwork SecurityPerimeter SecuritySecure Application DesignVpns

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account