Senior IS Business Analyst (1053)-Information Systems-San Francisco Health Service System (ID#158785)

The San Francisco Health Service System (SFHSS) was established in 1937 to provide medical care for municipal employees. SFHSS is responsible for all health benefits administration, including medical, dental, vision, flexible spending accounts (FSA), and a wide array of voluntary benefits for the employees, retirees, and covered dependents of the City and County of San Francisco (CCSF), San Francisco Unified School District, City College of San Francisco, and Superior Court of San Francisco.

Today, we serve over 130,000 employees, retirees, and their covered dependents. The department is comprised of seven divisions: Administration, Finance, Member Services Communications, Enterprise Systems and Analytics (ESA), Contracts, and Well-Being.

SFHSS' Mission

SFHSS is dedicated to ensuring quality and sustainable benefits that enhance the whole-person health and well-being of our members and their families throughout their lifecycles.

One of the most popular tourist destinations in the world, San Francisco is a city of truly international character with an eclectic mix of Victorian and modern architecture and a highly diverse cosmopolitan population. With approximately 810,000 residents in a 47 square mile area, San Francisco is the seventeenth most populous city in the United States and the fourth most populous city in California. The City is an internationally famous tourist destination known for its iconic landmarks like the Golden Gate Bridge, Fisherman’s Wharf and Alcatraz Island, and its diverse culture and arts scene. For the sports fans, San Francisco is home to the Giants and Golden State Warriors, with the 49ers  located nearby in the South Bay and the Golden State Valkyries. With fourteen Fortune 500 companies headquartered in the City, and a large infrastructure of professional services, including law, public relations, architecture, and graphic design, populating downtown, San Francisco is a world-class city. With Silicon Valley nearby, San Francisco has also emerged as a high-profile technology center. The City is home to San Francisco State University with over 23,000 students, the City College of San Francisco, the University of San Francisco, the University of California San Francisco and UC Law San Francisco.

This is a position-based test conducted in accordance with CSC Rule 111A. Learn more about the City’s hiring process here: https://careers.sf.gov/knowledge/process/

Application Opening: Tuesday, August 12, 2025

Application Deadline: The job ad will close at 12:00 a.m. PST on Wednesday, August 27, 2025. Applications must be submitted by 11:59 p.m. on Tuesday 26, 2025

Annual Compensation: $129,506-$162,942

Recruitment ID: PBT-1053-158785

The Sr. IS Business Analyst serves as a key point of contact for internal staff responsible for providing benefits coverage to eligible employees and retirees, including the Member Services and Finance divisions. This position provides complex technical and operational systems support for PeopleSoft Benefits Administration.  In addition to analyzing and resolving user support issues and executing production processes, this role is responsible for documenting, configuring and testing business requirements and writing desktop procedures.

Examples of Important and Essential Duties

1. Provide functional expertise on the use of PeopleSoft Benefit Administration module.
    
2. Serve as a technical resource for users in relation to system functionality; Works with end users in troubleshooting and resolving processing / production issues and/or errors; Researches and evaluates solutions to assist the end user to meet their changing business needs and the goals of the department.
    
3. Gather business requirements from business partners and develop functional specifications.
    
4. Perform functional testing by creating, maintaining, and executing test scripts and plans.
    
5. Collaborate with the Controller’s Office System Division (PeopleSoft) team in resolving system issues, program testing, or other system related matters.
    
6. Collaborate with outside vendors in resolving interface file transmission issues or in relation to any changes with the interface files.
    
7. Produce data extracts and generate reports using PeopleSoft Query Tools.
    
8. Execute production processes.  Utilize Oracle SQL Developer and Query Manager.
    
9. May participate and represent SFHSS in meetings with the Systems Division, Payroll (PPSD), or other related departments or committees, as needed.
    
10. Support the implementation of enhancements, new functionality, bug fixes and system upgrades.
     
11. Follow the system development lifecycle, internal policies and procedures.
     
12. Maintaining up-to-date desktop procedures.
     
13. Perform related duties and responsibilities as assigned.

Essential duties require the following physical skills and work requirements: Some positions may require sufficient strength and coordination for lifting, pushing, pulling and/or carrying the weight of computer equipment. May require hand/eye coordination for semi-skilled movements, such as taking apart casings, installing parts and reconnecting computers and for performing data entry. May involve extensive VDT exposure.

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:

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

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.

• Ability to work on multiple projects simultaneously.
• Experience in PeopleSoft HCM modules (internally branded as SF People & Pay), including Base Benefits, Benefits Administration and Benefits Self-Service Applications.
• Experience administering various benefit plans such as medical, dental, life and disability coverage for large groups over 10k lives.  
• Experience with writing and delivering training to end users.
• Experience using Oracle SQL Developer (or other SQL development tools) and PeopleSoft Query Manager.
• Demonstrated strong analytical, planning, and organizational skills and abilities.
• Proven ability to interact skillfully and tactfully with all levels of staff and management.

Verification of Education and Experience:

Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Review SF Careers Employment Applications for considerations taken when reviewing applications.

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.

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 a MQSQ as part of the employment application at a later time. 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 Evaluation (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.  All candidates’ responses to the Supplemental Questionnaire are subject to verification. All relevant experience, education and/or training must be included in the responses in order to be reviewed in the rating process.

A passing score on the Supplemental Questionnaire must be achieved in order to be placed/ranked on the eligible list.

Eligible List/Score Report:

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.

To find Departments which use this classification, please see Position Counts by Job Codes and Departments..

Terms of Announcement and Appeal Rights:
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.

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

HOW TO APPLY

All job applications for the City and County of San Francisco must be submitted through our online portal. Please visit https://careers.sf.gov/ to begin your application process.

Computers are available for the public (9:00 a.m. to 4: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 and at the City Career Center at City Hall, 1 Dr. Carlton B. Goodlett Place, Room 110.

Ensure your application information is accurate, as changes may not be possible after submission. Your first and last name must match your legal ID for verification, and preferred names can be included in parentheses. Use your personal email address, not a shared or work email, to avoid unfixable issues.

Applicants will receive a confirmation email from [email protected] 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.

If you have any questions regarding this recruitment or application process, please contact exam analyst Lauren Rowe at [email protected]

Recruitment ID: PBT-1053-158785

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.