Data Analyst (1823 - Senior Administrative Analyst)

  • Full-time
  • Fill Type: Permanent Exempt
  • Work Hours: Regular
  • Job Code and Title: 1823-Senior Administrative Analyst

Company Description

Mayor’s Office of Housing and Community Development (MOHCD)

MOHCD’s mission is to address social, economic, and racial inequities through the creation of affordable housing opportunities and the funding of essential services that are foundational for strong communities.  We are industry leaders in the implementation of policies for the creation, rehabilitation and preservation of affordable housing.  In our hiring practices, we strive to build teams that reflect the diversity of our City and the populations we serve, and we urge qualified candidates of all races, ethnicity, sexual orientation, and gender identity to apply.

Job Description

Under the general direction of the Director of Data, Evaluation and Compliance, the Data Analyst at the Mayor’s Office of Housing and Community Development plans, organizes, leads, and conducts complex, sensitive, and detailed analytical work in support of departmental strategic planning efforts, policy development, decision-making, reporting and communications. A strong candidate would have experience in performing analyses using mapping software such as ArcGIS, statistical analysis software such as R, Python and Stata, and data visualization software such as PowerBI. This position will work in a highly collaborative environment and assist with the department’s efforts to move toward better outcomes and racial equity with its programs and services and to maximize the impact of program resources.

  1. Conducts research and analytical work on special projects or highly visible public issues that have significant impact on the functions and operations of the department’s affordable housing and community development programs and projects;
  2. Collaborates and confers with senior management staff and other subject matter experts to clarify needs, issues and parameters, and to discuss, evaluate and make policy recommendations on affordable housing and community development programs and projects; 
  3. Responds to internal and external informational and data requests, including those of a highly sensitive nature; 
  4. Compiles and analyzes the department’s program data for the purposes of tracking progress towards goals and of improving services, and for mandated reporting purposes;
  5. Prepares clear, comprehensive reports and presentations;
  6. Presents reports, finding and recommendations to internal and external stakeholders, including formal presentations to groups; may represent the department to the Mayor's Office, Board of Supervisors, Controller's Office, other city officials, outside agencies or the general the public;
  7. Conducts geospatial analysis and uses geospatial software to support the work of the department;
  8. Develops and implements processes, procedures and systems to clean, manage, store and present a large volume of sensitive and complex data, including creating and maintaining automated scripts;
  9. As part of the Data, Evaluation and Compliance team, coordinates data management processes and systems across departmental divisions to improve reporting and communication of the department’s impact and to evaluate and improve the department’s programs and services; facilitates an internal data and evaluation working group; facilitates data sharing with other City departments; publishes datasets on the City’s open data portal; creates and publishes dashboards to better communicate the department’s impact; supports internal staff to collect, review, analyze and report data.
  10. Performs related duties and responsibilities as assigned.

Important and Essential Knowledge, Skills and Abilities

Knowledge of: the principles, procedures and standards related to the following: government and/or non-profit management and operations; policy analysis; statistical, geospatial and other analytical methods; applicable local, state, and federal laws and regulations affecting departmental operations; the development and implementation of complex systems and procedures; program evaluation frameworks; and affordable housing and community development programs that serve low-income communities.

Ability to: collect, synthesize, and analyze a wide variety of information; conduct difficult analytical studies involving complex administrative and financial systems and procedures; work with authority to identify and define problems, determine methodology, evaluate data, make recommendations with appropriate justification and develop/implement a plan of action; effectively prioritize and organize multiple assignments and projects; exercise sound judgment; coordinate work/projects with other programs and departments; establish and maintain effective working relationships with departmental representatives, senior management, representatives of other departments/agencies, officials, contractors and the general public; negotiate effectively; speak clearly and concisely to communicate work-related information in a manner that is understandable to the intended audience; listen and effectively elicit information; prepare clear, accurate, effective, well-organized and understandable written documents and management reports; use a computer to research, access, extract and process data and information; use Windows-based software programs, including Word, Excel and PowerPoint; use data management systems such as Salesforce and/or other web-based grants or contract management systems; use statistical analysis software such as Python, R and Stata; use geospatial analysis software such as ArcGIS; use data visualization software such as PowerBI; create and maintain records; prepare correspondence, reports and other documentation, including statistical data.


