IS Business Analyst-Principal

The Department of Public Health’s Information Technology Department 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.

Our mission-driven and dynamic team is seeking a results-driven, positive, and accountable professional to join the Cloud Collaboration Solutions (CCS) Team as a Principal IS Business Analyst. The team is responsible for managing the department’s collaboration tools such as Microsoft SharePoint, Microsoft Teams, Microsoft Power Platform applications, managing web services, managing enterprise cloud tools such as Box.com, and for managing healthcare data management systems. Under general direction, the Principal IS Business Analyst reports to the Director of the Cloud Collaborations Solutions team.

Essential Duties:

• Manage or contribute to Special Projects for the Cloud Collaboration Solutions Team.
• Develop project plans configurations and process flows. Create and maintain system documentation and customer training materials. Present these materials to a variety of DPH stakeholders.
• Utilize Microsoft SharePoint Online and the Microsoft Power Platform (Power BI, Power Apps, Power Automate) to help solve complex problems. Build and implement solutions that utilize these technologies to capture data, analyze data, and automate business processes, and notifications.
• Provide administrative oversight of the On-premises Data Gateway. Develop documentation and user guidance on access to (and proper usage of) the On-premises Data Gateway with focus on connection management, efficiency, and security.
• Provide administrative oversight of Power BI workspace provisioning and usage. This includes a thorough understanding of workspace types, permissions, user account permissions, licensing, and usage of the On-prem Data Gateway (if required).
• Oversee SharePoint Online site provisioning, content migration, and site enhancements.
• Manage the Box environment and provide customer consultation and project development as appropriate.
• Oversee and provide production assistance and project consultation to members of the CCS Team. May supervise Business Analysts and Programmer Analysts within the assigned work unit or jointly with other units.
• Create, track, update, and resolve ServiceNow tickets as needed.
• Work closely with other OCIO staff in SharePoint Online site design, content management and administration duties as required.
• Provide excellent customer service to our staff and maintain positive collaboration with team peers and everyone within DPH.

The 1054 IS Business Analyst-Principal also performs other related duties as required.

Requirements

Minimum Qualifications - Required

**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:**Five (5) years of experience in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

AND

**EXPERIENCE:**Five (5) years of experience working in Healthcare Information Technology

AND

**EXPERIENCE:**Five (5) years of experience in MS SharePoint Design and development

AND

**EXPERIENCE:**Three (3) years of experience in information system business process design

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.

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

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

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

• Admin-level experience with Microsoft SharePoint Online and SharePoint On-prem at the farm or site collection level.
• Experience developing front-end applications with Microsoft Power Apps.
• Experience developing workflow process with Microsoft Power Automate.
• Experience with Data Analytics and tools such as Microsoft Power BI. Experience with workspace provisioning, troubleshooting, and On-prem Data Gateway creation and administration.
• Experience with On-prem or cloud SQL server databases.
• Experience with M365 applications such as Teams, Planner, Lists, Visio, and Project.

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.

Additional Information

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) (Weight: Qualifying): 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.

Assessment Component
Candidates that meet the minimum qualifications will be invited to participate in Supplemental Questionnaire exam that is designed to measure the knowledge, skills, and abilities in job related areas which may include but not be limited to:

Supplemental Questionnaire Examination (Weight: 100%): 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.

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

Additional information

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, Herbert Chau at[email protected]or (628) 271-6707.

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.