Mayor’s Office of Housing and Community Development (MOHCD)
MOHCD’s mission is to support San Franciscans with affordable housing opportunities and essential services to build strong communities. We are industry leaders in financing the development, rehabilitation and preservation of affordable housing. Through our financing, we strengthen the social, physical and economic infrastructure of San Francisco’s low-income neighborhoods and communities in need. We actively collaborate with community-based organizations, non-profits, affordable housing developers, and other City agencies and staff, in our pursuit of a more equitable and affordable San Francisco. In our hiring practices, we strive to build teams that reflect the diversity of our City and the populations we serve, promote racial equity and we urge qualified candidates of all races, ethnicity, sexual orientation, and gender identity to apply.
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, analytical coding software such as R and Python, 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.
Essential Duties and Responsibilities:
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; relational table databases; 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 analytical coding software such as Python and R; 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.
Possession of a baccalaureate degree from an accredited college or university and three(3) years full-time equivalent experience performing professional-level analytical work. Qualifying professional-level analytical work includes analysis, development, administration, and reporting in major programs and functions of an organization in the areas of budgets, contracts, grants, policy, or other functional areas related to the duties of positions in the 182X Class series.
Substitution:
Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework 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 the Class series may be substituted for one (1) year of required experience.
Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of 2 years). Thirty (30) semester units or forty-five (45) quarter units equal one year.
Important Information:
Classification - 1823 - Senior Administrative Analyst (Data Analyst)
Status - Permanent Civil Service Position
Application Opening: Monday, March 25, 2024
Filing Deadline - Monday, April 8, 2024 - 11:59 pm
Annual Salary - $115,934 - $140,894
____________________________
HOW TO APPLY
Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ 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 (@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, @smartalerts.info, and @smartrecruiters.com).
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.
Examination:
Candidates will be invited to participate in a written, multiple-choice examination, designed to measure their relative knowledge, skills and abilities in job-related areas. The “core” multiple-choice examination component may include but not be limited to:
This is a standardized examination and, therefore, test questions and test answers are not available for public inspection or review.
Scores will be valid and "banked" for three years, starting from the date of the examination. This means that, during this three-year time period, you will not be required to take any test components for which you have already attained a score. If the selection process for the future announcement is held within one year of the date of this examination, your score will be automatically applied to that announcement. However, after one year, you have the option to either (a) apply your test score(s) to the other announcement or (b) re-take the test component(s). Re-testing is permitted no sooner than one year from the date of the examination and only in association with your eligibility for another announcement for which the test component is used. Please note that, should you re-test, your re-test score would become your official score since it is the most recent.
Terms of Announcement and Appeal Rights:
Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ .
The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.
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 exam analyst at Karen Henderson - karen.henderson@sfgov.org.
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.
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.
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.
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.
Read Full Description