Career Opportunity

Senior IS Business Analyst (1053) SFPUC - WQD

Recruitment: RTF0126512-01070085

Published: February 08, 2023

Accepting applications until: February 22, 2023

Apply using SmartRecruiters, the City and County of San Francisco's application portal.

About:

Amended 2/9/23: Job posting reopened to reflect changes to the Minimum Qualifications/Special Conditions and to broaden applicant pool. Candidates who have previously applied do not need to re-apply. 

• Application Opening: January 11, 2023
• Application Filing Deadline: February 22, 2023
• Analyst Name: Michelle Chee
• Annual Salary: $117,598 - $147,966
• Recruitment ID: 126513 (RTF0126512)

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

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.  We value our highly qualified and dedicated workforce which ensures that this vision becomes a reality. To learn more about our organization, please visit our website at https://www.sfpuc.org/.

Role description

About the Position
Under general direction of the Environmental/Field Services Manager, the IS Senior Business Analyst oversees the more difficult and complex aspects of the systems development cycle, including needs analysis, cost-benefit analysis, structured systems analysis and design, feasibility analysis, technology and software assessment, telecommunications needs analysis, project planning and management, system installation, implementation and testing, conversion to production status, technical and procedural documentation, user training, and post-implementation assessment and administration for Water Quality Division applications and systems. The IS Business Analyst will coordinate system administration and maintenance with the IS Principal Engineer dedicated to support Water Quality Division custom applications.

Essential Duties:

• Identify opportunities for improving Water Quality business processes through automation; assist in the preparation of proposals to develop new systems.
• Analyze data processing for regulatory and project reporting needs; research and evaluate software on multiple platforms to assist users to meet their departmental goals; assist in developing the evaluation criteria for software.
• Determine operating characteristics and requirements for Water Quality sample monitoring and cross connection control program; develop or modify and document general system design; write detailed design specifications; conduct "walkthroughs" for proposed solutions to system problems.
• Analyze the feasibility of and develop requirements for new systems and enhancements to existing Water Quality systems and applications; ensure the system design fits the needs of the users.
• Install and enhance software; program, test, debug and install new/modified programs.
• Consult on the analysis of Water Quality applications and systems; troubleshoot system problems; implement solutions.
• Conduct system analysis to evaluate Water Quality reporting requirements and may conduct programming activities for complex systems; document new and modified systems and programs; coordinate user training in new capabilities; may convert new programming from test to production.
• Interface with stakeholders to determine system needs and requirements; instruct users on newly implemented systems; define system requirements; may design and code programs; review impact of system modifications on existing systems.
• Prepare, or assist client in preparing, service requests to implement system changes; determine level of effort required and the cost of implementing service requests; prioritize requests.
• Provide technical production support for on-line and batch systems; assist with set processing schedule; update and produce reports.
• Coordinate with outside vendors and contractors to complete projects and service requests; define, assign and evaluate their work.Determine structure of databases; normalize data; perform conversion of data between platforms; design, develop and generate routine and ad hoc reports in response to stakeholder needs.
• Determine security levels for systems to ensure data integrity; test database applications to assure functionality and effectiveness in performing to desired specifications.
• Perform other related duties as required.

How to qualify

• Education: An associate degree in 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 computer science or a closely-related field]; AND
• 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 computer science or a closely related field.
One year of full-time employment is equivalent to 2000 hours. (2000 hours of qualifying work experience is based on a 40-hour work week.) Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time employment.

Special Condition (also minimum qualification):

• Three (3) years of IT Project Management Experience
• Two (2) years of Utility Software Experience 

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.

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

Verification of Education and Experience:
Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.  Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment process. For education verification information, including verifying foreign education equivalency, click HERE. 

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

What else should I know?

How To Apply
Applications for City and County of San Francisco jobs are only accepted through an online 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). 

It is highly recommended that all work experience, education, and other information is written in your SmartRecruiter application and not just as attachments.  Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

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 supportfeedback@smartr.me.  It is suggested you use Google Chrome or Microsoft Edge web browser to submit the application.  

EXAM INFORMATION
Exam Type: Permanent Based Test
Eligible List Type: Combined Promotive/Entrance
Certification Rule: Rule of the Seven
Eligible List Duration: 12 months
The duration of the eligible list may be extended with the approval of the Human Resources Director. 

Selection Procedures
After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:

1. Minimum Qualification Supplemental Questionnaire (MQSQ) completed online (Qualifying)
2. Online Supplemental Essay Exam (100%)

Minimum Qualification Supplemental Questionnaire (MQSQ)
Once the application period is closed, qualified candidates will be sent a Minimum Qualification Supplemental Questionnaire (MQSQ) to complete.  

Supplemental Questionnaire Essay Exam (100%)
The purpose of the Supplemental Questionnaire (SQ) 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: knowledge of utility software and applications, project management skills, technical skills, IT analytical skills, and communication skills.  

Qualified candidates will be sent email notices to complete the MQSQ and SQ exam. Failure to complete these steps by the established deadlines will result in disqualification. 
A passing score must be achieved on the exam to be placed on the eligible list and continue in the selection process.  Additional selection processes, like interviews, may be conducted by the hiring department prior to making final hiring decisions.

Score Report/Eligible List
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. 
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."

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

• Copies of Application Documents
• Conviction History
• Disaster Service Worker 
• Diversity/Equal Employment Opportunity
• Employee Benefits Overview
• Information About the Hiring Process 
• Reasonable Accommodation
• Right to Work
• Seniority Credit in Promotional Exams
• Veterans Preference

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

All your information will be kept confidential according to EEO guidelines.

If you have any questions regarding this recruitment or application process, please contact the exam analyst, Michelle Chee by email at mchee@sfwater.org.

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

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.