1054 IS Business Analyst-Principal
|Date Opened||1/30/2019 08:00:00 AM|
|Filing Deadline||2/19/2019 5:00:00 PM|
|Salary||$57.48 - $72.30/hour; $9,962.00 - $12,532.00/month; $119,548.00 - $150,384.00/year|
|Job Type||Permanent PBT|
San Francisco Police Department 1054 IS Business Analyst-Principal
This is a Position Based Test conducted in accordance with Civil Service Commission Rule 111A.
Job announcement has been updated on 2/1/2019 to reflect changes to the minimum qualifications. The application deadline has been extended 2/19/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 Principal Business Analyst will be acting as the Project Leader for the Business Intelligence Unit of SFPD Technology Division, which uses Oracle Business Intelligence Enterprise Edition (OBIEE). As a project leader, the 1054 manages and provides technical leadership of projects involving large-scale, complex and highly analytical tasks.
Essential Duties include:
- Assure proper planning, documentation, installation and testing of OBIEE to meet end user requirements.
- Manage system maintenance activities and the OBIEE implementation process department wide.
- Provide technical support services, develop training exercises for department staff, maintain technical education, and present training classes on OBIEE.
- Gather requirements and general information regarding users business needs relating to new developments or enhancements within OBIEE.
- Coordinate support from Oracle for the technical and administrative resolution of network troubleshooting problems.
- Identify opportunities for improving business processes through automation; prepare proposals to develop new systems or enhancements to existing systems, conduct feasibility studies.
- Create work plans and monitor progress of project tasks, schedules and completion dates.
- Coordinate and attend project team meetings and user meetings.
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].
Experience: Five years of full-time 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 four (4) years of full-time 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 http://sfdhr.org/index.aspx?page=456
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
Minimum Qualification Supplemental Questionnaire (Weight: Qualifying): Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application. This Minimum Qualification 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 Minimum Qualification Supplemental Questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications.
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 Oracle Business Intelligence Enterprise Edition (OBIEE); practices and techniques of project management; ability to train others; to communicate effectively both orally and in writing; to use logic and analysis to solve computer and systems problems; to translate functional requirements into systems specifications; to coordinate highly technical procedures and complex reporting requirements; to produce complex reports in OBIEE.
All relevant experience, education and/or training must be on the application in order to be reviewed in the rating process.
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 finalist 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 finalist. 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 selected as a finalist, the hiring department will contact you to schedule a fingerprinting appointment.
Disaster Service Workers
The eligible list resulting from this examination 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 of 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 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 http://www.sfdhr.org/Modules/ShowDocument.aspx?documentID=21246. Search that document by title or job code to see which departments use the classification.
The certification rule for the eligible list resulting from this examination will be Rule of 10 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: January 30, 2019
Human Resources Director
Department of Human Resources
Recruitment ID Number: 091033
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.