CDA Housing Program Policy and Data Analyst*

Madison, City of (WI); Madison (WI); On-site; USD 65,000 - 90,000; Full time

Job summary

The City of Madison is seeking a Data Analyst 2 within the Community Development Authority to transform housing program data into actionable insights that inform leadership decisions and policy development.

This role focuses on monitoring HCV operations, budget utilization, and program performance, delivering dashboards, reports, and data-informed recommendations to improve efficiency and equity for residents and participants.

Qualifications

• Four years applying data administration, analysis and management principles.
• Two years in business administration, data governance, data quality and data security.
• Familiarity with data analysis techniques and software such as Power BI.
• Two years professional data collection, analytics, and management experience (OR a related bachelor's degree).

Responsibilities

• Analyze housing program data and monitor HUD guidance to inform decisions.
• Develop and maintain dashboards, reports, and forecasting models for performance.
• Present data-informed findings to leadership to support policy and operations.
• Support waitlist strategies and leasing targets with analytics insights.
• Ensure compliance with federal requirements while optimizing program outcomes.

Skills

Data analysis

Office software

Power BI

Data governance

Data security

Business administration

Accounting basics

Education

Bachelor's degree in business analytics or related field

Tools

Power BI

Microsoft Office

Job description

The Community Development Authority’s (CDA’s) mission is to develop and provide inclusive and safe places through quality affordable housing, services, and community resources in the City of Madison. Central to advancing this mission is a strong commitment to data-driven decision making that strengthens both the Housing Choice Voucher (HCV) program and the overall performance of the CDA housing portfolio.

The CDA Housing Program Policy and Data Analyst plays a key role in supporting Program Managers and CDA Leadership by transforming complex program data into actionable insights that drive strategic, evidence-based decisions. This position is responsible for analyzing CDA housing program data, tracking federal program guidance, and reviewing national best practices in program delivery to improve the efficiency and effectiveness of CDA programs. The Analyst provides critical guidance on housing voucher issuance, payment standard setting, and leasing strategies to promote full budget utilization and long-term program sustainability. In addition, the Analyst develops and delivers clear, data-informed presentations and reports that support leadership decision-making, policy development, and operational improvements. By continuously monitoring program performance metrics—such as lease-up rates, per-unit costs, and attrition—the position helps identify risks, opportunities, and strategies to enhance outcomes for current and future residents and participants. This role ensures that CDA programs not only remain compliant with federal requirements but also operate at a high level of performance and are equitably delivered to maximize their impact across the city. The work is performed under the general supervision of the Client Services Manager.

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

Black, Indigenous, people of color, women, trans, nonbinary, and individuals with disabilities are encouraged to apply. We value the unique blend of lived experiences and diverse perspectives that comes from non-traditional education pathways and the variety of transferrable skills each candidate brings to the table. We value diversity, equity, inclusion, and belonging. Even if every item on the job posting doesn’t match your experience perfectly, we encourage you to apply and share how your skills and experience can best serve our community.

Housing Choice Voucher Program Utilization and Financial Management

• Analyze program utilization, leasing trends, and funding levels using U.S Housing and Urban Development (HUD) tools, including the Two-Year Tool (TYT) projection model, to support effective Housing Choice Voucher (HCV) program management.
• Conduct data-driven analysis to inform voucher issuance levels, ensuring 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 promote full and efficient use of available resources.
• Develop and maintain dashboards, reports, and forecasting models to monitor program performance, including lease-up rates, attrition, and per-unit costs.
• Prepare and deliver presentations to leadership that clearly communicate program status, funding projections, risks, and policy recommendations.
• Interpret and apply federal regulations, HUD guidance, and local policies to ensure compliance while optimizing program outcomes.
• Support the Admissions and Eligibility Team to manage and evaluate waitlist strategies, including opening/closing lists and selection methodologies, to support leasing targets and equitable access.
• Create tools and materials to simplify the voucher program elements for program interested parties (i.e., housing specialists, voucher holders, and landlords)
• Monitor and respond to program trends, impacted parties feedback, and operational challenges, using analytical insights to drive continuous improvement and maximize budget utilization.
• Complete HUD program reporting requirements including but not limited to Voucher Management System (VMS), Electronic Voucher Management System (EVMS), and Housing Information Portal (HIP).

Building Performance and Occupancy

• Monitor building occupancy and unit turnover within buildings supporting by the Public Housing program, Project-Based Voucher program, and Project-Based Section 8.
• Calculate utility allowances for HUD program purposes.
• Identify trends in building occupancy.
• Identify energy consumption trends and support energy cost modeling and utility cost projection.
• Present data to program managers and site staff to support improved building operations.
• Develop and maintain dashboards, reports, and forecasting models to monitor program performance, including lease-up rates, attrition, and per-unit costs.

Perform related work as assigned.

Qualifications

• Four (4) years of experience applying the following:
  • Principles of data administration, analysis and management.
  • Computer software applicable to the duties of the position, including Microsoft products.
• Two (2) years of experience applying the following:
  • Business administration practices and principles.
  • Data governance, data quality, data security principles and best practices.
  • Computer-assisted data analysis techniques and software, such as Power BI.
• Familiarity with the following:
  • Basic accounting practices.
• OR
  • Two (2) years of professional data collection, analytics, and management experience.
  • Bachelor's Degree in business analytics, computer science, data science, math, statistics, economics, public administration, public policy or a related field.

Other combinations of training and/or experience which can be demonstrated to result in the possession of the knowledge, skills and abilities necessary to perform the duties of this position will also be considered.

The City of Madison strives to provide exceptional customer service to all its residents and visitors. Therefore successful candidates will have demonstrated ability to effectively work with multicultural communities.

For a complete list of the Knowledge, Skills, and Abilities, please see the class specifications for Data Analyst 2.

Ability to meet the transportation requirements of the position.

Employees in this position will be expected to attend meetings of the Common Council and related bodies as required to discuss issues related to the budget. This includes budget deliberation meetings that are scheduled on consecutive evenings usually in November.

Must complete HCV Training on HCV Utilization within six (6) months of appointment. Failure to complete this training within six (6) months will result in the employee not passing probation/trial period, absent extenuating circumstances.

Physical Requirements

Work is primarily sedentary in nature and performed in an office environment. Employees will be expected to use standard office equipment such as a telephone, computer, calculator, copier, and fax machine and must have the ability to perform work at a sit/stand desk for lengthy periods of time.