DataSF
Geographic IS Programmer Analyst – Senior – SFPD (1063)
DataSF, San Francisco, California, United States, 94199
Geographic IS Programmer Analyst – Senior – SFPD (1063)
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.The San Francisco Police Department stands for Safety and Respect for All. We will engage in just, transparent, unbiased, and responsive policing.Specific information regarding this recruitment process are listed below:Application Opening:
December 13, 2023, Announcement amended on 03/01/2024 to reflect update to job title and essential duties. Previous applicants do not need to reapply.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.Work Schedule:
Monday - Friday, Full-time, Hybrid Telecommuting work schedule available in line with CCSF policy.Under general direction, the Senior Geographic IS Programmer Analyst works in the SFPD Technology Division and is assigned to the National Incident-Based Reporting System (NIBRS) modernization project where they will be responsible for developing, testing, implementing, and supporting business intelligence solutions in ArcGIS, Oracle Analytic Server (OAS), Oracle Data Integrator, and other Business Intelligence and GIS / ETL tools.Create dynamic dashboards using Esri products such as ArcGIS Dashboard, WebApp Builder, Experience Builder, and other related technologies to meet the department’s data analytics and mapping needs.Develop and provide demonstration of dashboards to internal and external staff.Support the development and maintenance of the department’s ArcGIS (Portal) Enterprise platform and other geographic information system (GIS) infrastructure.Manage and fulfill geospatial data and mapping inquiries by designing data schemas and structures for spatial datasets, integrating data from multiple sources, and publishing both digital and physical cartographic products.Work on GIS projects such as migration of data from OAS to ArcGIS.Perform related duties and responsibilities, as assigned.How to qualify
In order to be considered, you must possess the following education and experience: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.AND2.
Experience:
Three (3) years of full-time experience in application or software development or programming.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).Note: One year of full-time employment is equivalent to 2000 hours.Desirable Qualification:
The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.Advanced proficiency in ArcGIS Pro, ArcGIS Online, Esri Enterprise Portal, ArcServer, and experience developing dynamic dashboards with Esri’s suite of web mapping applications.Possession of education, certification, and/or professional experience in geography, geographic information systems, data science, or related fields.Fluent in SQL with experience in database design and management, ideally with Oracle and PostgreSQL / PostGIS.Knowledge and/or experience with ETL/ELT projects, tasks, and applications.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 may result in 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 danny.wan@sfgov.org.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 https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ 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.
#J-18808-Ljbffr
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.The San Francisco Police Department stands for Safety and Respect for All. We will engage in just, transparent, unbiased, and responsive policing.Specific information regarding this recruitment process are listed below:Application Opening:
December 13, 2023, Announcement amended on 03/01/2024 to reflect update to job title and essential duties. Previous applicants do not need to reapply.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.Work Schedule:
Monday - Friday, Full-time, Hybrid Telecommuting work schedule available in line with CCSF policy.Under general direction, the Senior Geographic IS Programmer Analyst works in the SFPD Technology Division and is assigned to the National Incident-Based Reporting System (NIBRS) modernization project where they will be responsible for developing, testing, implementing, and supporting business intelligence solutions in ArcGIS, Oracle Analytic Server (OAS), Oracle Data Integrator, and other Business Intelligence and GIS / ETL tools.Create dynamic dashboards using Esri products such as ArcGIS Dashboard, WebApp Builder, Experience Builder, and other related technologies to meet the department’s data analytics and mapping needs.Develop and provide demonstration of dashboards to internal and external staff.Support the development and maintenance of the department’s ArcGIS (Portal) Enterprise platform and other geographic information system (GIS) infrastructure.Manage and fulfill geospatial data and mapping inquiries by designing data schemas and structures for spatial datasets, integrating data from multiple sources, and publishing both digital and physical cartographic products.Work on GIS projects such as migration of data from OAS to ArcGIS.Perform related duties and responsibilities, as assigned.How to qualify
In order to be considered, you must possess the following education and experience: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.AND2.
Experience:
Three (3) years of full-time experience in application or software development or programming.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).Note: One year of full-time employment is equivalent to 2000 hours.Desirable Qualification:
The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.Advanced proficiency in ArcGIS Pro, ArcGIS Online, Esri Enterprise Portal, ArcServer, and experience developing dynamic dashboards with Esri’s suite of web mapping applications.Possession of education, certification, and/or professional experience in geography, geographic information systems, data science, or related fields.Fluent in SQL with experience in database design and management, ideally with Oracle and PostgreSQL / PostGIS.Knowledge and/or experience with ETL/ELT projects, tasks, and applications.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 may result in 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 danny.wan@sfgov.org.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 https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ 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.
#J-18808-Ljbffr