Data Analyst (Selective Certification - Housing and Homelessness Reporting)

Data Analyst (Selective Certification - Housing and Homelessness Reporting) City of Oakland, CA - 3.4 Oakland, CA Job Details Full-time $117,063.00 - $143,734.56 a year 5 hours ago Benefits Wellness program Commuter assistance 457(b) Paid holidays Health insurance Dental insurance 401(k) Flexible spending account Tuition reimbursement Dependent health insurance coverage Employee assistance program Vision insurance Life insurance Qualifications Regulatory compliance Process improvement Improving operational efficiency Driver's License Bachelor's degree Data quality monitoring Quantitative research Stakeholder management Full Job Description The Position The City of Oakland is an equal opportunity employer that values workforce diversity, inclusion, and equity. Oakland has a long history of activism around issues of justice and equity. Both oppression and this resistance to oppression have shaped the city's historical roots and the lives of its residents to this day. As public servants in one of the most diverse cities in the nation, we strive to develop employees who understand the harm and impacts of systemic inequity to create lasting, meaningful outcomes for everyone. Oakland strives to establish an environment that embraces the richness of culture, community, and individualism of employees. Why join the City of Oakland? The City of Oakland is recruiting to fill a Data Analyst (Selective Certification - Housing and Homelessness Reporting) vacancy in the Office of Homelessness Solutions within the City Administrator's Office. This selectively certified Data Analyst role will focus on analyzing homelessness data, housing system performance, and policy outcomes to help inform strategic decision-making across Oakland's homelessness response system. The position will conduct qualitative and quantitative research on homelessness interventions within and outside of Oakland, monitor and analyze City and County data from the Homeless Management Information System, and translate findings into actionable recommendations that support policy development, operational improvements, and resource allocation. This role will also help ensure compliance with local, state, and federal homelessness funding requirements and support implementation, monitoring, and refinement of Oakland's homelessness and housing strategy. The Office of Homelessness Solutions offers a unique opportunity to make meaningful impact on the lives of Oakland residents and the broader community. The Office leads and coordinates homelessness policy, strategy, and program implementation across City departments, Alameda County partners, and community-based organizations, with a commitment to making homelessness in Oakland rare, brief, and one-time—particularly for communities disproportionately impacted by racial disparities. We are looking for someone who is: Knowledgeable about homelessness and housing systems, including any experience working with Homeless Management Information System data, understanding U.S. Department of Housing and Urban Development reporting requirements, and familiarity with Continuum of Care structures and regional homelessness response systems- or similar data systems. Skilled in qualitative and quantitative research, including analyzing programmatic deliverables and program outcomes. Experienced in data visualization and communication, with the ability to create clear dashboards, reports, and presentations using Microsoft Excel, Microsoft Power BI, Tableau, or similar platforms. Knowledgeable about operational response systems, including outreach engagement, encampment trends, resolution metrics, shelter pathway performance, and system inflow / outflow analysis. Experienced in program evaluation and performance measurement, with the ability to assess program effectiveness and identify opportunities for continuous improvement. Able to connect data to action—translating analysis into policy recommendations, operational insights, and strategic guidance that improve homelessness system performance. What you will typically be responsible for: Analyzing, interpreting, and clearly explaining complex housing and homelessness data. Monitoring and analyzing data from the homelessness HMIS system at county, City, and program levels. Creating reports, dashboards, and data visualizations to inform decision-making, identify trends, and monitor performance measures. Developing and implementing program performance measures aligned with HUD and state performance standards. Extracting, cleaning, and manipulating data from various systems to build data models, reproducible analyses, and automated data infrastructures. Investigating and identifying data quality issues within HMIS and related systems. Conducting research on homelessness trends, best practices, policies, and comparable programs. Preparing memos, reports, and presentations for senior leadership, elected officials, and external stakeholders. Providing transparent, accountable documentation of data analyses and processing. Collaborating across City teams and community stakeholder groups that have diverse backgrounds and experiences. The Data Analyst Selective Certification - Housing and Homelessness Reporting position requires additional qualifications to the general Data Analyst. The general Data Analyst job description is posted here: Data Analyst Class Specification A few reasons you might love this job: You love to leverage data and research to shape housing and homelessness policy and advocacy priorities. You will provide creative solutions and leadership that improve data collection, databases, and staff workflows so that City departments can be more efficient at their work and have strong data for decision-making. You will collaborate with a diverse, mission-driven team with shared passions. You will advise on policies and programs that address housing insecurity and reduce economic and racial inequities. A few challenges you might face in this job: Managing time-sensitive deadlines tied to HMIS, HUD, and other funding requirements Balancing multi-faceted responsibilities. Collaborating across diverse teams and stakeholders with differing priorities Communicating clearly about sensitive, high-profile homelessness and housing issues to varied audiences

