1052 IS Business Analyst - Data Analyst
|Department||Public Utilities Commission|
|Date Opened||12/4/2019 4:00:00 PM|
|Filing Deadline||1/14/2020 5:00:00 PM|
|Salary||$43.31 - $54.48/hour; $7,508.00 - $9,442.00/month; $90,090.00 - $113,308.00/year|
|Job Type||Permanent PBT|
12/31/2019 - AMENDED TO REFLECT CHANGES TO THE MINIMUM QUALIFICATIONS. THOSE THAT HAVE APPLIED NEED NOT TO REAPPLY
This is a Position-Based Test conducted in accordance with CSC Rule 111A.
Headquartered in San Francisco, we have 2,300 employees working in seven counties with a combined annual operating budget of over $900 million.
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.
We are an innovative utility leader, recognized for excellent results in service, safety, stewardship, inclusiveness and commitment to the environment. To learn more about our organization, please visit our website at .
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.
The San Francisco Public Utilities Commission (SFPUC) is seeking an experienced, outgoing and motivated business analyst to provide functional and technical support for data analysis. Under the general direction of the BI Manager, the IS Business Analyst will be responsible for data analysis using IBM Cognos as well as geospatial data analysis using ESRI software. Candidate should be well versed in SQL and have experience with web technology, as this role will be responsible for building and maintaining reports using IBM Cognos and Creating and maintaining GIS dataset using ESRI software.
• Provide technical knowledge for projects involving complex analytical tasks.
• Provide ad-hoc data and reporting, using SQL, PL/SQL and Cognos.
• Provide support for maintaining GIS data using ESRI software.
• Conduct technical analysis and some basic programming activities.
• Gather business requirements and transform them into design documents for technical staff.
• Partner with business on testing and training of new technologies or changes to existing processes and systems.
• Create test scenarios, test cases, UAT scripts, and other testing documentation to assist with testing.
• Perform other related duties, as assigned.
Equal Employment Opportunity:
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.
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].
One (1) year in the information systems field, including technical support, content management, administration of network applications or system analysis.
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.
1. Six (6) months of experience of design and configuration in IBM Cognos
2. Six (6) months of GIS Application and Tools Experience
3. One (1) year of SQL Query Experience
The above minimum qualifications reflect special conditions associated with the position to be filled. They may differ from the standard minimum qualifications associated with this classification.
• Ability to facilitate requirements gathering and create technical design documents.
• Proficient with SQL, PL/SQL and reporting.
• Some knowledge of ESRI GIS systems and geospatial data.
• Excellent written and verbal skills in expressing ideas, policies, and technical issues with sharp business acumen.
• Basic web programming knowledge.
• Some experience with delivering classroom Training.
• Strong independent work ethic with ability to work well in teams with diverse personalities.
Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted. All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included in the “Education” and “Training and Employment Record” sections of the City and County of San Francisco online application by the filing deadline. A resume does NOT substitute for this section of the City application and will not be considered in determining whether you meet the minimum qualifications.
Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process.
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.
If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at http://sfdhr.org/index.aspx?page=456.
Verification of required work experience typically must be on the employer’s letterhead, and must include the applicant’s name, job title, description of job duties, dates of employment, hours per week, and signature of the employer, supervisor, or appropriate representative.
Employees of the City and County of San Francisco may submit performance evaluations showing duties performed to verify qualifying City experience. City employees will receive credit for the duties of the class to which appointed. Credit for experience obtained outside of the employee's class will be allowed only if recorded in accordance with the provisions of Civil Service Commission Rules. CCSF employees will not receive credit for experience obtained outside of their classification unless recorded in accordance with the provisions of the Civil Service Rule 110.9.1/111A.11.2.
Experience claimed in self-employment will only be accepted if supported by documents verifying income, earnings, business license and experience comparable to minimum qualifications above. Copies of income tax papers or other documents listing occupation and total earnings must be submitted.
Verification of required valid licensure/certification typically must be a photocopy of the license/certificate including the name of the issuing agency as well as the name of the license/certificate holder, license/certificate number, and expiration date.
How To Apply
Applications for City and County of San Francisco jobs are only accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.
· Select the desired job announcement
· Select “Apply” and read and acknowledge the information
· Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
· Follow instructions on the screen
Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.
Applicants may be contacted by email about this announcement 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).
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.
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.
Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.
If you have any questions regarding this recruitment or application process, please contact the exam analyst, Michelle Chee, by telephone at (415) 554-1622, or by email at MChee@sfwater.org.
Applicants will be prompted to complete a Minimum Qualifying Supplemental Questionnaire (MQSQ) as part of the online application process and 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.
Oral Examination (Weight 100%)
Candidates who are minimally qualified will be invited to participate in an oral exam. The purpose of the Oral 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 ESRI GIS systems, SQL PL/Analytics, Cognos, overall analytical ability, and interpersonal 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.
The certification rule for the ranked eligible lists resulting from this examination will be Rule of 3 Scores. The department may administer additional position-specific selection procedures to make final hiring decisions.
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 6 months, and may be extended with the approval of the Human Resources Director.
Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list/score report resulting from this announcement may be used by other departments that also use this classification or a similar classification. To find other Departments which use this classification, please see https://sfdhr.org/sites/default/files/documents/ASO-Level-Chart.pdf?documentID=21246.
As a selected candidate for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a selected candidate. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:
- Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
- Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.
Having a conviction history does not automatically preclude you from a job with the City.
If you are a selected candidate, the hiring department will contact you to schedule a fingerprinting appointment.
Disaster Service Workers
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 www.jobaps.com/sf.
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.
Reasonable Accommodation Request: Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at: http://www.sfdhr.org/index.aspx?page=20#applicantswithdisabilities
Veteran’s Preference: Information regarding requests for Veterans Preference can be found at: http://www.sfdhr.org/index.aspx?page=20#veteranspreference
Seniority Credit in Promotional Exams: Information regarding requests for seniority credit can be found at: http://www.sfdhr.org/index.aspx?page=20#senioritycredit
General Information concerning City and County of San Francisco Employment Policies and Procedures: http://www.sfdhr.org/index.aspx?page=20
Copies of Application Documents: http://www.sfdhr.org/index.aspx?page=20#copies
Right to Work:http://www.sfdhr.org/index.aspx?page=20#identification.
All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.
DRUG TESTING REQUIREMENT: Applicants for positions in this classification who are not currently employed by the City and County of San Francisco in a safety-sensitive position represented by (include the specific union name), are required to pass pre-employment drug and alcohol testing. All employees in this classification may also be subject to drug and alcohol testing upon reasonable suspicion or after a work-related accident. Applicants with a positive result from a pre-employment drug test will be restricted from hire in safety-sensitive positions for six-months after the date of the positive test.
Exam Type: CPE
Issued Date: December 4, 2019; AMENDED 12/31/2019
Micki Callahan, Human Resources Director
Department of Human Resources
Recruitment ID: PBT-1052 097286
All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.