Skip to content

Career Opportunity

System Integration Developer - Department of Technology (1063)

Recruitment: REF34760B

Published: May 16, 2024


Carol Wong -

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

Department: Technology
Job class: 1063-IS Programmer Analyst-Senior
Salary range: $117,156.00 - $147,472.00
Role type: Temporary Exempt What does this mean?
Hours: Full-time


Announcement is updating the application deadline only. Applicants that have already applied, do not need to reapply.  This position is open until filled.


IMPORTANT: Your application MUST include responses to the supplemental questionnaire found here:

Applicants must complete the supplemental questionnaire prior to starting the online application process. The application will not be reviewed without a completed supplemental questionnaire. 

Why Work for the Department of Technology (DT)? DT is the centralized technology services provider in the City and County of San Francisco (CCSF). We deliver technology infrastructure and services to approximately 33,000 employees! With an annual operating budget of over $140M and approximately 260 employees, DT provides a host of services that range from Public Safety radio and wiring and Network services to Enterprise Support and the Cloud.

Benefits of Working for CCSF:  In addition to challenging and rewarding work, the City provides a generous suite of benefits to its employees.

  • Job security, pension, and robust retirement options
  • Competitive pay with consistent bi-yearly or yearly increases
  • Hybrid Work with a minimum of 20% of time spent in our office in San Francisco, California for all IT related roles
  • Generous paid time off, family leave, and more!
  • Diverse work environment in a diverse city
  • Union protections and representation
  • Career development and growth — move between departments, learn on the job, or take subsidized/reimbursed classes!

PEOPLE-CENTERED SOLUTIONS — have a powerful, meaningful effect on the community each day with people at the heart of every solution!

CLOSING THE DIGITAL DIVIDE — bring the benefits of the internet to low-income and marginalized residents!

SHINE A LIGHT ON WHAT MATTERS — join an award-winning production team at SFGovTV to help residents watch legislators or learn more about what makes this City great!

DRIVE INNOVATION — deliver new, cutting-edge technology to residents and city partners to help San Francisco serve its residents!

Role description

The Department of Technology (DT) is looking for a System Integration Developer responsible for performing all aspects of the design, development, integration, installation, maintenance, and support of the JUSTIS API. The Developer will perform these functions for the JUSTIS Data Exchange Hub production, test, and development environments and their related applications and integration components. The developer will work with system architects and developers to maintain, upgrade, and enhance the integration interfaces and systems to continue to meet operational needs and satisfy local, state, and federal laws that govern user access, data protection, and network security for the platform. The developer must perform work of a complex, technical nature and require a high level of functional and technical skills.

The Justice Tracking Information System (JUSTIS) is a program that is chartered to modernize the infrastructure, applications, and systems between criminal justice agency partners and to facilitate real-time data exchange and sharing of criminal records. This role is part of a development team and reports to the IS Technical Project Director.

The System Integration Developer will join an existing development division within the Department of Technology that designs, enhances, and supports the data exchange hub that serves the 24x7x365 operations of 8 critical San Francisco agencies.

Under general direction of the IS Technical Project Director, this position will be responsible for creating, designing, and maintaining the JUSTIS API that enable JUSTIS client departments to implement their own system integration for data exchange.

Essential Duties:

•     Design, develop and maintenance reusable, testable server-side components and web service, develop system integration, and build and maintain web application frond end using Python and Java.

•     Create and maintain database tables, views, pl/sql procedures using Oracle 10g, 12C and 19C

•     Expertise in system integration using Python with RESTful services and JSON, and working knowledge of SOAP and XML

•     Implement and maintain CI/CD pipelines and ensure that code releases are properly defined and performing optimally.

•     Review, verify, and validate the software code developed in the project.

•     Ability to work with other team members and willing to assist teammates in performing tasks listed above.

Job Type:

The Temporary Exempt - Full Time position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointment officer. The anticipated duration of this project position is thirty-six (36) months and will not result in an eligible list or permanent civil service hiring.

Nature of Work:

Incumbent must be willing to work (specify the work schedule; for example, a 40-hour week) as determined by the department.  Travel within San Francisco may be required. 

