IS Business Analyst (1052)

The Department of Public Health prioritizes equitable and inclusive access to quality healthcare for its community and values the importance of diversity in its workforce. All employees at the Department of Public Health work to advance equity, inclusion, and diversity with a specific lens and focus on race, ethnicity, gender, sex, sexuality, disability, and immigration status.

INTRODUCTION

Under general direction, the Population Health Applications Analyst oversees most if not all of the various parts of the systems development cycle, including needs analysis, cost-benefit analysis, structured systems analysis and design, feasibility analysis, technology and software assessment, telecommunication needs analysis, project planning and management, system installation, implementation and testing, conversion to production status, technical and procedural documentation, user training, and post-implementation assessment, support and administration; may be the sole MIS resource for an organization with a moderately complex system.

• Application Opening

- June 20, 2024

• Application Deadline

• Application filing will be open continuously at least through June 28 and will close any time thereafter.

• Salary: $106,470.00 - $133,926.00 annually

• Appointment Type: Permanent Civil Service

• Recruitment ID: PBT-1052-144338

The Mission of the San Francisco Department of Public Health (SFDPH) is to protect and promote the health of all San Franciscans. SFDPH strives to achieve its mission through the work of multiple divisions - the San Francisco Health Network, Population Health, Behavioral Health Services, and Administration. The San Francisco Health Network is the City's only complete system of care and has locations throughout the City, including Zuckerberg San Francisco General Hospital and Trauma Center, Laguna Honda Hospital and Rehabilitation Center, and over 15 primary care health centers. The Population Health Division (PHD) provides core public health services for the City and County of San Francisco: health protection, health promotion, disease and injury prevention, and disaster preparedness and response. Behavioral Health Services operates in conjunction with SFHN and provides a range of mental health and substance use treatment services.

Role description

Essential Duties

The Population Health Applications Analyst may perform the following essential Duties (please note that according to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job code/class and are not intended to be an inclusive list.): Serve as IT/MIS application owner for Environmental Health Applications (primarily for the Environmental Health DB (EHD) and other Population Health Applications.

Duties in this role include working with a team of business analysts; maintenance and of the EHD application, coordination of planned downtime events, communication of unplanned downtime events, acting as a liaison between the business and vendor(s) as needed, and other responsibilities required to support the health of the applications.

• Troubleshoot software problems through MS teams and other communication channels; implement solutions and workaround to problems.

• Implement, maintain and update SQL Server and MS Access databases, tables and security access; create, document and compile documentation related to procedures.

• Create and generate reports and statistics to meet user and program requirements; interface with other departments and users on regulations and reporting requests.

• Consult on the analysis of an application; troubleshoot system problems; implement solutions and workarounds.

• Conduct system analysis and may conduct programming activities for complex systems; document new and modified systems and programs; coordinate user training in new capabilities; may convert new programming from test to production.

• Interface with users to determine system needs and requirements; instruct users on newly implemented systems; define system requirements; may design and code programs; review impact of system modifications on existing systems.

• Prepare, or assist client in preparing, service requests to implement system changes; determine level of effort required, prioritize requests.

• Coordinate with outside vendors and contractors to complete projects and service requests; define, assign and evaluate their work.

• Provide application support for other applications that fall under the Population Health umbrella including applications used to support environmental health, pandemic response, case management, and communicable disease surveillance.

• Performs other related duties and responsibilities as assigned.

How to qualify

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

Experience:

One (1) year in the information systems field, including technical support, content management, administration of network applications or system analysis.

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

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

One-year fulltime employment is equivalent to 2,000 hours (2,000 hours of qualifying work experience is based on a 40-hour work week).

Desired Qualifications:

• Experience with environmental health and population health programs

• SQL Server, SSMS experience

• MS Access experience

• PowerBI experience

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 Supplemental Questionnaire (MQSQ):

Candidates will be required to complete an 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.

Supplemental Questionnaire (Weight: 100%)

Candidates who meet the minimum qualifications will be sent a Supplemental Questionnaire. The Supplemental Questionnaire is designed to measure the knowledge, skills and abilities required for this position.

Candidates must achieve a passing score on the Supplemental Questionnaire exam in order 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. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

What else should I know?

Certification

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

Eligible List/Score Report:

Once you pass the exam, you will be placed onto 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 6 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 e-mail 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 the 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, Juan Pablo Gonzalez at juanpablo.gonzalezsa@sfdph.org or (628)-271-7243.

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.