Competencies Required:

Analyzing & Interpreting Data:

Drawing meaning and conclusions from quantitative or qualitative data Attention to

Detail:

Focusing on the details of work content, work steps, and final work products

Building & Maintaining Relationships:

Establishing rapport and maintaining mutually productive relationships

Critical Thinking:

Analytically and logically evaluating information, propositions, and claims

Fact Finding:

Obtaining facts and data pertaining to an issue or question

Industry Monitoring:

Grasping the external political, economic, competitive, and social factors affecting the industry

Informing:

Proactively obtaining and sharing information

Innovative Problem Solving:

Identifying and analyzing problems in order to propose new and better ways of doing things

Legal & Regulatory Navigation:

Understanding, interpreting, and ensuring compliance with laws and regulations

Professional & Technical Expertise:

Applying technical subject matter to the job

Teamwork:

Collaborating with others to achieve shared goals

Writing:

Communicating effectively in writing Minimum Requirements for Application This recruitment will produce two eligible lists. The restricted list will be for full-time, permanent part-time, or part-time City and Port of Oakland employees who maintain employment for the duration of the recruitment and pass all stages of the recruitment process. The open list will be for all other applicants who pass all stages of the recruitment process. Selective Certification (Housing and Homelessness Reporting): This recruitment is being announced in accordance with Section 5.03 of the Civil Service Rules. The eligible list generated from this announcement will only be used to fill Data Analyst positions specialized in Housing and Homelessness Reporting , including full-time and permanent part-time positions, if applicable, and may be used to fill future vacancies with the same Selective Certification.

Education:

A Bachelor's degree in data science, information systems/technology, computer science, operations research, business administration, public administration, public policy, public health, urban planning, economics, finance, statistics, behavioral science or a closely related field. A Master's degree in public policy, public health, or a closely related field is desirable.

Experience:

Two (2) years of professional experience performing data analysis and interpretation, data/metrics reporting, and process improvement in one of the following fields: public health, public policy, housing, affordable housing, homelessness, or a closely related field. Must also have experience analyzing Homeless Management Information System (HMIS) data, and knowledge of HMIS variables, uses, and data quality considerations. Experience in an academic, data administration, or business data analytics environment is desirable, but public sector experience is preferred. License or Certificate /

Other Requirements:

Possession of a data analytics certification is desirable. Possession of a valid California Driver's License. Due to assignments and hours worked, public transportation may not be an efficient method for traveling to required locations. Individuals who are appointed to this position will be required to maintain a valid California Driver's License throughout the tenure of employment OR demonstrate the ability to travel to various locations in a timely manner as required in the performance of duties.

Desired Qualifications:

Experience integrating and analyzing data across multiple systems beyond Homeless Management Information System (HMIS), such as, ESRI/GIS, City Works (OAK 311 data), Point-In-Time Count, U.S. Census, or similar sources. Ability to work with a wide range of entities and people, including government agencies, service providers, community-based organizations, and members of the public. Experience with program evaluation, policy analysis, and/or research in the fields of: public health, public policy, homelessness, and/or affordable housing. Experience communicating about data, research, and policy in memos or reports, and with PowerPoint presentations. Masters' degree or equivalent in the field of public policy, urban planning, or public health. Lived experience or direct professional experience working with people experiencing homelessness.

Supplemental Information The Recruitment Process:

