0887 - Mayoral Staff VII

Senior Data Analyst, Community Life and Development , HOPE SF

Recruitment #TEX-0887-101507



P E O P L E .  P O W E R .  IN P L A C E

.Senior Analyst, Community Life and Development

HOPE SF, Office of the Mayor, City and County of San Francisco  


Initiative Overview A public-private partnership led by Mayor London N. Breed, the San Francisco Foundation, and Enterprise Community Partners, the Partnership for HOPE SF is the nation’s first large-scale community development and reparations effort to rebuild public housing into vibrant, racially equitable, and inclusive mixed-income communities without displacement of original residents. We believe that the symptoms of community trauma across are neighborhoods are the product of decades of intentional and racialized economic, political and social isolation, a lack of investment in economic development for the maintenance and improvement of the built environment, the loss of social capital with the flight of middle-class families, and the segregation of poverty and exposures to high levels of violence. Alice Griffith, Sunnydale, Potrero Hill, and Hunters View. Mobilizing nearly $2.5 billion over twenty years, our public private partnership envisions a San Francisco where race and place are not barriers to opportunity and prosperity within the City.

Position Summary Overview The Senior Analyst for Community Life and Development implements the data collection and management, and Mayoral accountability related to community development for the HOPE SF initiative. The goal of the position is to create and utilize data systems to drive policies and practices that ensure the non-displacement and sustainable long-term inclusion of HOPE SF families in the mixed-income community development on-going across their neighborhoods.

Essential overview priority areas of work for the Senior Analyst, Community Development, include the following:

 Data Collection and Management. Design and advance strategies, practices and partnerships to advance data collection and management in connection with public housing families. As part of the Community Life and Development team, the position oversees collection and management of datasets pertaining to HOPE SF family demographics, housing stability and retention, and work order and maintenance requests. In connection with recently passed HOPE SF Right to Return affordable housing priority program, includes verification and eligibility research, database updates, and collaboration with public sector partners, including the San Francisco Housing Authority.

Data Analysis and Visualization. The Senior Analyst will provide technical support to the Community Life and Development team with data analysis and visualization. This includes data dashboards, presentations, and other creative materials that visualize the progress, challenges, and opportunities for growth of the Community Life and Development work areas.

General Administrative Support. Be the main point of contact for community development related inquiries from residents, services staff, and other partners. Coordinate meetings schedules internally and externally, as well as prepare meeting materials. Other administrative support includes the development of internal communication tools, memorandums, and other external communications.

Cross-Systems Data Design Support. Act as a bridge/link across the HOPE SF backbone (including content areas of health/wellness, education, economic advancement) for data integration, sitting as a team member in partnership with the HOPE SF Director of Performance and Evaluation, other citywide data analysts, and philanthropic stakeholders. Requires the holding and synthesis of data related to community life and development, and the capacity to translate, link and connect various performance trends to other HOPE SF areas and partners.

Specific exemplar tasks and milestones of this role may include:

Data Collection and Management

Understand how many households across all sites are at risk for eviction due to nonpayment of rent and cause

Track the progress of Mixed Status Families, households with mixed immigration status

Developing work order/maintenance request tracking tool and procedures

Relocation data tracking and monitoring

Historical data archives

Services/case management data collection and reporting

Right to return family tracking

SFHA Administrative plan analysis

 Data Analysis and Visualization

Data analysis

Data visualization

 Presentations and meeting materials

Data dashboards

Services and development budget analysis

ArcGIS – bonus

Community Life and Development Administration

Point of contact for front line staff to Mayor’s Office HOPE SF, Community Life and Development

Coordinate meetings, calls, and schedules

Manage internal communication and operations

Conducting policy research and analysis

Creating policy memorandums

Cross-Systems Data Design Support

Data design meetings with the Director of Performance and Evaluation

Data working group sessions with public sector and philanthropic partners

Data and evaluation-related fundraising support

Limited data analysis and support of other HOPE SF team members through database linkages

Presentations at public hearings, commissions and leadership meetings

The strongest candidates will have:

