1052 IS Business Analyst (GIS)
|Department||Public Utilities Commission|
|Date Opened||5/17/2021 08:00:00 AM|
|Filing Deadline||6/18/2021 5:00:00 PM|
|Salary||$44.61 - $56.11/hour; $7,733.00 - $9,726.00/month; $92,794.00 - $116,714.00/year|
|Job Type||Permanent PBT|
6/2/2021 Update: Announcement deadline has been extended to 6/11/2021 at 5:00 p.m. to accept more applications
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.
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
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
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-GIS Manager, the data Analyst will be responsible for analyzing the data using ESRI software as well as using BI (Business Intelligence) tool. The candidate should be well versed in SQL and have some experience in python or a similar language. This role will be responsible for creating and maintaining GIS datasets using ESRI software and building and maintaining reports using the BI tool.
- Maintain, update, and support enterprise GIS using ESRI software
- Provide ad-hoc data analysis and reporting, using SQL, PL/SQL, and BI tool
- Conduct technical analysis and some basic programming activities using python or a similar language
- Determine operating characteristics and requirements; develop or modify and document general system; write detailed design specifications
- Maintain and support Extract Transfer Load (ETL) tool
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.
These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification. Please note, additional qualifications (i.e., special conditions) may apply to a particular position and will be stated on the exam/job announcement.
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.
- One (1) year of recent experience in Geographic Information System (GIS) using ESRI products (Arcview, ArcInfo, ArcGIS, MapObjects, ArcIMS) performing analysis, design, development, testing, implementation, and production support for GIS applications.
- One (1) year of recent experience in SQL structured query language to access SQL server databases.
The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.
- Possession of a baccalaureate degree from an accredited college or university in GIS, Geography, Earth Science, Natural Resources, Engineering, Computer Science or a related with major coursework in geographic information systems
- Experience with ArcGIS suite of tools including ArcGIS Desktop and extensions, ArcCatalog, ArcSDE/ ArcGIS Server and ArcGIS Online.
- Experience working with reporting and data analysis
- Experience in some basic programming
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.
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
- Selection either "I am a New User" if you have not previously registered, or "I have Registered Previously"
- Follow instructions on the screen
In line with the Official Public Health Order to slow the spread of COVID-19, “shelter-in-place” has been issued for all San Francisco residents that is expected to be in effect until further notice. As a result, Department of Human Resources (DHR)’s office (located at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103) is currently closed to the general public. If you have any questions, please feel free to email the Human Resources Analyst listed on this announcement.
You may be contacted by email about this announcement and, therefore, it is your responsibility to ensure that your registered email address is accurate and kept up-to-date. Also, you must ensure that email from CCSF is not blocked on your computer by a spam filter. To prevent blocking, you should set up your 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. You will receive a confirmation email that your online application has been received in response to every announcement for which you apply. You should retain the confirmation email for your records. Failure to receive the 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 email at firstname.lastname@example.org and email@example.com.
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
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.
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
Information regarding requests for Veterans Preference can be found at: http://www.sfdhr.org/index.aspx?page=20#veteranspreference
Information regarding requests for seniority credit can be found at: http://www.sfdhr.org/index.aspx?page=20#senioritycredit
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.
Exam Type: CPE
Issued: May, 2021
Carol Isen, Human Resources Director
Department of Human Resources
Recruitment ID: PBT-1052-111559
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.
Click on a link below to apply for this position:
|Fill out the Supplemental Questionnaire and Application NOW using the Internet.|
|View and print the Supplemental Questionnaire.||This recruitment requires completion of a supplemental questionnaire. You may view and print the supplemental questionnaire here.|