1070 Logical Data Warehouse and Governance Project Director

Recruitment #PBT-1070-099266

Introduction

1070 Logical Data Warehouse and Governance Project Director

This is a Position-Based Test (PBT) conducted in accordance with Civil Service Rule 111A.

This recruitment may close at any time, but no sooner than October 31, 2019 at 5:00 p.m. Interested applicants are encouraged to apply immediately.

The announcement was amended to reflect a change in the selection procedure.

General Job Description:

The San Francisco Department of Public Health (SFDPH) has the mission to protect and promote the health of all San Franciscans.  SFDPH provides direct services at Zuckerberg San Francisco General Hospital, Laguna Honda Hospital, Population Health clinics, Jail Health, community behavioral health and a network of primary care health centers across the city.  Critical to the delivery of care, population health surveillance and healthcare outcomes for vulnerable populations are robust data platforms, comprehensive analysis and agile reporting.

The Logical Data Warehouse and Governance Director will manage the acquisition and implementation of a logical data warehouse (LDW) for SFDPH.  This position will be responsible for management of vendors for the LDW.  This position supervises a data architect and analyst responsible for master data management to support of a comprehensive reporting environment.  The LDW will integrate data from legacy systems, Epic, Maven and other clinical or health surveillance applications.   This platform will be used to support clinical operations, predictive analytics for patient outcomes, regulatory mandates and research needs.  Working under the direction of the Metrics, Analytics and Data Integration Director, this position supports SFDPH information governance initiatives, enhances data analytics for the organization and builds a robust data catalogue.  The position will work closely with population health, acute care, long term care and ambulatory services across SFDPH.  In addition, this position will work with other City agencies to share and validate data across departments to better serve vulnerable populations.

Essential Duties:
The Logical Data Warehouse And Governance Project Director performs the following essential job functions:

  • Involved with the RFP and acquisition of components for a logical data warehouse;
  • Lead master data management efforts and reporting standardization;
  • Serve on the informational governance council and data analysis workgroups;
  • Direct integration efforts of archived and production data with appropriate documentation;
  • Participate in development of policies and standard work for SFDPH Information Systems to better meet business needs;
  • Work closely with other Information Systems teams to maintain/enhance technical infrastructure, improve cyber security and analysis tools;
  • Participate with other workgroups to enhance functionality, improve analysis capabilities and data quality from clinical applications;
  • Provides the link between the technical and business views of the system by ensuring that the technical solutions being developed will satisfy the needs of the business;
  • Mentor and assist in training initiatives to develop staff;
  • Performs estimates for application functionality enhancements requests.

The 1070 Logical Data Warehouse and Governance Project Director also performs other related duties as required.

 

 

 

 

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: 
Seven (7) years of experience in system administration, information systems development, maintenance and support, or information technology project management, including two (2) years of supervisory experience.

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 used to identify job finalists at the end of the selection process when candidates are referred for hiring.

- Experience in complex healthcare reporting environment
- Experience with various database platforms and tools
- Epic Clarity Certification (or complete within 6 months of hire)
- Experience reporting from Epic, Cerner Invision or  eCW
- Knowledge of LEAN fundamentals including, but not limited to, A3 thinking, Value StreamMapping and Kaizen events
- Knowledge of applicable federal, state, local, and private laws and regulations in relation to the processes of the area of purview and electronic health records

Verification of Experience: http://sfdhr.org/getting-job#verification
Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process.

Verification of Education: If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at http://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.

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, @famsf.org, @ccsf.edu).

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 HR Analyst, Patrick Cheng, by telephone at 415-554-2919, or by email at Patrick.Cheng@sfdph.org.

Selection Procedures

Supplemental Questionnaire (Weight: Qualifying): Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application. The Supplemental Questionnaire is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications for this position.

Performance Exam: (Weight: 100%): Qualified candidates will be sent a Performance Exam that must be completed by the set date. Candidates will be evaluated on their relative knowledge, skill and ability levels in job-related areas including, but not limited to:

- Ability to integrate data from different sources
- Knowledge of common EHR reporting platforms
- Knowledge of healthcare data


A passing score must be achieved on the Performance Exam in order to be placed/ranked on the Eligible List.

All relevant experience, education and/or training must be included in the application to be reviewed during the scoring process. Candidate responses on the Performance Exam cannot be changed once submitted. Candidates will be placed on the eligible list in rank order according to their final score on the Performance Exam. The 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 Three (3) Scores. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.


Eligible List:
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.

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

Note on ICARE: Willingness to uphold/abide by ZSFG’s ICARE (I-Introduce, C-Connect, A-Ask, R-Respond, E-Exit) philosophy for employee and patient interactions: https://zuckerbergsanfranciscogeneral.org/about-us/.

Note on Electronic Health Record (EHR):
The Department of Public Health (DPH) is implementing a unified Electronic Health Record (EHR) system and DPH employees must demonstrate competency in the use of the system that is appropriate for their classification as a condition of employment.

Note on Personal Protective Equipment (PPE):

Some positions in the Department of Public Health will require the use of personal protective equipment (PPE), including but not limited to gloves, gowns, eye and face protection, and face-fitting respirators. The requirement for the use of PPE may come on short or no notice. Facial hair or any condition that interferes with a face-fitting respirator’s seal (i.e. comes between the sealing surfaces of the respirator and the wearer’s bare skin) is not permitted when face-fitting respirators are worn, including during initial or periodic respirator fit-testing. Employees who choose not to shave and do not have either American Disabilities Act (ADA) or Equal Employment Opportunity (EEO) Accommodations do not have the right to alternate work assignments or the option of using a loose-fitting Powered Air Purifying Respirator (PAPR) in place of a Face Fitting Respirator.

Medical Examination/Drug Testing:
Prior to appointment, at the Department's expense, applicants may be required to take a tuberculosis (TB) screening test, a medical examination and/or drug test.

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 can be found at: http://www.sfdhr.org/index.aspx?page=20

Copies of Application Documents: http://sfdhr.org/getting-job#copies

Right to Work: http://sfdhr.org/getting-job#identification

Information on requesting a reasonable ADA Accommodation:
http://www.sfdhr.org/index.aspx?page=20#applicantswithdisabilities

Information regarding requests for Veterans Preference can be found at:
http://www.sfdhr.org/index.aspx?page=20#veteranspreference

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

Exam Type: CPE
Issued: October 11, 2019
Micki Callahan
Human Resources Director
Department of Human Resources
Recruitment ID Number: PBT-1070-099266
DPH/PC/415-554-2919

 

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