Senior Data Analyst (Housing Operations)
Job Summary/Controls
Under the general direction of the Chief of Agency Analytics, Inspections and Technology or designee, the 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 and Responsibilities
- 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.
Other Duties and Responsibilities
- 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 and/or Experience
- Bachelor’s degree in public administration, urban studies, economics, social science, statistics, data analytics, or a related field required. Master’s degree preferred.
- 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.
An Equal Employment Opportunity Employer