CDA Housing Program Policy and Data Analyst

City of Madison, WI; Madison (WI); On-site; USD 79,000 - 94,000; Full time

Job summary

City of Madison, WI seeks a data analyst for the Community Development Authority to transform complex housing program datasets into actionable insights supporting HCV management.

You will build dashboards, forecast budget effects, and prepare leadership presentations on program status and funding projections. Successful candidates will apply HUD guidance, manage waitlists, and optimize voucher utilization in a primarily office-based role.

Qualifications

• 4+ years applying principles of data administration, analysis, and management.
• 4+ years applying computer software, including Microsoft products.
• 2+ years applying business administration practices and principles.
• 2+ years applying data governance, data quality, and data security principles and best practices.
• 2+ years applying computer-assisted data analysis techniques and software, such as Power BI.
• Familiarity with basic accounting practices.

Responsibilities

• Analyze program utilization, leasing trends, and funding levels using HUD tools (TYT) to support HCV management.
• Perform data-driven analysis to guide voucher issuance levels aligned with budget authority and targets.
• Evaluate and recommend payment standard adjustments based on market conditions and projections.
• Develop and maintain dashboards, reports, and forecasting models to monitor performance.
• Prepare presentations for leadership on program status, funding projections, risks, and policy recommendations.
• Interpret HUD guidance and local policies to support compliance while optimizing outcomes.
• Support waitlist strategies and selection methodologies to meet leasing targets and equitable access.
• Create tools and materials to simplify voucher program elements for housing specialists, holders, and landlords.
• Monitor trends and operational challenges to drive continuous improvement and budget utilization.
• Complete HUD reporting including VMS, EVMS, and HIP.

Skills

Power BI

Microsoft Office

Data governance

Data quality

Data security

Data analysis

Analytical thinking

Education

Bachelor’s Degree in business analytics, computer science, data science, math, statistics, economics, public administration, public policy, or related field

Two years professional data collection, analytics, and management experience

Tools

Two-Year Tool (TYT) projection model

VMS

EVMS

HIP

Job description

The Community Development Authority (CDA) in the City of Madison advances inclusive, safe, and affordable housing by pairing program delivery with data-driven decision making. In this onsite role, you will turn complex housing program datasets into actionable insights that support Housing Choice Voucher (HCV) program management and strengthen CDA housing portfolio performance. Work is performed under the general supervision of the Client Services Manager.

What you’ll do

• Analyze program utilization, leasing trends, and funding levels using U.S. Department of Housing and Urban Development (HUD) tools, including the Two-Year Tool (TYT), to support effective HCV program management.
• Perform data-driven analysis to guide voucher issuance levels in alignment with budget authority, leasing targets, and projected expenditures.
• Evaluate and recommend payment standard adjustments based on market conditions, utilization rates, and funding projections to support full and efficient resource use.
• Develop and maintain dashboards, reports, and forecasting models to monitor performance, including lease-up rates, attrition, and per-unit costs.
• Prepare and deliver presentations to leadership covering program status, funding projections, risks, and policy recommendations.
• Interpret and apply federal regulations, HUD guidance, and local policies to support compliance while optimizing program outcomes.
• Support the Admissions and Eligibility Team with waitlist strategies, including opening/closing lists and selection methodologies, to meet leasing targets and support equitable access.
• Create tools and materials that simplify voucher program elements for housing specialists, voucher holders, and landlords.
• Monitor program trends, feedback from impacted parties, and operational challenges, using analytics to drive continuous improvement and maximize budget utilization.
• Complete HUD program reporting requirements, including Voucher Management System (VMS), Electronic Voucher Management System (EVMS), and Housing Information Portal (HIP).
• Monitor building occupancy and unit turnover within Public Housing, Project-Based Voucher, and Project-Based Section 8 buildings.
• Calculate utility allowances for HUD program purposes and identify trends in building occupancy and energy consumption.
• Support energy cost modeling and utility cost projection, and present data to program managers and site staff to improve building operations.
• Perform related work as assigned.

Required experience and education

• Four (4) years applying principles of data administration, analysis, and management.
• Four (4) years applying computer software applicable to the position, including Microsoft products.
• Two (2) years applying business administration practices and principles.
• Two (2) years applying data governance, data quality, and data security principles and best practices.
• Two (2) years applying computer-assisted data analysis techniques and software, such as Power BI.
• Familiarity with basic accounting practices.
• Equivalent options: two (2) years of professional data collection, analytics, and management experience; or a Bachelor’s Degree in business analytics, computer science, data science, math, statistics, economics, public administration, public policy, or related field.
• Ability to effectively work with multicultural communities.
• Ability to meet the transportation requirements of the position.

Tools and technologies

• Microsoft products
• Power BI
• Two-Year Tool (TYT) projection model
• Voucher Management System (VMS)
• Electronic Voucher Management System (EVMS)
• Housing Information Portal (HIP)

Compensation

USD 79,210 - 93,996 per year.

Benefits and special notes

• Employees may be eligible for loan forgiveness through the Public Service Loan Forgiveness Program.

Special requirements

• Attend meetings of the Common Council and related bodies as required to discuss budget topics, including budget deliberation meetings typically scheduled on consecutive evenings in November.
• Complete HCV Training on HCV Utilization within six (6) months of appointment. Failure to complete within six months will result in not passing probation/trial period, absent extenuating circumstances.
• Work is primarily sedentary in an office environment.
• Use standard office equipment such as a telephone, computer, calculator, copier, and fax machine; ability to perform work at a sit/stand desk for lengthy periods.
• Two supplemental essay questions are included with the job posting. Responses must be attached in the attachments section of the application; applications received without attached essay responses will be eliminated from consideration.

CDA encourages applications from Black, Indigenous, People of Color, women, trans, nonbinary, and individuals with disabilities, and values diversity, equity, inclusion, and belonging.