·3-5 years of experience in data collection, management, analysis, and/or visualization

Knowledge of San Francisco’s neighborhoods, particularly public housing communities;

Existing relationships with HOPE SF stakeholders, understanding of Citywide systems, demographic trends, and experience in supporting low-income families of color in navigating resources and systems within the City and County of San Francisco;

Advanced Excel skills, must be comfortable utilizing different functions, formulas, pivot tables, and visualization features;

Excellent written and communication skills, and effective presentation to large groups

Experience building trust, and developing relationships with families in underserved communities of color;   ·        

Proficiency in Microsoft Office suite (Office, Excel, PowerPoint) and ability to organize and synthesize qualitative and quantitative data for presentations; and

Technical experience with Tableau, PowerBi, SAS, STATA, and/or ArcGIS.

What It Means to Work Here

When you join our HOPE SF team, you can expect to be part of an inclusive, intellectually demanding, entrepreneurial and equity-focused initiative that approaches neighborhood revitalization as a social justice movement requiring relentless collaboration across an array of stakeholders. Our partnership is organized around the following operating principles for reparations:

•       Radical Love of Residents. Understanding the historical and institutional harm done on our communities, we prioritize durable, consistent and compassionate healing ground in a persistent commitment to acknowledging the power, history and resilience of our residents.

 •       Accountability to Equity through Results. We use data to advance racial equity, address disproportionality, and inform decision making, assessing resource allocations and strategic interventions according to results-based accountability;

•       Healing-Centered Transformation. Based on the belief that “if we don’t transform trauma, we transmit it,”[1] we hold ourselves and our partners accountable to help heal pain across systems, communities and individuals;

•      Trusted Community Collaboration through Collective Impact. We build community capacity through partnerships that leverage trusted relationships, center power in the neighborhood, and durably serve.

 • Public System Transformation for Families. We advance a coordinated and holistic system of care that is organized around the needs of families, and holds our public system accountable.


Under direction, performs highly specialized services for the Mayor, or one or more of the mayoral management staff, requiring the exercise of independent judgment on policy and administrative matters involving sensitive and confidential information.  Positions in these classes require judgment both in interpreting established policies, goals and objectives and in applying concepts and implementing policy-directed programs; may serve as a community liaison between the Office of the Mayor and specific communities to report concerns, issues and priorities that assist in either developing, evaluating, administering, recommending or implementing policies; may delegate and review assignments within established policy directives; may plan projects, organize assignments, lead and/or supervise staff engaged in difficult, complex, sensitive, and detailed analytical work in the areas of budget, contracts, grants, financial/fiscal forecasting, and/or economic, legislative and administrative policy development, evaluation or administration; and perform related duties as required.

Distinguishing Features

Incumbents may report to the Mayor, Division Heads, Division Deputy Directors and/or other supervisory Mayoral Staff; these positions are responsible for a variety of functions and activities for the Office of the Mayor. Positions in this class are exempt from Civil Service appointment (Charter Section 10.104.1) as they are unique to the Office of the Mayor and function to implement and administer the policies of the Mayor and may also assign and evaluate the work of other employees of the Mayoral staff.

These positions may have considerable impact on policy determination, on the implementation and/or management of Mayoral policies, goals and objectives and may have frequent contact with policy making boards, commissions, boards, committees, other agencies, the public, staff and the Mayor.

Distinctions between class levels in this job codes are based on the criticality of the position, level of complexity, organizational impact, nature and number of functions/programs managed, decision-making responsibility, and the nature and scope of duties assigned.

Supervision Exercised

May provide supervision to subordinate staff and/or assume responsibility for coordinating projects.

Examples of Important and Essential Duties

According to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this class series and are not intended to be an inclusive list.

1. Promotes the effective development, recommendation and implementation of Mayoral policies and procedures.

2. Assists in the communication of Mayoral policies and procedures the public, press, other city agencies and officials.

3. Serves as a liaison to the community and the Office of the Mayor to report community concerns, issues and priorities and promote the effective development, recommendation and implementation of policy changes where necessary.

