Senior Data Analyst (Affordable Housing Operations)

The CUYAHOGA METROPOLITAN HOUSING AUTHORITY is seeking a Senior Data Analyst to support affordable housing operations through performance monitoring, analysis, and reporting. In this onsite role in Cleveland, OH, you will analyze occupancy, rent collections, vouchers, and related housing data, then turn findings into reports and executive summaries that help advance CMHA’s mission of providing quality, affordable housing. Role summary You will monitor and report on CMHA housing operations and program performance by analyzing key metrics across properties and housing choice vouchers. The work includes producing weekly through quarterly performance reporting, supporting annual reconciliations and analyses, and preparing demographic reporting and other quantitative deliverables when directed. Key responsibilities Extract and present region, cluster, and site-specific rent collections data for 60+ property locations and 10,000+ residential units , supporting administration of 16,000+ housing choice vouchers . Compare historical trends and support forecasting. Conduct monthly and annual reconciliations for occupancy, lease-up, unit status, and tenant status. Reconcile Rental Assistance Demonstration (RAD) conversion information. Perform annual analyses including rents, payment standards, and utilities, and assist with loading annual projections into the system of record. Determine which elements of typical performance report data should be the strategic focus to achieve specific performance goals. Translate key performance indicators into measurable goals and reporting that includes visual charts and data displays for strategic planning. Maintain internal reporting tasks and external reporting products, including the Asset Management System . Prepare weekly, monthly, and quarterly performance reports and analyze property and program performance to identify trends for decision making. Prepare bi-annual demographic reports and track participants in ongoing reporting research projects. Conduct property-specific data research, including GIS database information, as needed, and support ad hoc research requests/specific project datasets. Follow up with key end users to support data integrity and the implementation of agreed-upon next steps. Produce comprehensive reports summarizing findings and recommendations to improve agency efficiency and effectiveness. When directed, run statistical and other quantitative analyses using software and electronic data systems. Identify information gaps or deficiencies, analyze underlying causes, and recommend corrective actions when necessary. Assist CMHA leadership and departments in interpreting external information and relating it to CMHA operations. Perform other related duties as assigned. Required qualifications Bachelor’s degree in public administration, urban studies, economics, social science, statistics, data analytics, or a related field required. At least 1–3 years of progressively responsible experience in program analysis, performance reporting, or research/evaluation. Strong analytical and quantitative skills, including the ability to interpret housing program data and identify trends. Proficiency in Microsoft Excel (pivot tables, charts, formulas) and experience with reporting tools such as Power BI , Tableau , or similar. Clear and concise communication skills, including preparing written summaries, reports, and presentations for leadership audiences. Strong organizational skills to manage recurring deadlines, including monthly occupancy, quarterly reporting, and annual reconciliations. Ability to learn and apply housing-related systems such as Yardi and HUD reporting tools (housing experience preferred but not required). Collaborative, professional interpersonal skills to work across Finance, Operations, Resident Services, and IT. Attention to detail and accuracy when working with data that impacts compliance and funding. Possession of a valid Ohio Vehicle Operator’s license and insurability under CMHA standards. Preferred Master’s degree preferred. Experience working with housing, government, or nonprofit program data is highly desirable, and candidates with strong transferable analyst/reporting skills from other industries will also be considered. Technologies Microsoft Excel, Power BI, Tableau, Yardi, HUD reporting tools, GIS Compensation and location Location: Cleveland, OH (onsite) Salary: USD 55,971 - 67,406 per year Benefits Continuing education credits Dental insurance Dependent health insurance coverage Disability insurance Flexible spending account Health insurance Life insurance Paid holidaysPaid sick time Prescription drug insurance Professional development assistance Retirement plan Tuition reimbursement Vision insurance #J-18808-Ljbffr Cuyahoga Metropolitan Housing Authority