1052 IS Business Analyst
|Department||Recreation and Parks|
|Date Opened||6/6/2019 09:00:00 AM|
|Salary||$86,606.00 - $108,914.00/year|
|Job Type||Permanent PBT|
FINAL FILING DATE: FILE IMMEDIATELY.
RECEIPT OF APPLICATIONS MAY CLOSE AT ANY TIME,
BUT NOT BEFORE 5:00 PM ON JUNE 19, 2019.
This is a Position-Based Test conducted in accordance with the Civil Service Rule 111A.
The current position is located at the San Francisco Recreation and Park Department (RPD). The eligible list resulting from this examination may be utilized for future positions in this class in other City departments.
The San Francisco Recreation and Park Department’s mission is to provide enriching recreational activities, maintain beautiful parks and preserve the environment for the well-being of our diverse community.
Amid a dynamic and ever-evolving urban landscape, the San Francisco Recreation and Park Department stewards one of the premier urban park systems in America. San Francisco recently became the first city in the United States for which 100% of its residents live within a ten-minute walk of a park. Considered by San Franciscans to be one of the City’s most popular and effective public agencies, our Department manages and maintains more than 225 parks, playgrounds, and open spaces in San Francisco, including two outside of city limits: Sharp Park in Pacifica and Camp Mather in the High Sierras. Our 4,100- acre system includes 25 recreation centers, 9 swimming pools, 5 golf courses and numerous athletic facilities, including sports courts, ball diamonds, soccer fields and gymnasiums. Included in the department’s responsibilities are Golden Gate Park, Coit Tower, the Marina Yacht Harbor, the Palace of Fine Arts, and TPC Harding Park golf course.
More than 2,000 talented individuals are part of our team, from gardeners, foresters, and recreation leaders to park rangers, custodians, electricians, painters and more. Our core mission, as it has been throughout our history, is to provide opportunities for San Francisco residents and visitors alike to gather, play, learn, relax, and enjoy nature in the city.
As part of the Recreation & Park Department’s Capital and Planning team, the 1052 IS Business Analyst under the general direction of the Capital Finance Manager oversees various parts of technology and software assessment, telecommunication needs analysis, system installation, implementation, testing and conversion to production status; technical and procedural documentation, user training, and post-implementation assessment and administration with a moderately complex system.
ESSENTIAL DUTIES, RESPONSIBILITIES AND JOB FUNCTIONS INCLUDE:
Assess and optimize system designs through review and analysis of user needs, customizing systems through system design and administration to meet the changing business needs of the users
Analysis of user needs; build data architecture; develop database; perform data conversion and normalization tasks on data imported from FSP for accessing, viewing, inputting, querying, and outputting Capital Financial, Scheduling and Project data
Write queries, views and stored procedures to update database tables and to create temporary business tables for analysis
Create and generate finance and project reports; developing dashboards of reports for capital and planning management team
Facilitate data analysis and communication between FSP, TMA, and VFA.Facility databases for updates, reports, maps, and applications.
Provide technical assistance to all users for IMPACT Team (Construction document management tool)
Conduct user training
Troubleshoot hardware/software problems on site and remotely
Install and maintain software; facilitate communication between clients and vendors regarding system maintenance issues, perform non-routine adds, moves and changes as needed
Update department project web pages, blogs and capital publications
Perform related duties and responsibilities, as assigned
The ideal candidate will be someone who enjoys wearing many hats. They will be capable of solving issues by approaching problems from many different angles and is comfortable working with a technologically varied user base.
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.
In addition to the Minimum Qualifications listed above, this position has additional requirements. In order to qualify for this position, applicants must meet the following Special Conditions, which may be gained concurrently to the experience requirement indicated above:
- 1 year of LAN Administration Experience
- 1 year of SQL Server Database Applications Experience
- 1 year of Windows Desktop and Client Server 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.
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.
The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.
- 2 years of SQL Server Database Applications Experience
How To Apply
Applications for City and County of San Francisco jobs are being accepted only 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 (PBT-1052-096619)
- 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).
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.
Resumes may be attached to the application; however, 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.
If you have any questions regarding this recruitment or application process, please contact the exam analyst, Eugenia Paw, by telephone at (415) 831-6824, or by email at Eugenia.Paw@sfgov.org.
Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. Failure to provide the required verification when requested may result in rejection of application and/or removal from eligibility for referral and appointment in this class. Refer to the following links for verification:
Verification Guidelines: http://www.sfdhr.org/index.aspx?page=20#verification
Education Verification: http://www.sfdhr.org/modules/showdocument.aspx?documentid=18441
NOTE: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification from this and future job opportunities with the City and County of San Francisco.
Minimum Qualification Supplemental Questionnaire (Weight: Qualifying):
Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application. This Supplemental Questionnaire is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications for this position. Applicants must also complete the official application. It is essential that applicants provide complete information in identifying their education, experience and training. The Supplemental Questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications.
Training & Experience Evaluation (Weight: 100%):
Candidates will be prompted to complete a supplemental questionnaire as part of the online employment application process. The supplemental questionnaire is designed to measure the knowledge, skills and abilities required for the position 1052 IS Business Analyst. All relevant experience, education and/or training must be on the supplemental questionnaire in order to be reviewed in the rating process.
The information provided on the supplemental questionnaire must be consistent with the information on the application and is subject to verification. Once submitted, applicant responses on the supplemental questionnaire cannot be changed.
Candidates will be placed on the eligible list/score report 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.
Note: A passing score must be achieved on all examination components in order to be placed/ranked on the resulting Eligible List.
Certification Rule: The certification rule for the eligible list resulting from this examination will be Rule of Ten. The hiring department may conduct additional selection processes 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.
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
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://sfdhr.org/information-about-hiring-process#applicantswithdisabilities
Seniority Credit in Promotional Exams:
Information regarding seniority credit can be found at: http://www.sfdhr.org/index.aspx?page=20#senioritycredit
Information regarding requests for veterans’ preference can be found at: http://www.sfdhr.org/index.aspx?page=20#veteranspreference
General Information Concerning City and County of San Francisco Employment Policies and Procedures:
Important Employment Information for the City and County of San Francisco can be obtained at http://www.sfdhr.org/index.aspx?page=20 or hard copy at 1 South Van Ness Avenue, 4th Floor.
Terms of the Announcement:
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.
Copies of Application Documents:
Applicants are advised to keep copies of all documents submitted. Submitted documents become a permanent part of the exam record and will not be returned. The hiring department may require applicants to submit the same documents and/or additional documents at a later date.
Right to Work:
All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.
General Information concerning City and County of San Francisco Employment Policies and Procedures may be found online at: http://www.sfdhr.org/index.aspx?page=20.
Exam Type: COMBINED, PROMOTIVE & ENTRANCE
Micki Callahan, Human Resources Director
Department of Human Resources
Recruitment ID #: 096619
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.|