1053 IS Business Analyst-Senior
|Date Opened||5/31/2019 08:00:00 AM|
|Filing Deadline||7/26/2019 5:00:00 PM|
|Salary||$49.64 - $62.45/hour; $8,604.00 - $10,825.00/month; $103,246.00 - $129,896.00/year|
|Job Type||Permanent PBT|
This is a Position Based Test conducted in accordance with Civil Service Commission Rule 111A.
Amended on 6/19/19 to change the deadline to Continuous.
This position may close any time, but no earlier than 5pm, June 28, 2019.
The San Francisco Police Department is committed to excellence in law enforcement and is dedicated to the people, traditions and diversity of our City. In order to protect life and property, prevent crime and reduce the fear of crime, the department provides service with understanding, response with compassion, performance with integrity and law enforcement with vision. The San Francisco Police Department established in 1849, enforces the law and investigates crime in San Francisco, including the San Francisco International Airport. The organization has grown into a nationally known police department providing law enforcement services to one of the most recognized cities in the United States. The department operates 10 district stations, a crime lab and a training academy.
Under general direction, the Senior Business Analyst will be part of the Business Intelligence Unit of SFPD Technology Division, which uses Oracle Business Intelligence Enterprise Edition (OBIEE).
Essential Duties include:
• Identify opportunities for improving business processes through automation; assist in the preparation of proposals to develop new systems.
• Determine system operating characteristics and requirements; 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 OBIEE; ensure the design fits the needs of the users.
• Conduct system analysis and may conduct programming activities for OBIEE; document new and modified systems and programs; coordinate user training in new capabilities of OBIEE; may convert new programming from test to production.
• Interface with users to determine OBIEE needs and requirements; instruct users on OBIEE; define system requirements; may design and code OBIEE; review impact of modifications on OBIEE
• Prepare, or assist in preparing, service requests to Oracle implement system changes; determine level of effort required and the cost of implementing service requests; prioritize requests.
• Determine security levels for OBIEE to ensure data integrity; test database applications to assure functionality and effectiveness in performing to desired specifications.
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].
Three (3) 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, of which three (3) years of experience must be as a business analyst using Oracle Business Intelligence Enterprise Edition (OBIEE)
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.
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.
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 https://sfdhr.org/how-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.
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, @famsf.org, @ccsf.edu).
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, Orla Petirs, by telephone at 415-837-7362, or by email at firstname.lastname@example.org
Behavioral Consistency Questionnaire (Weight 100%):
Only candidates who meet the minimum requirements will receive a Behavioral Consistency Questionnaire to complete and return by e-mail. This questionnaire has been designed to measure knowledge, skills and/or abilities in job-related areas which may include, but not be limited to: Knowledge of OBIEE; Knowledge of functional requirements, structured systems or procedures analysis; Knowledge of system analysis and design; Knowledge of common operating systems software and relational database systems; Ability to Communicate effectively both orally and in writing; Ability to establish and maintain good working relations with department personnel, staff, vendors, peers, and management; Ability to understand and learn a variety of business procedures and processes; Ability to use logic and analysis to solve computer and systems problems; Ability to translate functional requirements into systems specifications; Ability to analyze data and information using established criteria, in order to determine consequences and to identify and select alternatives; Ability to prioritize competing requests for service. A passing score on the Behavioral Consistency Questionnaire Evaluation must be achieved in order to be placed/ranked on the Eligible List.
Prior to employment with the San Francisco Police Department, a thorough background investigation will be conducted to determine the candidate’s suitability for employment. The investigation may include, but not be limited to: criminal history records, driving records, drug/alcohol screening, and other related employment and personal history records. Reasons for rejection may include use of controlled substances and alcohol, felony conviction, repeated or serious violations of the law, inability to work with co-workers, inability to accept supervision, inability to follow rules and regulations or other relevant factors. Candidates may be required to undergo drug/alcohol screening, and must clear Department of Justice and Federal Bureau of Investigation fingerprinting. Criminal records will be carefully reviewed; candidates who do not report their complete criminal records on their applications will be disqualified. Applicants will be fingerprinted.
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
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 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.
The certification rule for the eligible list resulting from this examination will be Rule of 3 Scores. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.
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 Applicants with disabilities who might need accommodations during the application and selection process should contact the SFPD ADA Coordinator Penny Si at (415) 837-7221.
Information regarding requests for Veterans Preference can be found at:
Seniority Credit in Promotional Exams:
Information regarding seniority credit can be found at:
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://sfdhr.org/information-about-hiring-process or hard copy at 1 South Van Ness Avenue, 4th Floor.
Copies of Application Documents:
Applicants should keep copies of all documents submitted, as these will not be returned.
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.
Terms of 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.
Exam Type: CPE
Issued: May 2019
Human Resources Director
Department of Human Resources
Recruitment ID Number: PBT-1053-096234
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.