IS Business Analyst-Principal (1054) (127485)

San Francisco, CA, United States

Company Description

Application Opening: 01/22/2024

Application Filing Deadline: 01/29/2024

Annual Salary: $142,714 - $203,138

Recruitment ID: Eligible List ID – 10523, RTF Code ID - RTF0127484

This is a Position-Based Test conducted in accordance with CSC Rule 111A.

WHO WE ARE

We are the 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.

More About SFPUC:

We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. 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. As you explore career opportunities with us, download our career guide and learn about what you can expect during the hiring process.

Job Description

About the 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, 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.

Role Description:

This is a permanent, full-time position with the Asset Management Services unit at the San Francisco Public Utilities Commission’s City Distribution Division (CDD). Under the direction of the Asset Management Services Manager, the Principal IS Business Analyst will research, develop, and implement technology improvements in coordination with supervisors, managers, business professionals and field operations and maintenance personnel. The ideal candidate must have the ability to manage other business professionals and clerical staff and provide technical leadership of projects involving complex and highly analytical tasks. Duties include preparing and managing budgets and scopes of work with staff and consultants, analyzing the organization’s business model, documenting current business processes, and developing standard operating procedures. The candidate will be working with other SFPUC departments and City agencies to improve existing database interfaces and should have the ability to develop new approaches and solutions outside of existing theories and principals.

Essential Functions:

Identifying opportunities for improvements in business processes through automation; make recommendations for new procedures and applications.

Planning and implementing continual improvements to enhance, automate, and error-proof the functionality of applications and systems.

Working with business users to develop business requirements for new systems and propose enhancements to existing systems.

Preparing cost estimates and schedules for database systems modifications; setting scope, boundaries and objectives for system functions and interfaces based on the department’s needs.

Defining system requirements; designing, coding, testing, and debugging systems.

Training end users on new applications and version upgrades.

Documenting configurations and process flows; maintaining and updating system documentation.

Evaluating software and hardware products on multiple platforms; making recommendations for compatibility based on user requirements and systems analysis.

Reviewing functional designs to ensure they encompass user needs and cross module integrations points and testing.

Documenting and analyzing historical performance and market trends.

Creating statistical analysis tools and dashboards to report key performance indicators related to the department’s operations and maintenance activities.

Providing technical support to implement electronic data collection tools and business process improvements.

May supervise Business Analysts, Programmer Analysts, technical, clerical and other functional staff in the assigned work unit; or as a Project Leader, coordinate a team of workers which may include professional, technical and/or clerical staff within the assigned work unit or jointly with other units.

Other tasks as assigned.

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

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.

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 ten (10) semester / fifteen (15) quarter units in one of the fields above.

Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

Special Conditions:

One (1) year of recent and verifiable professional experience configuring, interfacing, testing, and reporting from Computerized Maintenance Management Systems (CMMS) systems used for Asset and Work management.

Two (2) years of experience in design, development, and implementation of business intelligence and analytics solutions

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

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

Project management, functional, technical, or operational support of the following computer-based systems: IBM Maximo Computerized Maintenance Management System (CMMS), Cognos, Oracle Customer Care and Billing (CC&B) or other Customer Information System (CIS), ESRI Geographic Information System (GIS), Peoplesoft financial systems software and business intelligence reporting tools, Supervisory Control and Data Acquisition (SCADA).

Knowledge of mobile data collection platforms, technologies, and interfaces.

Experience working in a utility or government setting.

Knowledge of linear and vertical water utility assets and equipment, such as pipelines, pumps, motors, valves, meters, hydrants, reservoirs, tanks, instrumentation and monitoring equipment and controls.

Two (2) years of supervisory experience.

Verification of Education and Experience:

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 how-to-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 PROCEDURE

Applicants will be required to complete both a Minimum Qualifying Supplemental Questionnaire (MQSQ) and a Supplemental Questionnaire (SQ) Exam. Both sections must be completed by the application deadline. The MQSQ will determine if applicants meet the minimum qualifications for the position. The information provided on the qualifying questionnaire must be consistent with the information on the application and is subject to verification.

Supplemental Questionnaire Examination (Weight 100%)

The Supplemental Questionnaire is an exam and contents will be evaluated and scored. 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 and include, but are not limited to: technical skills in GIS and ESRI, knowledge of programming languages, ability to publish services, and supervisory skills.

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. Candidates scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.

Additional Information

Certification Rule: The certification rule for the ranked eligible lists resulting from this examination will be Rule of 7 Scores. The department may administer additional position-specific selection procedures to make final hiring decisions.

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 12 months, and may be extended with the approval of the Human Resources Director. To find Departments which use this classification, please see https://sfdhr.org/sites/default/files/documents/Forms-Documents/Position-Counts-by-Job-Codes-and-Department-FY-2021-22.pdf

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 the posting the correction on the Department of Human Resources website at https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ .

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

Disaster Service Worker

Employee Benefits Overview

Equal Employment Opportunity

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 https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ 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.

If you are having trouble with the application, please visit Smart Recruiter's FAQs or email [email protected]. It is suggested you use Google Chrome or Microsoft Edge web browser to submit the application.

Exam Analyst Information: If you have any questions regarding this recruitment or application process, please contact the exam analyst, David Jung at [email protected] .

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.

#J-18808-Ljbffr