Impact Finance Affordable Housing - Financial Modeling Manager

Job Description U.S. Bancorp Impact Finance is seeking an experienced finance professional to join our affordable housing team as a Real Estate Financial Modeling Manager . The Modeling Manager will conduct financial modeling and analysis of Low-Income Housing Tax Credit (LIHTC) equity investments and debt transactions. The role works with Business Development Officers, underwriting Project Managers, and Asset Managers to ensure deals balance profitability and risk targets. The team currently consists of six Modeling Managers reporting to the Assistant Director of Financial Modeling. Essential Functions Performs and supports deal-level financial and profitability modeling including deal input, IRR analysis, deal structuring, issue resolution, model customization for unique deal structures, and financial quality control, with proficiency in Excel. Serves as a critical deal team member during origination, underwriting, closing, and asset management. Provides ongoing technical support, training, and issue resolution, and explains and troubleshoots complex formulas. Collaborates with external customers, accountants, and legal counsel to structure, develop, and manage deal closing projections, and manages large datasets for analysis. Collaborates cross-functionally to connect financial information with Impact Finance syndication investment funds through timely communication, technology innovation, and financial process improvement, leveraging Excel and programming skills for data analysis and automation. Effectively communicates and synthesizes inputs, outputs, and key assumptions within models to various stakeholders, creating and presenting reports and dashboards. Prioritizes and completes multiple complex analysis and modeling projects on short timelines, with strong project management skills and the ability to multi-task. Basic Qualifications Bachelor's degree and six or more years of related experience OR MBA/JD with three or more years of directly related experience. Preferred Skills/Experience Strong analytical skills and proficiency in Excel, including manipulation, design, and troubleshooting complex Excel underwriting spreadsheets. Ability to multi-task on numerous projects and tasks simultaneously, with strong project management skills. Effective communication and teamwork skills, and experience working collaboratively in a team environment. Experience with credit analysis, debt structuring, and partnership modeling. Excellent verbal and written communication skills, with experience explaining financial concepts to a wide range of stakeholders and customers. Detailed understanding of deal profitability metrics, IRR, shareholder value analysis, and financial drivers. Bachelor’s degree in business, accounting, economics, mathematics, finance, or a related field. CPA or Master’s degree preferred. At least 6 years of experience in underwriting, structuring real estate projects, and credit analysis, with specific knowledge of tax issues impacting limited partnerships and Section 42 projects highly preferred. Location The role offers a hybrid/flexible schedule, with an in‑office expectation of 3 or more days per week and flexibility to work outside the office location for the other days. Benefits Healthcare (medical, dental, vision) Basic term and optional term life insurance Short-term and long-term disability Pregnancy disability and parental leave 401(k) and employer-funded retirement plan Paid vacation (two to five weeks depending on salary grade and tenure) Up to 11 paid holiday opportunities Adoption assistance Sick and Safe Leave accruals: one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law Pay Range Pay Range: $111,605.00 – $131,300.00 Additional Information We provide disability accommodations to applicants upon request. U.S. Bank is an equal opportunity employer. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, and other factors protected under applicable law. U.S. Bank participates in the U.S. Department of Homeland Security E‑Verify program in all facilities located in the United States and certain U.S. territories. The E‑Verify program is an Internet‑based employment eligibility verification system operated by the U.S. Citizenship and Immigration Services. Learn more about the E‑Verify program. U.S. Bank will conduct background checks consistent with applicable local laws, including the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act and the San Francisco Fair Chance Ordinance. It also complies with the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and may meet requirements of FINRA, NMLS registration, Reg Z, Reg G, OFAC, NFA, FCPA, the Bank Secrecy Act, the SAFE Act, and other federal guidelines applicable to agreements related to ethics, safety, or operational procedures. Applicants must be able to comply with U.S. Bank policies and procedures including the Code of Ethics and Business Conduct and related workplace conduct and safety policies. Posting may be closed earlier due to high volume of applicants. #J-18808-Ljbffr Us Bank