1070 IS Project Director

Recruitment #PBT-1070-900272


Announcement amended on 2/14/2014 to allow for continuous filing until a sufficient number of qualified applications are received. Receipt of applications may close at any time but not before 5PM on February 19, 2014. Applicants are encouraged to submit their application immediately.

This is a Position Based Test conducted in accordance with Civil Service Rule 111A.

The Manager of Business Intelligence is responsible for the leadership and management of the San Francisco Police Department’s (SFPD) business intelligence and reporting applications and processes, including the implementation and maintenance of Oracle Business Intelligence, SFPD’s Crime Data Warehouse (CDW), and other data and reporting tools. This position works closely with the SFPD CIO and Command Staff to collaborate and deliver key reports as well as performance scorecards and dashboards. The Manager of Business Intelligence provides service to SFPD to produce Crime Data as needed for internal and external purposes, and provides data analysis as needed to determine relationships and links between and among SFPD data as well as related data sources.

Examples of duties:

  • Effectively lead and manage a team responsible for delivery of business intelligence, data analysis, and reporting solutions
  • Collaborate with SFPD Tactical Leadership to understand reporting needs and lead IT resources to successful execution on projects to meet those needs  
  • Lead key strategic project initiatives as assigned, developing comprehensive project plans, timelines, resource plans, communications, and other pertinent documentation
  • Implement and maintain Oracle Business Intelligence data warehouse and reporting environment
  • Lead efforts to consolidate reporting platforms and provide vision for SFPD reporting roadmap
  • Lead efforts to provide Uniform Crime Reports and other mandatory law enforcement reports and data feeds to the appropriate local, state, and federal agencies  
  • Develop and maintain SFPD’s business intelligence systems to provide secure, efficient, and consistent employee access to data
  • Work with IT staff to ensure business intelligence systems comply with existing infrastructure requirements and integrate with security systems, network infrastructure, and other business systems
  • Monitor and expand data warehouse, Oracle Business Intelligence applications and related software systems as needed to assure adequate security, performance and capacity
  • Work with internal security teams to identify and implement user and administrator security for data
  • Coordinate IT efforts for SFPD department wide business intelligence projects
  • Coordinate SFPD IT Division’s budgeting and resource planning for business intelligence projects
  • Recruit, develop and retain a high performing team including conducting annual performance evaluations
  • Research new processes and procedures to enhance software capabilities
  • Prioritize projects with SFPD IT staff and allocate appropriate IT resources

Minimum Qualifications

1. Possession of a Bachelor of Science degree from an accredited college or university in Computer Science, Information Technology, Business Administration, or a closely related field relevant for performance of the essential functions of this job; AND

2. Seven years of experience delivering business intelligence solutions with management or leadership experience, of which must include:

  • Seven years of Business Intelligence Project Management experience; AND
  • Seven years of Project Management Application Design and Development experience; AND
  • Three years managing or supervising a high performance work team with responsibility for recruiting, coaching, reviewing subordinate work products, disciplinary actions, terminations, and delivery of performance appraisals.

Substitution: Additional qualifying work experience as described above may substitute for the required education on a year-for-year basis. One year (2000 hours) of additional qualifying work experience will be considered equivalent to 30 semester units/45 quarter units.

Desirable Qualifications:

  • Experience with implementing and supporting Business Intelligence systems
  • Experience with advanced reporting tools such as Cognos and/or other data warehousing tools
  • Certification in a nationally accredited project management discipline (i.e., PMI, PMP, Six Sigma, Unified Rational, etc.)
  • Experience with version control system such as CVS or Subversion
  • Experience with automated testing tools and testing procedures
  • Demonstrated strong and effective verbal, written, and interpersonal communication skills
  • Excellent time management skills and ability to generate and support pragmatic solutions that meet SFPD’s software launch requirements, while maintaining high quality standards
  • Experience and proficiency in effective project management
  • Strong analytical skills with high degree of detail orientation
  • A proven track record of working closely with customers and collaboratively delivering solutions to meet business needs

The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

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, Nancy Sessa, by telephone at 415-553-1340, or by email at Nancy.Sessa@sfgov.org.

Selection Procedures

Supplemental Questionnaire (Weight: 100%): Candidates will be prompted to complete a supplemental questionnaire as part of the online employment application. The Supplemental Questionnaire is designed to measure knowledge, skills and/or abilities in job-related areas which may include but not be limited to: knowledge of project management and information systems, knowledge of computers and electronics, management/supervisory ability, ability to use logic and analysis, and written communication ability.

The department may utilize additional selection procedures to make a final hiring decision such as the submission of code samples and the ability to discuss submitted samples during an oral interview.

Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.

Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process.

Background Investigation (Qualifying): 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.

Conviction History

As part of the selection process an image of your fingerprints will be captured and 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) history will disqualify you as a candidate based on the specific requirements of the position to which you are applying. If selected for fingerprinting, the hiring department will contact you to schedule an appointment.

Candidates applying 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 applying 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.

Disaster Service Workers

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.


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.

The certification rule for the eligible list resulting from this examination will be Rule of Three Scores.  Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

Eligible List:
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 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=13693. Search that document by title or job code to see which departments use the classification.

Applicants with disabilities requiring reasonable accommodation for this process must contact Penny Si by phone at (415) 553-1343 or if hearing impaired, (415) 558-2407 (TTY), or by e-mail to penny.si@sfgov.org as soon as possible.

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://www.sfdhr.org/index.aspx?page=20 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: February 4, 2014; Amended February 14, 2014 for Continuous filing
Micki  Callahan
Human Resources Director
Department of Human Resources
Recruitment ID Number: 900272


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.

For more information about benefits, please click here.


Powered by JobAps