The City of Oakland works with a Civil Service system. Applicants apply online, and HR staff reviews their experience, education, and training listed on the application against the "minimum qualifications" listed for each position. Candidates who demonstrate that they meet the minimum qualification requirements are then invited to participate in an assessment process (or testing) to measure their knowledge, skills, and abilities in job-related areas. Candidates who do not demonstrate that they meet the minimum qualification requirements will have an opportunity to request a final review. Candidates must request a final review within 5 business days of being notified that they did not meet the minimum qualifications. In the final review, candidates may clarify information already provided on their application. No additional work history, education, or certifications will be accepted. Any decisions made during this review process will be final. For this recruitment, all qualified applicants will be sent a writing exercise (weighted 100%), which will then be evaluated and rated by subject matter experts. The tentative date that the writing exercise will be sent to you for completion is the week of June 8, 2026. Candidates requesting reasonable accommodations for the examination process must request accommodations no later than one week before they are scheduled to take the exam; otherwise, it may not be possible to arrange accommodations for the selection process. Please complete the Request for Reasonable Accommodation in Testing form by clicking on this link or by copying and pasting the link into your browser to open it: https://cao-94612.s3.amazonaws.com/documents/Request-for-Reasonable-Accommodation-in-Testing-2.9.22-Fillable.pdf (Download PDF reader) Candidates who pass each stage in the process will be placed on an eligible list. Some candidates may receive extra points, for example, if you are a Veteran with an honorable discharge, or if you are a current City of Oakland resident. If you're applying to a "restricted" posting and you are eligible as a current City employee, you may also receive additional points for your City service. Extra points are only applied to passing scores, so if you do not pass every element of the testing process, you cannot use extra points to pass. The City of Oakland reserves the right to modify the selection process and date of examination as necessary to conform to administrative or business necessity. The information contained in this announcement is subject to change and does not constitute either an expressed or implied contract. What's in it for you?

Work/Life Balance:

37.5 hour work weeks 15 paid holidays

Vacation:

2 weeks per year minimum with the ability to accrue more depending on public sector years of service

Retirement:

CalPERS (California Public Employees' Retirement System) with a pension formula of 2.5% @ 55 (for Classic CalPERS members) and 2% @ 62 for new CalPERS members. Classic Employees contribute 8% of pre-tax wages. The City of Oakland does not participate in

Social Security Health:

The City of Oakland pays the full cost of employee and eligible dependent coverage at the Kaiser rate. Other plans include Anthem, Blue Shield, United Health Care, and other HMO and PPO plans

Dental:

Delta Dental full premium for employees and eligible dependents

Vision:

VSP full premium for employees and eligible dependents Sick leave: Employees accrue 12 days per year

Deferred Compensation:

457(b) pre-tax plan and an after-tax

ROTH 401

(k)plan Other benefits include a Flexible Spending Account, Wellness Program, Employee Assistance Program, Tuition Reimbursement, Life Insurance up to $200k & Employee Training. Benefits described herein do not represent a contract and may be changed without notice. Additional information can be found here: Applicants are required to submit criminal history information upon request after receiving a conditional offer of employment. If the requested information is not furnished in a timely manner, applicants will not qualify for further consideration and will be removed from the eligible list. Disaster Service Workers All employees are designated Disaster Service Workers through state and local law. Employees are required to complete all Disaster Service Worker-related training as assigned and to return to work as ordered in the event of an emergency. How to Apply Apply prior to the closing time of the job announcement and allow at least two to three hours to submit your application if you are a new user of the system.

http:

//agency.governmentjobs.com/oaklandca/default.cfm. If you do not have access to a computer, there are computer stations available at any City of Oakland Public Library. There are also workstations at the Human Resources Management Department, 150 Frank H. Ogawa Plaza, 2nd Floor, Oakland, CA 94612. Workstations are available during regular business hours (normally 10:00 a.m. to 4:00 p.m.). Our online application system is provided by GovernmentJobs. If you have problems while applying online, please contact GovernmentJobs Live Applicant Support at (855) 524-5627 between 6:00 AM and 5:00 PM Pacific Time, Monday - Friday. You may also call the City of Oakland Human Resources Management Department during regular business hours at (510) 238-3112 for information; however, we are unable to provide technical support for the online application system. For recruitment-specific questions, please contact Cynthia Ng, Senior Human Resources Analyst, at . Employer City of Oakland Address 150 Frank H. Ogawa Plaza - 2nd Floor Oakland, California, 94612 Phone (510) 238-3112 Website http://www.oaklandca.gov/ The City of Oakland is committed to the wellbeing of its employees and offers comprehensive health and wellness services along with an array of other benefits for most positions. Benefits may include•: CalPERS Medical Dental Vision Medical Waiver Plan - Cash-In-Lieu Flexible Spending Accounts Commuter Benefits Group & Supplemental Life Insurance Employee Assistance Program (EAP) Guaranteed Ride Home (GRH) Pension Benefits Deferred Compensation Specific benefits may vary depending on the assigned specific bargaining unit. Information regarding most benefits can be reviewed here: Employee Benefits Information Current MOUs may be reviewed here: City of Oakland Labor Agreements