IS Programmer Analyst – Principal – SFPD (1064)

IS Programmer Analyst – Principal – SFPD (1064)

Apply using SmartRecruiters, the City and County of San Francisco's application portal.

Who We Are: The San Francisco Police Department was established in 1849 and continually strives to become a more effective, inclusive and modern police department, while earning the trust and pride of those we serve and those who serve. Our goal is to reflect on current SFPD initiatives, assess best practices across the country, and evaluate the changing environment in policing and within the City to arrive at a strategy statement that the Department and our community can embody every day.

The San Francisco Police Department stands for Safety and Respect for All. We will engage in just transparent unbiased and responsive policing. We will do so in the spirit of dignity and in collaboration with the community. And we will maintain and build trust and respect as the guardians of Constitutional and human rights.

The San Francisco Police Department is committed to excellence in law enforcement and is dedicated to the people, traditions and diversity of our City. The department provides service with understanding, response with compassion, performance with integrity and law enforcement with vision.

Recruitment Process Information:

• Application Opening: August 21, 2023
• Application Deadline: Apply immediately, announcement may close anytime after 2 weeks from posting date.
• Appointment Type: Permanent Exempt - This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer. The duration of the appointment shall not exceed 36 months.
• Work Schedule: Monday - Friday, Full-time, Hybrid Telecommuting work schedule available in line with CCSF policy.

Under general direction, the IS Programmer Analyst-Principal works in the SFPD Technology Division and is responsible for developing, testing, implementing, and supporting business intelligence solutions in Oracle Analytic Server (OAS), Oracle Data Integrator, and other Business Intelligence tools. This position will be the Lead ETL (extract, transform, load) programmer of the department for the National Incident-Based Reporting System (NIBRS) project.

ESSENTIAL DUTIES:

• Lead NIBRS ETL/ELT projects. Program and train other analysts in related projects & tasks.
• Data modeling.
• Develop Oracle Analytic Server (OAS) dashboards and reports.
• ETL/ELT development and maintenance for NIBRS based projects, and various team projects.
• 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 OAS administration, OAS reporting, and user security for the SFPD Business Intelligence System.
• Demo ETLs, models, reports, and dashboards to internal and external staff.
• Work on Geographic Information System (GIS) projects such as migration of data from OAS to ArcGIS.
• Train all ETL programmers to ensure 24/7 backup support when needed.
• May be required to supervise and be on call on an emergency basis.
• Perform related duties and responsibilities as assigned.

How to qualify

1. Education: An associate degree in computer science or 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).

AND

2. Experience: Five (5) years of full-time experience in applications or software programming or development.

• Substitution: 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.

Desirable Qualifications: The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.

• Working knowledge of the following:
  • Oracle Business Intelligence tools.
  • Oracle Analytic Server (OAS).
  • Geographic Information Systems (GIS).
• ETL/ELT Experience (Oracle Data Integrator, SSIS, Informatica).

Verification of Education and Experience: Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and 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.

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 will not be accepted in lieu of a completed City and County of San Francisco application.

Applications completed improperly may be cause for ineligibility or disqualification.

Background Investigation: Prior to employment with the San Francisco Police Department, a thorough background investigation will be conducted to determine the candidate’s suitability for employment.

What else should I know?

Recruiter Information: If you have any questions regarding this recruitment or application process, please contact the Staff Services analyst, Danny Wan at

Additional Information Regarding Employment with the City and County of San Francisco: Applications for City and County of San Francisco jobs are only accepted through an online process. Visit and begin the application process.

• Select the “I’m Interested” button and follow instructions on the screen.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition, HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.