The incumbent must be a resident of the State of California or be willing to relocate within 4 weeks of beginning employment with the City and County of San Francisco.

Work Location:

Incumbent will conduct the majority of work at the Department of Technology, (1 S Van Ness, Ave San Francisco, CA 94103).  However, there may be situations where the incumbent will be required to work at other sites throughout the City of San Francisco as necessary.

This position does not support fully remote work. Employees may be permitted to work a hybrid schedule with supervisor approval, after which they must work at least two days in the office every two weeks.

How to qualify


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].


Three (3) years of experience in application or software development or programming

License and Certification:


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 .

Desired Qualifications:

  • Experience with modern technology service architectural hosting, security, and risk management concerns (e.g. Data Warehouse, Data Engineering Pipeline, Data Preparation and Modeling, Advanced -  Analytics, Data Services, and Consumption).
  • Experience in Agile/Scrum, or ITIL principals with experience implementing one of these practices preferred
  • Experience with event-driven programming in Python
  • Able to create database schemas that represent and support business processes
  • Strong unit test and debugging skills
  • Proficient understanding of code versioning using Git
  • Experience in Oracle database administration and development using PL/SQL, advanced level of SQL skills, table structure and RESTful APIs.  In-depth experience developing with Oracle BPEL, PL/SQL, SQL, Java, Web Services, JSON, XML, Middleware, load scripts, ActiveMQ and Microsoft message queue, Interfaces, Workflow, JDeveloper, SQL Developer, shell scripting, documentation.
  • Experience doing software development experience using Python and Object Oriented programming languages such as Java, C#, C++
  • Expert level experience installing, configuring and supporting Window 2003 – 2016 Servers, Linux Servers with strong understanding of networking concepts.
  • Proven record of working in a demanding environment and high stress situation with high level of accuracy and output.  Ability to work with other team members and willing to assist teammates.

Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.


1)  Security Clearances & Background Investigations: Criminal Justice Information Services (CJIS) Security Clearance may be required. Positions in this classification may require that successful candidates who become eligible for appointment may be required to go through a background investigation to determine the candidate's suitability for employment in this classification. Factors considered in the investigation may include employment history, use of illegal/controlled substances. Reasons for rejection based on this investigation may include, but not limited to applicable convictions, repeated or serious violations of the law, inability to accept supervision, inability to follow rules and regulations, falsification of application materials and/or other relevant factors. Failure to obtain and maintain security clearance may be basis for termination.

Verification: Applicants may be required to submit verification of qualifying education and experience at any point in the application and/or departmental selection process. Written verification (proof) of qualifying experience must verify that the applicant meets the minimum qualifications stated on the announcement. Written verification must be submitted on employer’s official letterhead, specifying name of employee, dates of employment, types of employment (part-time/full-time), job title(s), description of duties performed, and the verification must be signed by the employer. City employees will receive credit for the duties of the class to which they are appointed. Credit for experience obtained outside of the employee’s class will be allowed only if recorded in accordance with the provisions of the Civil Service Commission Rules. Experience claimed in self-employment must be supported by documents verifying income, earnings, business license and experience comparable to the minimum qualifications of the position. Copies of income tax papers or other documents listing occupations and total earnings must be submitted. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at

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. 

What else should I know?

Compensation: $117,156 - $147,472 (annually) / $56.3250 - $70.9000 (hourly)

How to Apply:

  • Applicants are encouraged to apply immediately as this recruitment may close at any time but not earlier than March 5, 2024. This position is open until filled.
    • Your application MUST include a resume.  To upload, please attach using the "additional attachments" function.
    • In additional to submitting your application, you MUST submit this supplemental questionnaire:

You may contact Carol Wong via email at with questions regarding this opportunity.

Late or incomplete submissions will not be considered. Mailed, hand delivered or faxed documents/applications will not be accepted.

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.  Please be informed that the Department of Technology will not sponsor visa applications/transfer.

Helpful Information

All your information will be kept confidential according to EEO guidelines.

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 (associated with cancer, a history of cancer, or genetic characteristics), 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.