4. Manages programs, operational activities, or projects of assigned section or program area; supervises, trains and evaluates the activities of subordinate staff and/or coordinates and monitors the work of consultants and contractors working for the Office of the Mayor.

5. Evaluates procedures, identifies and analyzes problems and issues and may implement and document new procedures for the assigned section/program.

6. Participates in budget analysis, preparation and development, prepares contracts and administers grants; monitors Federal and State grants for compliance with all applicable laws and regulations.

7. Directs the allocation of resources to achieve timely outcomes and measurable goals within budget; adjusts plans and programs to meet emerging or new program objectives, assists in developing and implementing operational policies to ensure the efficient operation of a section or program.

8. Schedules and coordinates meetings, appointments and events for the Mayor.

9. Coordinates with the Office of the Mayor mobile and advancing team to ensure scheduled events are staffed and set up as required by the event plans; advances the Mayor on special community events and/or projects.

10. Types, word processes, edits and composes a variety of letters, memoranda and reports; prepares agenda; transcribes minutes.

11. Examines, verifies, and organizes a variety of records and reports including budget documents; develops, maintains, and manages various office/record systems.

12. Prepares summaries of reports, memoranda and documents for executive staff review.

13. Interprets administrative decisions and policies to staff, agencies and the public.

14. Schedules and maintains appointment calendar and makes business travel arrangements.

15. Performs related duties and responsibilities as assigned.

Knowledge, Skills and Abilities

Knowledge of: federal, state, and local rules and regulations pertaining to activities and functions of the specific department; modern management and financial principles and practices; and functional expertise associated with a departmental mission.

Ability to: provide strong leadership skills; direct subordinate staff engaged in diverse activities; exercise judgment in making decisions, independent analysis, adaptability and judgement on specialized proposals with difficult, complicated choices of action; make recommendations and present them effectively to the Mayor, Mayoral staff, commissions, boards, committees, other agencies and the public; apply the principles and practices of public administration, financial and personnel management, clearly interpret all applicable laws, ordinances and codes; effectively communicate Mayoral policies to commissions, boards, committees, other agencies and the public; direct research, survey techniques and statistical methods; handle administrative details independently, including the composition of letters, memoranda, and reports; establish and maintain harmonious working relationships with managers, city officials, employees, and public; prepare and present comprehensive reports.

Special Requirements:
Special qualifications including specialized knowledge, skills, abilities, education, experience, or license may be established for individual positions.

Selection Plan

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.

  • Select the desired job announcement
  • Select “Apply” and read and acknowledge the information
  • Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
  • Follow instructions on the screen

Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.

Applicants may be contacted by email about this announcement and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date.  Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter.  To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu).

Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file.  Applicants should retain this confirmation email for their records.  Failure to receive this email means that the online application was not submitted or received.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline.  Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

If you have any questions regarding this recruitment or application process, please contact the exam analyst, Karen Henderson, by telephone at 415-701-5557, or by email at Karen.henderson@sfgov.org.

Important Information - Upload your Resume and Cover Letter 

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://sfdhr.org/how-verify-education-requirements

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

Conviction History

As a selected candidate for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a selected candidate. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:

  • Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
  • Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.

Having a conviction history does not automatically preclude you from a job with the City.

If you are a selected candidate, the hiring department will contact you to schedule a fingerprinting appointment.

Disaster Service Workers

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. 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.


General Information concerning City and County of San Francisco Employment Policies and Procedures:
Important Employment Information for the City and County of San Francisco can be obtained at http://sfdhr.org/information-about-hiring-process or hard copy at 1 South Van Ness Avenue, 4th Floor.

Copies of Application Documents:
Applicants should keep copies of all documents submitted, as these will not be returned.

Right to Work:
All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.

Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at: 

Information regarding requests for Veterans Preference can be found at: 

Exam Type:  TEX
Issued:  01/18/2020
Micki  Callahan
Human Resources Director
Department of Human Resources
Recruitment ID Number: TEX-0887-101507
Mayor's Office of Housing and Community Development/ KH/ 415-701-5557


All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

For more information about benefits, please click here.


Powered by JobAps