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

Company Description

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.

Job Description

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.