1822 Administrative Analyst

Data & Performance Analyst

Recruitment #pbt-1822-106470

Introduction

We Value Equal Employment Opportunity!

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.


Who We Are
Through the provision of coordinated, compassionate, and high‐quality services, the Department of Homelessness and Supportive Housing (HSH) strives to make homelessness in San Francisco rare, brief, and one time. The Department provides assistance and support to homeless and at‐risk youth, adults and families to prevent imminent episodes of homelessness and end homelessness for people in San Francisco. Services including outreach, homelessness prevention, emergency shelter, drop‐in centers, transitional housing, supportive housing, short‐term rental subsidies, and support services to help people exit homelessness. For more information about the department, please visit our website.

What We Do
San Francisco is a pioneer in homeless services and a leader in providing supportive housing as a permanent exit from homelessness. The Department of Homelessness and Supportive Housing seeks to be a national leader in the movement to end homelessness by developing a coordinated, client-focused system of services, piloting innovative models, and implementing proven solutions with measurable results. Major programs include: street outreach and service connection through the Homeless Outreach Team; a robust shelter system for single adults and families including shelters for members of the LGBT community and survivors of domestic violence; Navigation Centers that provide temporary shelter individuals and couples using a low-threshold model; rapid rehousing rental subsidies for families, adults, seniors and transitional aged youth; the Homeward Bound program which has helped 10,000 individuals return to stable housing in their city of origin; and robust supportive housing programs of nearly 7,500 units which provide permanent housing and services to formerly homeless individuals and families.

What You’ll Be Doing
Under general direction of the Data & Performance Lead, the Administrative Analyst performs and conducts difficult and detailed professional-level analytical work to support the Department of Homelessness and Supportive Housing planning activities and program operations. The position supports program operations with data analyses and program evaluation, as well as conducts key research and strategic planning projects. This position will report directly to the Data and Performance Principal Analyst. The position provides analytical support to program managers and the executive leadership team, and is expected to exercise sound judgment and take initiative.

The position includes the following responsibilities:

  • Demonstrates expertise with administrative databases, including the in-development Online Navigation and Entry (ONE System) database, to create and maintain information that is accessible, reliable, accurate, and useful to the department. 
  • Develops reports and conducts complex data analysis related to service utilization, client outcomes, and program operations for the purposes of meeting regulatory or funding requirements, satisfying ad hoc requests, or supporting program evaluation and performance accountability needs.
  • Develops and maintains dashboards for both public reporting and internal management purposes such as HOMstat, the Department’s program to systematically review data for continuous improvement.
  • Communicates findings from research and analysis, which includes producing statistical reports that are clear and incisive, writing reports that are well-organized and articulate, and making effective public presentations to diverse audiences.  
  • Supports strategic planning efforts to improve outcomes for clients served by the Department, including analyzing program outcomes and operational data to identify opportunities for greater efficiency or effectiveness. 
  • Works with staff in programs and contracts to define and monitor key metrics in the Department’s contracts with nonprofit providers that ensure alignment with systemwide goals and support performance accountability.
  • Conducts ad hoc research and data analysis as needed, which may include matching client data across multiple large datasets and databases, preparing data to share with other City departments or external evaluators, researching industry best practices, evaluating the effectiveness of pilot programs or reform efforts using quantitative and qualitative methods, or administering and analyzing surveys.
  • Coordinates administrative functions as needed for the Data and Performance Team.

Minimum Qualifications

  1. Possession of a graduate degree (Master's degree or higher) from an accredited college or university; and one (1) year 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 coursework as described in Note B; OR
  3. Possession of a baccalaureate degree from an accredited college or university, and two (2) 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 coursework as described in Note B and one (1) year full-time equivalent experience 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 1822, 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 1820 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 1822.

Desirable Qualifications
The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred to hiring.

  • Knowledge of homeless services or a related social policy area.
  • Demonstrated skills with Microsoft Excel and business intelligence software such as PowerBl, Tableau, and Looker to prepare and visualize data.
  • Working understanding of relational database systems such as MySQL and SQL server, proficiency writing SQL queries a plus.
  • Strong communication and data visualization skills to articulate quantitative information to broad audiences in clear, compelling, and easily interpretable ways.
  • Experience with Python, R or statistical software (Stata, SPSS, or equivalent) to transform data and conduct statistical analyses; Experience with geospatial analysis a plus.
  • Knowledge of project management methodology, including lean processes.
  • Experience working on research and program evaluation projects.
  • Outstanding verbal and written communication skills.
  • Experience working with a large, diverse workforce of people with different cultures, backgrounds and opinions.

Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.

One year full-time employment is equivalent to 2,000 hours (2,000 hours of qualifying work experience is based on a 40 hour work week). Any overtime hours that you work above 40 hours per week are not included in the calculation to determine full-time employment.

How To Apply

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 Department of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103, or the Airport Commission Human Resources office at 710 N. McDonnell Road, 3rd Floor, San Francisco, CA 94128.

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).

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, Sadia Afandi, by telephone at 628-652-7802, or by email at sadia.afandi@sfgov.org.

