Debt and Liability Management Analyst I - Illinois Housing Development Authority

National Council of State Housing Agencies

Illinois

Hybrid

USD 69,000 - 87,000

Full time

8 hours ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Hybrid work arrangement

Competitive salary

Paid time off

Medical, dental, vision insurance

401(k) with immediate vesting

Tuition reimbursement

Flexible spending accounts

Job summary

Illinois Housing Development Authority (IHDA) seeks a detail-oriented Debt and Liability Management Analyst I to join our Finance team. You will apply financial analysis, data analytics, and technical expertise to support IHDA’s debt management and reporting in Illinois.

You’ll work with financial advisors, trustees, rating agencies, and internal teams to evaluate risks, improve reporting, and support informed decision-making.

Qualifications

Bachelor’s degree in Business, Finance, or related field with 3+ years of relevant experience.
Experience with financial systems, databases, and controls.
SQL and Power BI ability to query, validate, and analyze data and develop reports.
Advanced Excel skills including complex formulas, pivot tables, and modeling.
Ability to develop and maintain financial models and analyze cash flows.
Strong analytical, organizational, and communication skills.

Responsibilities

Analyze debt obligations, cash flows, risks, and financing costs to support decisions.
Build and maintain financial models for debt structures and project cash flows.
Use SQL, Power BI, and Excel to create dashboards and improve reporting efficiency.
Assist with bond issuances, debt management activities, and related transactions.
Prepare and maintain accurate financial reports and disclosures.
Monitor risk, regulatory compliance, and assist in process improvements.
Collaborate with internal teams and external partners to support IHDA’s operations.

Skills

SQL proficiency

Power BI

Advanced Excel

Financial modeling

Analytics

Problem solving

Independent work

Communication

Education

Bachelor’s degree in Business/Finance

Tools

SQL

Power BI

Excel

Financial systems

Job description

Organization: Illinois Housing Development Authority

Department: Finance

Join our Team!

At IHDA we strive to create and maintain a work environment that promotes diversity, recognition and inclusion. IHDA is committed to hiring and investing in individuals of diverse talents and backgrounds to ensure a range of perspectives and experiences inform and guide our work of financing affordable housing in the state of Illinois.

Who we are:

The Illinois Housing Development Authority (IHDA) is one of the Nation’s preeminent Housing Finance Agencies and one of the State’s ten largest financial institutions. Our mission is to finance the creation and preservation of affordable housing across the state. IHDA oversees more than 20 federal and state programs on behalf of the state of Illinois and serves as one of the state’s primary resources for housing policy and program administration. For over 50 years, IHDA has led the state in financing and supporting affordable housing.

Summary:

The Illinois Housing Development Authority (IHDA) is seeking a detail-oriented and analytical Debt and Liability Management Analyst I to join our Finance team. This position offers an exciting opportunity to apply financial analysis, data analytics, and technical expertise to support the financial operations of an organization dedicated to expanding access to affordable housing throughout Illinois.

In this role, you will help manage and monitor IHDA’s debt obligations, analyze financial performance, support bond financing transactions, and ensure accurate financial reporting and regulatory compliance. You’ll work with financial advisors, investment banks, trustees, rating agencies, and internal stakeholders to evaluate financial risks, improve reporting processes, and support informed financial decision-making.

The ideal candidate combines strong financial and analytical skills with proficiency in SQL, Power BI, and advanced Excel. We’re looking for someone who enjoys working with complex financial data, identifying opportunities for process improvement, and developing solutions that enhance efficiency and accuracy.

What You’ll Do:

Analyze Financial Performance: Evaluate debt obligations, cash flows, financial risks, and financing costs to support informed decision-making.

Develop Financial Models: Build and maintain financial models to assess debt structures, project cash flows, and compare financing scenarios.

Leverage Data & Technology: Use SQL, Power BI, and advanced Excel to analyze financial data, create dashboards, and improve reporting efficiency.

Support Debt & Bond Transactions: Assist with bond issuances, debt management activities, and financial transactions in collaboration with internal teams and external partners.

Manage Financial Reporting: Prepare, review, and maintain accurate financial reports, disclosures, and supporting documentation for internal and external stakeholders.

Monitor Financial Risk & Compliance: Evaluate creditworthiness, monitor financial obligations, and support compliance with regulatory and contractual requirements.

Drive Process Improvements: Identify opportunities to automate reporting, strengthen data accuracy, and streamline financial processes.

Collaborate Across Teams: Partner with finance professionals, financial advisors, trustees, rating agencies, and other stakeholders to support IHDA’s financial operations.

Required Qualification:

Bachelor’s degree in Business, Finance, or a related field and/or at least three (3) years of relevant professional experience in finance, accounting, IT, risk and controls, real estate, or production operations.

Experience working with financial systems, databases, and financial or system controls.

Working knowledge of SQL and Microsoft Power BI, including the ability to query, validate, and analyze data and develop reports or dashboards.

Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, and financial modeling.

Ability to develop and maintain financial models, evaluate cash flows, and analyze financial scenarios.

Strong analytical and problem-solving skills with the ability to identify discrepancies, evaluate complex information, and recommend practical solutions.

Excellent organizational skills with the ability to manage multiple priorities, meet deadlines, and work independently with minimal supervision.

Strong written and verbal communication skills, including the ability to present financial information clearly to management and other stakeholders.

Proficiency in Microsoft Office applications and experience working with database systems.

Strong interpersonal skills and the ability to collaborate effectively with internal teams and external business partners.

Preferred Qualifications:

Experience with debt management, bond financing, liability management, or financial transactions.

Experience analyzing debt structures, cash flow projections, financial risks, or credit facilities.

Experience developing automated financial reports, dashboards, or data validation processes using SQL, Power BI, or Excel.

Familiarity with regulatory reporting, financial disclosures, or compliance requirements.

Experience working with financial institutions, trustees, rating agencies, or other financial counterparties.

Knowledge of financial operations within public finance, housing finance, or a related industry.

Physical Requirements:

Alternating between sitting, standing, and walking. Ascending and descending stairs. Crouching and stooping. Pushing and pulling. Reaching overhead or below. Repetitive task movements (filing, keyboarding, copying). Lifting, carrying, and moving objects of up to 10 -15 pounds.

What we Offer:

At IHDA, we value our employees and offer a competitive compensation and benefits package designed to support your professional growth, health, and well-being.