Senior Affordable Housing Program Analyst

Cuyahoga Metropolitan Housing Authority; Cleveland (OH); On-site; USD 70,000 - 90,000; Full time

Job summary

Cuyahoga Metropolitan Housing Authority (CMHA) is seeking a Senior Affordable Housing Analyst to monitor housing operations and program performance. You will extract and present data across 60+ properties and 10,000+ housing units, producing reports for leadership and stakeholders. Strong emphasis on data-driven decisions and integrity.

The role requires 1–3 years of applicable experience, proficiency with Excel and BI tools, and a background in housing data or related fields.

Qualifications

• Bachelor’s degree in public administration, urban studies, economics, social science, statistics, data analytics, or a related field required.
• Master’s degree preferred.
• Experience with housing, government, or nonprofit program data is highly desirable.

Responsibilities

• Prepare weekly, monthly and quarterly performance reports.
• Analyze occupancy, rent collections, vouchers, and related housing data.
• Translate KPIs into measurable goals and executive summaries.

Skills

Analytical skills

Excel

Power BI

Tableau

Communication

Organizational skills

Housing systems

Education

Bachelor's degree

Master's preferred

Tools

Yardi

HUD reporting tools

Job description

JOB SUMMARY:

Under the general direction of the Chief of Agency Analytics, Inspections and Technology or designee, the Senior Affordable Housing Analyst (Senior Data Analyst) plays a key role in monitoring and reporting on the Cuyahoga Metropolitan Housing Authority’s housing operations and program performance. This position focuses on analyzing occupancy, rent collections, vouchers, and related housing data to prepare clear reports and executive summaries for internal and external stakeholders. The role focuses on turning housing and program data into actionable insights that improve decision-making to support CMHA’s mission of providing quality, affordable housing.

ESSENTIAL DUTIES & RESPONSIBILITIES:

• Daily in-office attendance is essential due to the highly unpredictable and rapidly changing nature of the job and the number of in-person and spontaneous meetings and assignments, the need to access hardcopy documents and files not readily available offsite, the need to shadow and/or provide other co-workers with hands-on training and instruction, the need to quickly locate and engage with co-workers who are on-site but not readily available by phone or email, the need to interact face-to-face and maintain a constant presence in the office to assist walk-in clients (both internal and external) and to build trust and rapport amongst colleagues while developing stronger interpersonal relationships that facilitate solid, trustworthy, and productive teamwork within the department and throughout the Authority as a whole.
• Extracts and presents data in order to present region/cluster/site-specific rent collections data for over 60 property locations and over 10,000 residential units; provides analytics for the administration of over 16,000 housing choice vouchers.
• Compares historical trends and forecasts.
• Conducts occupancy, lease up, unit status and tenant status reconciliations monthly and annually.
• Reconciles Rental Assistance Demonstration (RAD) conversion information.
• Conducts various annual analyses including but not limited to rents, payment standards and utilities; assists with loading these annual projects into system of record.
• Identifies which portions of the typical performance report data available should be the strategic focus to achieve specific performance goals.
• Translates key performance indicators into measurable goals and reports that incorporate visual charts and data displays to assist in strategic planning.
• Maintains any internal reporting tasks and external reporting products, such as the Asset Management System
• Prepare weekly, monthly and quarterly performance reports.
• Analyzes property and program performance reports to identify trends to aid in decision making.
• Tracks participants in ongoing reporting research projects.
• Conducts property-specific data research, including GIS database information, as needed.
• Assists ad hoc research requests /specific project datasets.
• Follows up with key end users to ensure data integrity, and to assist with the implementation of agreed upon next steps.
• Prepare comprehensive reports summarizing findings and recommendations to increase agency efficiency and effectiveness. When directed, produces statistical and other quantitative analyses using software and electronic data systems.
• Identifies information gaps and/or deficiencies; analyzes them and recommends corrective actions when necessary.
• Assists CMHA management personnel and/or departments in interpreting and relating external information to CMHA operations.
• Performs other related duties as assigned.

EDUCATION:

Bachelor’s degree in public administration, urban studies, economics, social science, statistics, data analytics, or a related field required. Master’s degree preferred.

EXPERIENCE:

At least 1–3 years of progressively responsible experience in program analysis, performance reporting, or research/evaluation. Experience working with housing, government, or nonprofit program data is highly desirable; candidates with strong transferable analyst/reporting skills from other industries will also be considered.

SKILLS:

• Strong analytical and quantitative skills, with ability to interpret housing program data and identify trends.
• Proficiency in Microsoft Excel (pivot tables, charts, formulas) and experience with reporting tools (e.g., Power BI, Tableau, or similar).
• Clear and concise communication skills, with demonstrated ability to prepare written summaries, reports, and presentations for leadership audiences.
• Strong organizational skills with the ability to manage recurring deadlines (monthly occupancy, quarterly reporting, annual reconciliations).
• Ability to learn and apply housing-related systems (e.g., Yardi, HUD reporting tools) — housing experience preferred but not required.
• Collaborative and professional interpersonal skills to work across departments (Finance, Operations, Resident Services, IT).
• Attention to detail and accuracy in handling data that impacts compliance and funding.

OTHER:

Possession of a valid Ohio Vehicle Operator’s license and insurability under CMHA standards.

The qualifications listed above are guidelines. Other combinations of education and experience that could provide the necessary knowledge, skills, and abilities to perform the job will be considered.