IS Business Analyst - Senior - SFPUC (1053) (151096) - San Francisco Public Utilities Commission

Company Description

• Application Opening: 11/21/2024
• Application Filing Deadline: 12/6/2024
• Annual Salary: $125,086 - $157,378
• Recruitment ID: Eligible List ID151096, REF44684H
• This is a Position-Based Test conducted in accordance with CSC Rule 111A.

WHO ARE WE?

San Francisco Public Utilities Commission (SFPUC)

Headquartered in San Francisco, we have 2,300 employees operating across eight counties serving more than 2.7 million customers in the San Francisco Bay Area - 24 hours per day, 365 days per year.

Our Mission: To provide our customers with high quality, efficient, and reliable water, power, and wastewater services in a manner that values environmental and community interests and sustains the resources entrusted to our care.

Our Vision: We are an innovative utility leader, recognized for excellent results in service, safety, stewardship, and inclusiveness.

We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. To learn more about our organization, please visit our website at sfpuc.gov.

We are proud of our infrastructure and programs, but most importantly, we value our highly qualified and dedicated workforce which ensures that this vision becomes a reality.

To learn more about working at the SFPUC, visit our career site at sfpuc.gov/about-us/careers-sfpuc.

ABOUT CITY DISTRIBUTION DIVISION

The San Francisco Public Utilities Commission's City Distribution Division (Water Department) is responsible for directing approximately 322 employees in the operation and maintenance of the water distribution system within the City and County of San Francisco. These activities include, but are not limited to: operating and maintaining 28 pump stations, 11 reservoirs, 13 storage tanks, and 19 regulators, as well as other ancillary appurtenances and equipment; installing, repairing and maintaining over one thousand miles of water distribution mains including service connections and meters; four water systems comprised of the Potable, Emergency Fire Water System (EFWS), Recycled and Groundwater; engineering and designing new main and feeder extensions; managing over 1,000 acres of city owned property and rights-of-ways; and responding to all two-alarm or greater fires to assist the Fire Department in maintaining adequate water volume and consistent pressure while fighting fires.

Job Description

The division is looking for Senior IS Business Analysts that work effectively with a wide range of operations personnel, including field staff and administrative professionals. The candidates should be creative problem solvers who can analyze and document current processes and identify the needs of business users, and must show interest and motivation to contribute to the division's growth by utilizing technology. Key responsibilities include business intelligence reporting solutions, implementing KPI dashboards, and optimization of database systems use. The ideal candidate will demonstrate strong data analysis proficiency, experience with major database platforms, and expertise in reporting tools while meeting the division's operational goals. The role requires motivation to drive technological growth, with expectations to improve reporting efficiency and implement system enhancements and interfaces.

The essential job functions may include, but are not limited to:

• Creates and manages reports through multiple platforms including Cognos and other business intelligence tools for operational and financial analysis and tracking KPI's.
• Facilitates and conducts business requirements gathering and conducts analysis workshops; develops business process diagrams and documentation.
• Performs data analysis across enterprise systems including IBM Maximo Computerized Maintenance Management System (CMMS), Customer Care and Billing (CC&B)/Customer Cloud Service (CCS) Oracle, Peoplesoft Financial Management, SharePoint, and other platforms.
• Writes technical specifications by acquiring knowledge from subject matter experts and translating into functional solutions.
• Develops and executes system and user acceptance test plans; provides user training and support.
• Identifies opportunities for process automation; assists in proposal development for new systems.
• Provides technical support across various platforms; troubleshoots system issues.
• Coordinates with vendors and contractors on projects and service requests.
• Performs data normalization and conversion between platforms; generates routine and ad hoc reports.
• Supports development and testing of system interfaces, mobile solutions, and application customizations.

Nature of work: 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.

Qualifications

If you are interested in this job, we are looking for people that have the following minimum qualifications:

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

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

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

Desirable Qualifications:

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

• Experience with PeopleSoft Analytics or similar financial database system that uses business intelligence reporting software.
• Experience working with a CMMS and related reporting software.
• Ability to communicate effectively with personnel with varying levels of computer proficiency, skill sets, crafts, and administrative professionals.
• Knowledge of mobile workforce solutions and implementations.
• Experience working in a utility or government setting.

Verification:

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 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. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications. Resumes will not be accepted in lieu of a completed City and County of San Francisco application. Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

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 a 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 Examination (Weight 100%)

The Supplemental Questionnaire is an exam and contents will be evaluated and scored. The purpose of the Supplemental Questionnaire Exam is to evaluate the experience, knowledge, skills, and abilities that candidates possess in job-related areas which have been identified as critical for this position. These may include but are not limited to:

• Knowledge of water system-related assets such as water transmission lines, appurtenances, valves, service connections, hydrants, meters, pump stations, etc.
• Knowledge of Computerized Maintenance Management systems such as Maximo or Cityworks, including CMMS functionality such as setting up service requests and work orders, creating job plans, creating different security roles and start centers.
• Knowledge of system integrations using different interfacing methods such as APIs, flat file transfers, etc.
• Knowledge of Business Intelligence software systems such as Cognos reporting.
• Ability to assist in development and implementation of business processes and functional requirements for IT systems.
• Ability to lead technical tasks with coordination and support from non-technical stakeholders and various levels of SMEs.
• Knowledge of development, training, and implementation of mobile applications.
• High level of ability to perform data analysis including but not limited to use of advanced excel features.
• Excellent team player with good inter-personal, communication and technical writing skills.
• Knowledge of business process flow diagramming, preferably using Microsoft Visio.
• Troubleshooting skills - analyze and resolve system and technical issues.

Candidates will be placed on the eligible list in rank order according to their final score. Candidate scores on this examination may also be applied to other announcements involving other job titles when directed by the Human Resources Director. The department may administer additional position-specific selection procedures to make final hiring decisions.

Additional Information

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 twelve months and may be extended with the approval of the Human Resources Director. To find Departments which use this classification, please see Annual Salary Ordinance Level Chart - Budgeted Position Counts by Job Code and Department.

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

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit careers.smartrecruiters.com and begin the application process.

• Select the "I'm Interested" button and follow instructions on the screen.

Applicants may be contacted by email about this recruitment and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date. Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter. To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu, @smartalerts.info, and @smartrecruiters.com).

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.

Having trouble?

If you are having trouble with the application, please visit SmartRecruiters FAQs or email supportfeedback@smartr.me. SmartRecruiters recommends using Google Chrome or Microsoft Edge web browser to submit your application.

Exam Analyst Information: If you have any questions regarding this recruitment or application process, please contact David Jung at DJung@sfwater.org.

Please note: all your information will be kept confidential according to EEO guidelines.

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.