1063 Senior IS Programmer Analyst - Business Intelligence
|Specialty||Business Intelligence Analyst|
|Date Opened||10/21/2016 12:00:00 AM|
|Filing Deadline||1/20/2017 2:00:00 PM|
|Salary||$85,618.00 - $107,822.00/year|
|Job Type||Permanent PBT|
San Francisco Police Department 1063 Senior IS Programmer Analyst - Business Intelligence
Amended on 01/06/2017 to change the filing deadline to 01/20/2017.
This is a Position Based Test conducted in accordance with Civil Service Commission Rule 111A.
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.
The San Francisco Police Department has two (2) vacancies for 1063 Senior IS Programmer Analyst - Business Intelligence. Under general direction, the Senior IS Programmer Analyst - Business Intelligence is responsible for analysis and design, feasibility analysis, technology and software assessment for the following tasks relating to development and support of Public Safety agencies (Police, Fire, 911 Dispatch) software and applications.
• Develop Oracle Business Intelligence Enterprise Edition (OBIEE) dashboard and reports.
• Development process responsibilities include but are not limited to: scoping requirements, design, development, testing, presenting, release, documentation, training, and support.
• Maintain development and production environments for OBIEE administration, OBIEE reporting, and user security for the SFPD Crime Data Warehouse Business Intelligence.
• Demo reports and dashboards to clients
• Perform additional analysis as needed
1. EDUCATION: Possession of Bachelor’s degree from an accredited college or university preferably in computer science or closely related field.
2. EXPERIENCE: Minimum three (3) years of experience working with Business Intelligence reporting tools.
This position requires three (3) years of recent (within the past 5 years) and verifiable experience as a programmer/ business intelligence 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 qualifying work experience as described above may substitute for the required education on a year-for-year basis. One (1) year (equivalent to 2,000 hours) of additional qualifying work experience will be considered equivalent to 30 semester units/45 quarter units.
Applicants will be required to submit verification of qualifying education and experience at any point in the application, examination and/or departmental 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.
Applicants MUST demonstrate their experience, knowledge and responsibilities described above in the employment record section of the City application.
A resume does NOT substitute for this section of the City application.
• Experience with Extract, Transform, Load (ETL) / Extract, Load, Transform (ELT) development in a data warehouse, OBIEE architecture, and repositories or similar environments is a plus.
• Ability to understand complicated business requirements.
• Good understanding of STAR schema models.
• Experience performing user acceptance testing.
• Advanced data analysis skills.
• Advanced documentation skills.
• Advanced verbal and written communications skills.
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, Orla Petirs, by telephone at 415-837-7362, or by email at firstname.lastname@example.org
Oral Exam (Weight: 100%):
Candidates will be assessed through one or more structured, job-related questions designed to measure critical knowledge, skills and/or abilities in job-related areas which may include but not limited to: knowledge of business intelligence programming reporting and dashboard systems (Oracle Business Intelligence Enterprise Edition); knowledge of the OBIEE administration; knowledge of STAR schema models.
Verification: Applicants must meet the minimum qualifications requirement by the filing date.
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.
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 six (6) months, and may be extended with the approval of the Human Resources Director.
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.
Disaster Service Workers
Reasonable Accommodation Request:
Applicants with disabilities requiring reasonable accommodation for this process must contact Orla Petirs by phone at 1(415) 837-7362 or if hearing impaired, 1(415) 575-6082 (TTY), or in writing at San Francisco Police Department, Staff Services Division – 1245 3rd Street, San Francisco, CA 94158 Attn: 1063 IS Programmer (Senior) as soon as possible. Information on requesting reasonable accommodation for persons with disabilities can be found at: http://www.sfgov.org/site/sfdhr_page.asp?id=46205#applicants_with_disabilities
Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at:
Information regarding requests for Veterans Preference 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://www.sfdhr.org/index.aspx?page=20 or hard copy at 1 South Van Ness Avenue, 4th Floor.
Seniority Credit in Promotional Exams:
Information regarding seniority credit can be found at:
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. [Note: The correction of clerical errors in an announcement may be posted on the Department of Human Resources website at www.jobaps.com/sf.] The terms of this announcement may be appealed under Civil Service Rule 110.4. Such appeals must be submitted in writing to the Department of Human Resources, 1 S Van Ness Avenue, 4th Floor, San Francisco, CA 94103-5413 by close of business on the 5th business day following the issuance date of this examination announcement. Information concerning other Civil Service Commission Rules involving announcements, applications and examination policies, including applicant appeal rights, can be found on the Civil Service Commission website at http://sfgov.org/civilservice/rules.
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.
Exam Type: CPE
Issued: October 21, 2016
Human Resources Director
Department of Human Resources
Recruitment ID Number:1063-071599
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.