1064-IS Programmer Analyst-Principal

City and County of San Francisco; San Francisco, Northern (CA, KY); Hybrid; USD 146,000 - 197,000; Full time

Benefits offered by this job

Work from home 1 day per week

Competitive benefits

Job summary

City and County of San Francisco’s Department of Technology seeks a Principal System Integration Engineer for the JUSTIS Data Exchange Hub. You will design and maintain API-driven integrations across Python, Java, and Oracle stacks to power secure, real-time data exchange among criminal justice partners.

This full-time, hybrid role requires extensive experience with enterprise integrations, CI/CD, and strong collaboration to ensure CJIS-compliant security and high availability in

Qualifications

• Five years of experience in applications or software development.
• Understanding of CJIS and security/privacy requirements.
• Experience with API development and enterprise integrations.
• Familiarity with Python and Java/C++.
• Bachelor’s degree in CS or related field preferred.

Responsibilities

• Design, develop, and maintain RESTful APIs and backend services.
• Build server-side components using Python and Java.
• Develop secure integration patterns and data exchanges.
• Maintain Oracle database structures and PL/SQL procedures.
• Support CI/CD pipelines and release management.
• Ensure security, data protection, and compliance.

Skills

Python

Java

C++

REST APIs

DevOps

CI/CD

SQL/Oracle

Security/compliance

Communications

Mentoring

Education

Associate degree in computer science

Bachelor’s degree in computer science or related field

Tools

Git

Oracle PL/SQL

XML/JSON

CI/CD tools

Job description

Principal System Integration Engineer (Enterprise Systems), Python (1064) – Department of Technology

Recruitment: RTF0160953-01145751

Published: April 15, 2026

Accepting applications until: July 06, 2026

• Application Deadline: This recruitment is considered open until filled and will close no sooner than May 4, 2026.
• Salary Range: $145,548.00 - $197,184.00 annually

This posting has been amended as follows:

• 4/15/2026: Updated to reflect extended application period and additional information in the concluding section.
• 2/27/2026: Updated the Job Title, Desirable Qualifications, and Salary Range details to reflect the complexity and advanced responsibilities of this role.
• 2/23/2026: Updated the Nature of Work to include additional telecommute policy information.

Are you ready to make an impact in one of the most innovative cities? The San Francisco Department of Technology (DT) is looking for passionate IT professionals to help shape the future of technology in San Francisco! As the centralized technology services provider for the City and County of San Francisco (CCSF), DT delivers critical infrastructure and services to over 33,000 employees—supporting public safety, municipal broadband, cybersecurity, cloud solutions, and more! With a $140M+ annual budget and a team of 300+ experts, DT is leading the charge in digital transformation. DT provides services through our core areas of IT Excellence:

• IT Project Management Office
• Cloud Center of Excellence
• IT Operations and Support including the Service Desk and NOC
• City Infrastructure including the Network, Telcom and Data Centers
• Office of Cybersecurity including Cyber Defense, Identity Management and Disaster Recovery
• Public Safety Systems and Municipal Broadband Fiber
• SFGovTV Broadcasting Services
• IT Finance and Administration Services
• Emerging Technologies

Why Join Us? Innovative & Impactful Work At DT, you won’t just work on IT—you’ll power a city. Your expertise will directly impact the residents of San Francisco, from closing the digital divide to ensuring secure, efficient city operations.

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

• Competitive pay, benefits, and retirement options
• Career growth opportunities through training, internal mobility, and subsidized education
• Diverse work environment in a diverse city
• We offer employees the ability to work from home one day a week while spending the other four days in our San Francisco office, promoting both collaboration and work-life balance.

Join the team that’s shaping the future of technology in San Francisco. Apply today and be part of a dynamic, innovative, and mission-driven ITteam!

The Department of Technology’s Justice Tracking Information System (JUSTIS) team is responsible for designing, operating, and modernizing the City and County of San Francisco’s criminal justice data exchange platform. JUSTIS enables secure, real-time information sharing among multiple criminal justice partner agencies, supporting mission-critical operations that run 24 hours a day, 7 days a week.

The Principal System Integration Engineer is a key technical contributor on the JUSTIS development team, responsible for building and maintaining the APIs, integration services, and backend components that power the JUSTIS Data Exchange Hub. This role focuses on developing secure, reliable, and scalable system-to-system integrations that allow partner agencies to exchange criminal justice data in compliance with local, state, and federal requirements governing privacy, security, and access to sensitive information.

Working closely with system architects, technical leadership, project management, and partner agencies, the Software Developer performs complex, hands-on development work across development, test, and production environments. This position requires strong expertise in application development, system integration, database development, and DevOps practices, with a primary emphasis on API-driven data exchange and enterprise integration solutions that support high-availability justice systems.

As a member of the JUSTIS development team, the Principal System Integration Engineer is responsible for the design, development, enhancement, and operational support of the JUSTIS Data Exchange Hub and its associated integration services. The developer plays a hands-on role in ensuring that justice data flows reliably, securely, and efficiently between partner agency systems.