1. Possession of a graduate degree (Master's degree or higher) from an accredited college or university and three (3) years of full-time equivalent experience performing professional level analytical work as described in Note A: OR

2. Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major college coursework as described in Note B and two (2) years full-time equivalent experience performing professional level analytical work as described in Note A; OR

3. Possession of a baccalaureate degree from an accredited college or university and four (4) years full-time equivalent experience performing professional level analytical work as described in Note A; OR

4. Possession of a baccalaureate degree from an accredited college or university with major college coursework as described in Note B and three (3) years full-time equivalent performing professional level analytical work as described in Note A

SUBSTITUTION: Applicants may substitute up to 2 years of the required education with additional qualifying experience in budget analysis, financial analysis and reporting, legislative/policy analysis, or contract/grant administration. One year (2000 hours) of additional qualifying experience will be considered equivalent to 30 semester units/45 quarter units.

Notes on Qualifying Experience and Education:

A. Qualifying professional-level analytical experience must be in one or more of the following functional areas: complex budget analysis, development and administration; complex financial/fiscal analysis and reporting; development of complex contracting systems and administration of competitive bid processes and complex contractual agreements; development and evaluation of complex management/administrative policy; complex grant administration and monitoring; complex program evaluation and planning; complex legislative analysis; complex economic analysis; or other functional areas related to the duties of positions in Class 1823, where the primary focus of the job is complex professional-level analysis for evaluation, recommendation, development and implementation of major programs and functions of department/organization. Analytical experience equivalent to the duties of Class 1822 is considered qualifying.

B. Coursework applicable to a baccalaureate or higher degree in specialized subject matter areas such as public or business administration, management, business law, contract law, public policy, urban studies, economics, statistical analysis, finance, accounting or other fields of study closely related to the essential functions of positions in Class 1823.

Additional Information


To be considered for this position you MUST submit a response to the three (3) Supplemental Questions. 

You may upload your response through the Smart Recruiters portal as an attachment or send to Karen Henderson - [email protected] by the filing deadline Tuesday, January 3, 2023 - 11:59 pm

Supplemental Questions (3)

  1. Describe your experience with managing data for a community development or affordable housing program. Describe your experience using a Salesforce system or other data management systems that you have used.
  2. Describe your experience with compiling, analyzing and presenting program data and/or secondary data such as Census data. Please include your experience with geospatial software such as ArcGIS data visualization software such as PowerBI. 
  3. Describe a complex data analysis project that you led, especially one in which you used a statistical analysis software. In the description, please include a brief description of the research question(s), your approach to answering the question(s), and the steps that you took for the analysis project. Please also describe challenges that you encountered and steps that you took to overcome these obstacles.


In line with the Official Public Health Order to slow the spread of COVID-19, “shelter-in-place” has been issued for all San Francisco residents that is expected to be in effect until further notice. As a result, Department of Human Resources (DHR)’s office (located at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103) is currently closed to the general public. If you have any questions, please feel free to email the Exam Analyst listed at the end this job ad.

Specific information regarding this recruitment process are listed below:

Classification - 1823 - Senior Administrative Analyst

Status - Permanent Exempt

Compensation: $110,630 - $134,446

Application Opening: Friday, December 2, 2022

Filing Deadline - Tuesday, January 3, 2023  - 11:59 pm


Applications for City and County of San Francisco jobs are only accepted through an online process. Visit and begin the application process. • Select the “I’m Interested” button and follow instructions on the screen 7 Applicants may be contacted by email about this recruitment 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 (,,,,,,,,,,,,,, and

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.

Additional Information Regarding Employment with the City and County of San Francisco:

Exam Analyst Information: If you have any questions regarding this recruitment or application process, please contact the analyst at Karen Henderson - [email protected] .

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.

All your information will be kept confidential according to EEO guidelines.

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.