This is a Temporary Exempt, full-time position not to exceed three (3) years. This position is excluded by the Charter from the competitive Civil Service examination process, is considered "at will" and shall serve at the discretion of the Department Head. If applicable, an exempt employee must participate and be successful in a Civil Service examination process for this classification and be selected through an open competitive recruitment process to be considered for a permanent appointment.

Specific information regarding this recruitment process are listed below:

Application Opening: July 1, 2022
Application Deadline: Interested applicants are encouraged to apply as soon as possible as this announcement may close at any time after 5:00 pm on July 11, 2022
Compensation Range: $117,598 - $147,966  [1053 Compensation & Classification]
Recruitment ID: 

Who We Are

The City and County of San Francisco is the City’s largest employer, with more than 35,000 employees in more than 60 different City departments. 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 include outreach, homelessness prevention, emergency shelter, drop‐in centers, transitional housing, supportive housing, short‐term rental subsidies, and support services to help people exit homelessness.

With mindfulness about the racism and bias that has disproportionately created homelessness among people of color and LGBTQ people, HSH is committed to equity in our Department, systems, and programs. HSH is an equal opportunity employer and does not discriminate based on race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For more information on 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 (HSH), founded in 2016, is a national leader in the movement to end homelessness by developing a coordinated, equity-driven, client-focused system of compassionate services while piloting innovative models and implementing best practice solutions with measurable results. HSH’s Homelessness Response System (HRS) oversees and implements a system of care that serves 14,000 people daily. Major programs include: street outreach and service connection through the Homeless Outreach Team (SFHOT); 3,000-bed shelter system for adults and families, including shelters for members of the LGBTQ community and survivors of domestic violence; Navigation Centers that provide temporary shelter to chronically homeless individuals using a low-barrier entry model; rapid rehousing rental subsidies for families, adults, seniors and transitional aged youth; the Problem Solving/Diversional programs including the Homeward Bound program which has helped 11,000 individuals return to stable housing in their city of origin; and robust supportive housing programs with over 8,000 units which provide permanent housing and services to formerly homeless individuals and families.

What You’ll Be Doing

Under the direction of the lead database administrator, the CalAIM database administrator (DBA) will construct and support a secured CalAIM database infrastructure and a data extraction and delivery pipeline between HSH, Department of Public Health (DPH), and external parties that is in full compliance with federal and city regulations.

Essential duties include but are not limited to:

• Responsible for developing the shorter and long term CalAIM data transport strategies, as well as documenting business requirements including system specifications, workflow diagram and system notes
• Set up data extract, transform and load operation
• Provide consultation to the provider community regarding CalAIM related data fields in the Online Navigation and Entry (ONE) System
• Responsible for providing accurate and complete CalAIM data set to HSH Data and Performance for report and PowerBI dashboard
• In preparation for the CalAIM project, will assist the HSH IT Director to develop HSH’s IT security policies
• Performing other duties as assigned

Minimum Qualifications 

Education:
An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field].

Experience:
Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

Substitution:
Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

Desirable Qualifications

The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring:

• Proficiency with database functionality, SQL and reporting tools
• Knowledge of python/equivalent scripting language

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.

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:
Applications will be screened for relevant qualifying experience. Additional screening mechanisms may be implemented in order to determine the applicants’ qualifications. Only those applicants whose backgrounds best match the position will be invited to participate in the selection process. Applicants meeting minimum qualifications are not guaranteed advancement in the selection process.

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

• Information About the Hiring Process
• Conviction History
• Employee Benefits Overview
• Equal Employment Opportunity
• Disaster Service Worker
• ADA Accommodation
• Right to Work
• Copies of Application Documents
• Diversity Statement

How to Apply

Applications for City and County of San Francisco jobs are only accepted through an online process.

Visit Careers with Purpose | City and County of San Francisco (sf.gov) and begin the application process.

• Select the “Apply Now” 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.

Analyst Information: If you have any questions regarding this recruitment or application process, please contact the exam analyst, Nicole Adriano at [email protected]

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.