This position requires a strong balance of technical depth, operational awareness, and collaboration, as the work directly supports mission-critical justice operations across multiple City agencies.

Essential duties include, but are not limited to, the following:

Application & Integration Development

• Design, develop, and maintain RESTful APIs and backend services that support real-time criminal justice data exchange.
• Build reusable, testable server-side components using Python and Java to support system integrations.
• Implement and maintain secure integration patterns using REST, JSON, and event-driven approaches; maintain working knowledge of SOAP and XML as required.
• Develop and maintain database structures, including tables, views, and PL/SQL procedures, primarily using Oracle (12c/19c).

System Integration & Operational Support

• Support integration services across development, testing, and production environments for 24x7, mission-critical systems.
• Collaborate with architects, analysts, and partner agencies to design integration solutions that meet operational needs and long-term sustainability goals.
• Troubleshoot and resolve complex integration, performance, and data-quality issues in production and pre-production environments.
• Monitor and support system reliability, availability, and performance in coordination with technical leadership.

DevOps, Quality & Release Management

• Implement and support CI/CD pipelines to ensure consistent, reliable, and auditable deployments.
• Participate in code reviews to ensure adherence to development standards, security requirements, and maintainability.
• Develop and maintain unit and integration tests to support software quality and system stability.
• Support release planning, deployment activities, and post-release validation.

Security, Compliance & Data Stewardship

• Design and implement solutions that comply with CJIS and other criminal justice security and privacy requirements.
• Apply secure coding practices and support audits, reviews, and compliance activities as required.
• Ensure appropriate logging, access controls, and monitoring are implemented across integration components.
• Work collaboratively as part of a cross-functional development team supporting the JUSTIS platform.
• Communicate technical concepts clearly to both technical and non-technical stakeholders.
• Contribute to technical documentation, system diagrams, and operational support materials.
• Support teammates and share knowledge to strengthen the overall capability of the JUSTIS team.

Appointment Type:
Temporary Exempt (TEX), Full Time position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointing officer. The anticipated duration of this project position is thirty-six (36) months.

Work Location:
Incumbent will conduct most of the work at the Department of Technology, 1 South Van Ness Avenue, San Francisco, CA 94103. However, there may be situations where the incumbent will be required to work at other sites throughout the City and County of San Francisco as necessary.

Nature of Work:
This is a full-time position. The department supports a hybrid work schedule in compliance with City & County of San Francisco policies on remote work, which currently requires onsite work of a minimum of two (2) days per week.

Position may require sufficient strength and coordination for lifting, pushing, pulling and/or carrying the weight of computer equipment. May require hand/eye coordination and manual dexterity for data entry. May involve extensive VDT exposure.

How to qualify

Minimum Qualifications

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

Experience:
Five (5) years of 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 or forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

Desirable Qualifications

• At least 8 years of experience developing and supporting enterprise-scale applications or system integrations.
• Strong experience designing, developing, and maintaining APIs and integration services in production environments.
• Demonstrated expertise with Python and object-oriented programming languages such as Java, C#, or C++.
• Advanced experience with relational databases, including Oracle, PL/SQL, and complex SQL development.
• Experience with event-driven or message-based integration patterns and middleware technologies.
• Proficiency with CI/CD pipelines, version control systems (Git), and modern DevOps practices.
• Strong unit testing, debugging, and performance-tuning skills.
• Experience working in highly regulated environments involving sensitive or protected data.
• Familiarity with criminal justice, public safety, or government data-sharing systems is highly desirable.
• Experience working in Agile or iterative development environments.
• Demonstrated ability to work effectively in high-availability, high-stakes operational environments.
• Strong collaboration skills and a proven willingness to support and mentor team members.
• Experience leveraging AI-assisted development tools (e.g., GitHub Copilot, ChatGPT) to improve productivity, code quality, and documentation.
• Bachelor’s degree in computer science, information systems, engineering, or a closely related field.

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 meet the minimum qualifications requirement by the final application deadline unless otherwise noted.

What else should I know?

Selection Procedures
The selection process will include evaluation of applications in relation to minimum requirements and assessment of candidates’ job-related knowledge, skills and abilities. Depending on the number of applicants, the Department may establish and implement additional screening mechanisms to evaluate candidate qualifications. This typical includes an oral interview and/or a written or performance exercise.

If this becomes necessary, only those applicants whose qualifications most closely meet the Department needs will be invited to continue in the selection process. Applicants meeting the minimum requirements are not guaranteed advancement in the selection process.

Additional Information Regarding Employment with the City and County of San Francisco:

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.

We are committed to ensuring that the City's services are inclusive, efficient, equitable, and culturally competent for San Franciscans of all races, ethnic backgrounds, religions, and sexual orientations. This commitment requires comprehensive review and thorough analysis of existing practices and policies to remove barriers to real inclusion.

We are also committed to ensuring that we have a safe, equitable, and inclusive workplace for individuals of all races. This includes creating opportunities for hiring, promotion, training, and development, for all employees, including but not limited to Black, Indigenous, and people of color (BIPOC).

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.