1823 - Senior Administrative Analyst

Data Analyst

Recruitment #pbt-1823-100032

Introduction

 

INTRODUCTION

1823 - SENIOR ADMINISTRATIVE ANALYST

Data Analyst

MAYOR’S OFFICE OF HOUSING AND COMMUNITY DEVELOPMENT

This is a Position-Based Test conducted in accordance with Civil Service Rule 111A.  The current position is located at the Mayor's Office of Housing and Community Development.  The eligible list resulting from this examination may be utilized for future positions in this class in other City departments.

Definition

Under general direction of the Director of Data, Evaluation and Compliance, the Data Analyst plans, organizes, leads and/or participates in 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 STATA, and data visualization software such as PowerBI.

Essential Duties

1.  Conducts research and analyzes data for housing and community development programs and projects, including special projects or highly visible public issues; and confers with senior management staff to discuss, evaluate and make policy recommendations on such programs and projects; conducts geospatial analysis using ArcGIS; responds to informational requests, including those of a highly sensitive nature, and may represent the department to the Mayor's office, Board of Supervisors, Controller's Office, other city officials, outside agencies and the public.  

 2.  Analyzes and interprets existing, newly enacted and proposed local, state, federal legislation and regulation for policy and operational/financial impact on the department; advises management and prepares recommendations with appropriate supporting documentation regarding how to comply with new regulations, mitigate adverse action against the department or maximize potential resources; develops, implements and monitors new and revised reporting systems required by legislation.

3. Analyzes existing and proposed administrative policies and procedures as well as organizational problems; conducts difficult and detailed studies; identifies administrative problems, determines methods of analysis, and identifies trends; prepares and presents reports with recommendations and appropriate justification based on studies and surveys; may coordinate the implementation of new systems and/or procedures. 

4. As part of the Data, Evaluation and Compliance team, coordinates data management processes 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 working group; facilitates data sharing with DataSF and 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.

5. Performs related duties and responsibilities as assigned.

Knowledge, Skills and Abilities

Knowledge of: the principles and techniques of governmental organization and management; the principles and techniques of economic and policy analysis; application of statistical and other analytical methods; applicable local, state, and federal laws and regulations affecting departmental operations; principles involved in the development and implementation of complex systems and procedures; 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; establish and maintain effective communication with senior management, officials, departmental representatives, vendors, or other agencies, including excellent interpersonal, written and verbal communications; negotiate effectively; use a personal computer and software programs as utilized in various departments; manage data; use data management systems such as Salesforce; use mapping software such as ArcGIS; use statistical analysis software such as STATA; use data visualization software such as PowerBI.

Minimum Qualifications

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.

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

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

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

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.

 

Selection Plan

Minimum Qualification Supplemental Questionnaire (Weight: Qualifying)

Written Core Examination (Weight - 50%)

Supplemental Questionnaire (Weight - 50%)

 

Selection Procedures

Minimum Qualifications Supplemental Questionnaire (Weight : Qualifying)

Candidates will be prompted to complete a Minimum Qualification Supplemental Questionnaire (MQSQ) as part of the online employment application.   This MQSQ 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 MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications.

Written Core Examination (Weight: 50%)

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:

  • 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 test answers are not available for public inspection or review.

You will receive one or more scores with respect to the multiple-choice exam component. One will correspond to the core test component and, should any specialty subtests be added to that component, you may receive one or more additional “specialty” scores. Any scores attained on these components 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. This core test is also used for 1820 Junior Administrative Analyst, 1822 Administrative Analyst and 1823 Senior Administrative Analysttherefore your test scores may be applied to one or more of these classes if you choose to apply to future recruitments. This is not the same exam that is used for 1824 Principal Administrative Analyst, as such your scores on this exam are not applied to any 1824 recruitments, and your scores from the 1824 exam cannot be applied to this recruitment. If the selection process for the future announcement is held within one year of the date of this examination and it includes any of these components [i.e., core exam or specialty subtest(s)], your score(s) for the corresponding test component(s) 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 (core or specialty subtest) is used. Please note that, should you re-test, your re-test score would become your official score since it is the most recent.

Date of Examination; Qualified applicants will be notified by email of the exact time, date and location of the examination.

For your reference, a Multiple-Choice Test Preparation Manual is available on the City and County of San Francisco Department of Human Resources website:

https://sfdhr.org/sites/default/files/documents/Exam-information/18426-Multiple-Choice-Test-Preparation-Manual.pdf.

A passing score must be achieved on the Written Core Examination in order to continue in the selection process.

Supplemental Questionnaire (Weight: 50%)

Candidates who pass the Written Core Exam will be sent a Supplemental Questionnaire (SQ) via email to complete and return.  The SQ is designed to determine relative knowledge, skills and ability levels in job related areas which may include, but not limited to: problem solving ability; ability levels in job related areas which may include, but not limited to: problem solving ability; ability to prepare and present reports; knowledge of software applications and database software; oral communication ability; and written communication skills.  All relevant experience, education and/or training must be on the supplemental questionnaire in order to be reviewed in the rating process.  The Supplemental Questionnaire will account for 50% of the total weight of the final score.

Your application and any attachments to the application must be submitted at the time of filing, are complete, 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. 

Note: A passing score must be achieved on all examination components in order to be placed/ranked on the resulting Eligibility List.   The hiring department may administer additional position specific selection procedures to make final hiring decisions.  

Certification:
The certification rule for the eligible list resulting from this examination will be Rule of 5 Scores.  Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

Eligible List/Score Report:
A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants 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 the 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 (6) 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 which use this classification, please see https://sfdhr.org/sites/default/files/documents/Forms-Documents/Position-Count-by-Job-Codes.pdf.

 

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.

Conclusion

Terms of 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.

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.

Seniority Credit in Promotional Exams: 
Information regarding seniority credit can be found at:
http://www.sfdhr.org/index.aspx?page=20#senioritycredit

Requests:
Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at: 
http://sfdhr.org/information-about-hiring-process#applicantswithdisabilities

Information regarding requests for Veterans Preference can be found at: 
http://sfdhr.org/information-about-hiring-process#veteranspreference

 

Exam Type:  CPE
Issued:  11/07/2019
Micki  Callahan
Human Resources Director
Department of Human Resources
Recruitment ID Number: PBT-1823-100032
Mayor's Office of Housing and Community Development/ KH/ 415-701-5557

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