Senior IS Business Analyst (1053) - information Systems - san Francisco Health Service System (id#158785)

Sr. Is Business Analyst

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.

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:

• Provide functional expertise on the use of PeopleSoft Benefit Administration module.
• 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.
• Gather business requirements from business partners and develop functional specifications.
• Perform functional testing by creating, maintaining, and executing test scripts and plans.
• Collaborate with the Controller's Office System Division (PeopleSoft) team in resolving system issues, program testing, or other system related matters.
• Collaborate with outside vendors in resolving interface file transmission issues or in relation to any changes with the interface files.
• Produce data extracts and generate reports using PeopleSoft Query Tools.
• Execute production processes. Utilize Oracle SQL Developer and Query Manager.
• May participate and represent SFHSS in meetings with the Systems Division, Payroll (PPSD), or other related departments or committees, as needed.
• Support the implementation of enhancements, new functionality, bug fixes and system upgrades.
• Follow the system development lifecycle, internal policies and procedures.
• Maintaining up-to-date desktop procedures.
• 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.

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

Additional Information Regarding Employment with the City and County of San Francisco:

• Information About the Hiring Process</