Skip to content
 
 

Career Opportunity

Racial Equity Data Analyst – Diversity, Equity, Inclusion, & Belonging – San Francisco Human Services Agency (1823) (141838)

Recruitment: RTF0141837-01081504

Published: May 23, 2024

Contact:

Vanessa Quintano - vanessa.quintano@sfgov.org

Apply using SmartRecruiters, the City and County of San Francisco's application portal Learn More

Department: Human Services Agency
Job class: 1823-Senior Administrative Analyst
Salary range: $115,934.00 - $140,894.00
Role type: Permanent Civil Service What does this mean?
Hours: Full-time
Exam type: Position Based Test
Rule: Rule of 10 What does this mean?
List type: Combined Promotive and Entrance
 

About:

This is a Position-Based Test conducted in accordance with CSC Rule 111A.

At the San Francisco Human Services Agency, we believe in a San Francisco where everyone has the opportunity and support to achieve their full potential.  We are comprised of the Department of Benefits and Family Support, and the Department of Disability and Aging Services, and are united by our commitment to deliver essential services that support and protect people, families, and communities.

From financial, nutritional and employment support to child and adult protective services, health care coverage, affordable childcare, and in-home services for older adults and persons with disabilities, our team lends support for all in need.

Our Commitment to Racial Equity

As we work towards our vision of an inclusive San Francisco, we embrace our responsibility to root out systemic racism by creating services and a workforce which reflect the lived experiences and strengths of the people we serve. We are committed to fostering a work environment where our differences are celebrated and everyone has what they need to thrive--no matter their race, age, ability, gender, sexual orientation, ethnicity, or country of origin. Click here to learn more about what this commitment looks like in action.

Role description

The Analyst will monitor and measure disproportionality, disparate impact, evidence of bias, and diversity across the Agency. This position will gather and analyze racial equity data and track the Racial Equity Action Plan indicators to ensure the Agency stays accountable, demonstrating the effectiveness of its equity initiatives. This position will also standardize best practices for robust data collection, analysis methods, presentation of data, and ensuring accurate insights to mitigate bias in data. A successful candidate will have advanced knowledge of Microsoft Excel, proven experience using data visualization software, and the ability to quickly analyze and succinctly summarize the information.

ESSENTIAL TASKS & DUTIES

According to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job class and are not intended to be an inclusive list; may include additional duties as assigned.

  1. Perform complex data and programmatic analysis to identify the needs of the Human Services Agency’s clients and the intersection between various programs.
  2. Utilize analytical programs like Microsoft Excel, PowerBI, Stata, and Tableau.
  3. Develop actionable recommendations for programmatic and policy decisions by agency leadership.
  4. Coordinate project teams spanning programs, divisions, and agencies to lead strategic initiatives.
  5. Develop shared project goals across stakeholders and ensure successful implementation of policy and operational changes.
  6. Create detailed work plans for program reform and improvement.
  7. Conduct studies and evaluations to inform departmental and City policies.
  8. Plan and execute qualitative research methodologies such as surveys, focus groups, and interviews.
  9. Integrate quantitative and qualitative research findings to incorporate staff and client input into projects.
  10. Prepare data and program information to support the development of legislative proposals.
  11. Aim to enhance the efficacy of social service programs and improve client experience.
  12. Present findings through written narrative reports, data dashboards, and presentations.
  13. Tailor materials for various audiences, including agency leadership, staff, clients, elected officials, and the general public.
  14. Support the development of regular reports required by local, state, and federal regulations.

How to qualify

  1. Education: Possession of a baccalaureate degree from an accredited college or university;

AND

  1. Experience: 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.

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

Education Substitution: 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.

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

Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process.

Verification of Education and Experience:
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.

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.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application.

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

SELECTION PROCEDURES:

Written Core Examination: (Weight 40%)

Candidates who meet the minimum qualifications 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.

A passing score must be achieved on the Written Core Examination in order to move forward in the hiring process.

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 and 1822 Administrative Analyst. Therefore 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.

For your reference, a Multiple-Choice Test Preparation Manual is available on the DHR website: http://www.sfdhr.org/modules/showdocument.aspx?documentid=18426.

Supplemental Questionnaire Examination: (Weight: 60%)

Candidates who meet the Minimum Qualifications and pass the Written Core Examination will be invited to take the Supplemental Questionnaire Examination; this exam is designed to measure knowledge, skills and/or abilities in job-related areas which may include but not be limited to: knowledge of core principles of racial equity; knowledge of and ability to project management; ability to establish and maintain effective working relationships; ability to identify, analyze and report upon activities, issues, and problems and recommend appropriate solutions; knowledge of laws and regulations pertaining to target population or industry. All responses to the Supplemental Questionnaire are subject to verification and should be consistent with the information provided in your application.

Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.

Passing score must be achieved on the Written Core Examination and the Supplemental Questionnaire Examination in order to continue in the selection process.

Candidate exam responses will be vetted as appropriate using AI use detection software. Evidence of use of AI, plagiarized answers, or falsified information in exam responses will be addressed in accordance with Civil Service Rules related to fraud and cheating.

The above test components are considered standardized and, therefore, test questions and answers are not available for public inspection or review.

After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:

Minimum Qualification Supplemental Questionnaire (MQSQ): Candidates will be required to complete a MQSQ as part of the employment application. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQ) for this position. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications.”

What else should I know?

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 of six (6) months and may be extended with the approval of the Human Resources Director.

To find Departments which use this classification, please see https://sfdhr.org/sites/default/files/documents/Forms-Documents/Position-Counts-by-Job-Codes-and-Department-FY-2022-23.pdf.

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:

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

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. 

Exam Analyst Information: If you have any questions regarding this recruitment or application process, please contact the exam analyst Vanessa Quintano by telephone (415) 557-5896 or by email at vanessa.quintano@sfgov.org

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.