Resumes may be attached to the application; however, resumes will not be accepted in lieu of a completed City and County of San Francisco application.

Verification
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 here.

Verification of qualifying experience, when requested, must be documented on the employer's business letterhead and must include the name of the applicant, job title(s), dates of employment, description of job duties performed, and signature of the employer or the employer’s authorized representative. Experience claimed in self-employment will only be accepted if supported by documents verifying income, earnings, business license and experience comparable to minimum qualifications above. Copies of income tax papers or other documents listing occupation and total earnings must be submitted. Employees of the City and County of San Francisco may submit performance evaluations showing duties performed to verify qualifying City experience. City employees will receive credit for the duties of the class to which appointed. Credit for experience obtained outside of the employee's class will be allowed only if recorded in accordance with the provisions of Civil Service Commission Rules. Verification may be waived if impossible to obtain. The applicant must submit a signed statement explaining why verification cannot be obtained. Waiver requests will be considered on a case-by-case basis. Failure to provide the required verification, or request for waiver when requested may result in rejection of application.

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. Make sure your application and any attachments to the application submitted at the time of filing are complete and accurate and include details on all experience, education, training and other information that qualifies you for this recruitment. Failure to submit a complete and accurate application at the time of filing may result in your ineligibility for this recruitment or inability to receive full credit for scoring purposes. Any new information concerning work experience, education, training and other information that is submitted after the filing deadline may not be used for scoring or considered to determine whether you meet the minimum qualifications.

Selection Procedures

Minimum Qualification Supplemental Questionnaire (Weight: Qualifying)
Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application. This Minimum Qualification Supplemental Questionnaire is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications for this position. Applicants must also complete the official application. It is essential that applicants provide complete information in identifying their education, experience and training. The Minimum Qualification Supplemental Questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications.

Written Core Examination (Weight: 100%)
Candidates deemed eligible 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:

  • Ability to evaluate/analyze information/data and to exercise good judgment relative to that evaluation or analysis.
  • Ability to communicate written information (includes ability to proofread).
  • Knowledge of, and ability to apply, financial/fiscal principles (including the ability to use mathematical and statistical formulas).
  •  Ability to comprehend and understand written information.
  •  Ability to use various computer software programs.
  •  Ability to conduct research.
  •  Ability to establish and maintain cooperative and effective working relationships.
  • Knowledge of, and the ability to apply, principles, practices and procedures involving office operations.

This is a standardized examination, and, therefore, test questions and answers are not available for public inspection or review.

The score you achieve on this examination shall 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 this test again should you apply and be found eligible for a future announcement for which this particular test is used. If the test for this 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 to the other announcement or (b) re-take the test. 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 this test is used. Please note that, should you retest, your re-test score would become your official score since it is the most recent.

A passing score on the Written Core Examination must be achieved in order to be placed/ranked on the Eligible List.

Certification Rule
The certification rule for the eligible list resulting from this examination will be Rule of Three Scores, pending an agreement with the union for an expanded certification rule. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

Eligible List
A confidential eligible list with names of candidates who have passed the civil service examination process will be created and used for certification purposes only. An examination score report will be established so interested parties can view the ranks, final scores, and number of eligible candidates. Applicant information, including names of candidates on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once that eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.

The duration of the eligible list resulting from this examination process will be six months, and may be extended with the approval of the Human Resources Director.

Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list/score report resulting from this announcement may be used by other departments that also use this classification or a similar classification. To find other Departments that use this classification, please click here. Search that document by title or job code to see which departments use the classification.

Conviction History

As a finalist 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 finalist. 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 applying 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 applying 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 selected as a finalist, 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.

Conclusion

Reasonable Accommodation Request
Applicants with disabilities requiring reasonable accommodation for this examination can find information on requesting a reasonable accommodation here.

Seniority Credit in Promotional Exams
Information regarding seniority credit can be found here.

Veterans Preference
Information regarding requests for veteran’s preference can be found here.

Terms of the Announcement
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 www.jobaps.com/sf. 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.

Copies of Application Documents
Applicants are advised to keep copies of all documents submitted. Submitted documents become a permanent part of the exam record and will not be returned. The hiring department may require applicants to submit the same documents and/or additional documents at a later date.

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.

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 online here or hard copy at 1 South Van Ness Avenue, 4th Floor.

Exam Type: Combined Promotive & Entrance
Issued: 8/17/20
Micki Callahan
Human Resources Director
Department of Human Resources
Recruitment ID #: 106470
HSH/SA/628-652-7802

Benefits

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