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 San Francisco Department of Public Health’s (DPH) Information Technology Division is the technology services provider within Public Health, delivering technology infrastructure and services to approximately 10,000 users within the organization to help support over 100,000 patients annually.

• ✅ START with this Required Questionnaire
  https://forms.office.com/g/i5B7R8FcmT
• Annual Compensation 
  careers.sf.gov/classifications/?classCode=1053
• Position Type
  Permanent Civil Service careers.sf.gov/knowledge/role-types
• Application Deadline
  On or after 5/16/2024

This position focuses on developing and providing technical support on the PowerBI platform for patient care and clinical operations dashboards. Implementing PowerBI across DPH is part of a strategic initiative to make DPH a more data-driven organization. This position will be a technical lead on PowerBI, working with Information Governance, SFDPH IT and PowerBI developers to create standard reporting practices and curated data sets for shared use. In addition, this successful candidate will provide user support and training on the reporting tools within Epic, the primary electronic health system for SFDPH. Another strategic goal is to increase adoption and end-user fluency with the standard Epic self-service reporting tools. With Behavioral Health Services implementing Epic in early 2024, it’s anticipated there will be a focus on PowerBI projects and reporting support for this division. This position will also be involved with supporting the needs for medical service delivery, within both hospitals and ambulatory care divisions. This position is in the Metrics, Analytics and Data Integration (MADI) team. MADI supports data needs for patient care, regulatory requirements, and strategic initiatives across SFDPH. 

Duties Include

Below are examples of essential duties of this position include but are not limited to:

• Serves as a technical lead for PowerBI.
• Participates in workgroups to standardize PowerBI configurations and standards across DPH.
• Develops PowerBI reports and systematizes PowerBI data sources as directed by Information Governance and SFDPH leadership.
• Designs trainings and provides at the elbow support for end users developing in PowerBI.
• Provides trainings on Epic reporting tools for end users.
• Supports clinical areas to adopt Epic reporting tools by creating templates and meeting data requests.
• Contributes to development standards, style guides, data dictionary and other centralized resourcesfor governance and adoption of self-service analytic tools.
• Serves on various Information Governance committees for SFDPH strategic goals of increased access and use of validated data across the organization.

The 1053 Senior IS Business Analyst-Power BI/IG also performs other related duties as assigned.

⚠️Required Before Applying⚠️

Education:

An associate degree in business administration, public administration, information systems, economics, finance, 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 one of the fields above or a closely-related field]; AND

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.
• One (1) year of experience in design, development, and implementation of Business Intelligence and analytics solutions; building data visualizations, dashboards, spreadsheets, and geospatial representations of complex/large datasets for a wide range of audiences.

Educational Substitution

• Additional experience as described above may substitute 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 one of the fields above or a closely related field.
• Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

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

The above minimum qualifications reflect special conditions associated with the position to be filled. They may differ from the standard minimum qualifications associated with this classification.

Desirable Qualifications
These qualifications may be considered at the end of the selection process when candidates are referred for hiring:

• Experience in healthcare
• Experience in Epic, specifically Reporting Workbench and SlicerDicer
• 1 year of experience creating PowerBI reports
• Excellent written and verbal communication skills

Important Note: Please make sure it is absolutely clear in your application exactly how you meet the minimum qualifications. Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. Please be aware that any misrepresentation of this information may disqualify you from this recruitment or future job opportunities.

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

• Minimum Qualification Questionnaire (Weight: Qualifying)
  Along with their application, applicants must complete the Required Questionnaire linked in this job ad, which is designed to compare an applicant's experience with the Minimum Qualifications of this position.
• Examination (Weight: 100%)
  After this job ad is unpublished, qualified applicants will receive an online exam link. The exam evaluates relevant knowledge, ability, and skill level. 
  • Candidates must achieve a passing exam score to continue in the selection process and will be placed on the confidential eligible list in rank order according to their final score.

Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

Certification
The certification rule for the eligible list resulting from this examination will be the Rule of 10 scores.

Eligible List/Score Report
Once you pass the exam, you will be placed on an eligible list and given a score and a rank. For more information, visit https://careers.sf.gov/knowledge/process/

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

How to Apply
Applications for City and County of San Francisco jobs are only accepted through an online process. Visit careers.sf.gov and begin the application process. 

Our email communications may come from more than one department so please make sure your email is set to accept messages from all of us at this link. 

Applicants may be contacted by email about this recruitment therefore, it is their responsibility to contact the Analyst if they update their email address. 

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.

Terms of Announcement and Appeal Rights
This is a Position Based Test (PBT) administered in accordance with Civil Service Rule 111A.

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 posting the correction on the Department of Human Resources website at https://careers.sf.gov/. 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. 

DPH Health Critical Requirements and Information: Please review the following policies regarding DPH employment requirements that safeguard yourself and others. 

• COVID-19 Policies 
• Personal Protective Equipment (PPE)
• Medical Examination Prior to Hiring
• Electronic Health Record (EHR)
• Licensure/Certification/Registration
• Note on ICARE 

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 Workers
• Reasonable Accommodation
• Right to Work
• Copies of Application Documents
• Diversity Statement
• Veterans Preference
• Seniority Credit in Promotional Exams

If you have any questions regarding this recruitment or application process, please contact the analyst, [email protected] 628-271-6704. 

We may use text messaging to communicate with you on the phone number provided in your application. The first message will ask you to opt in to text messaging.

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.