JUSTIS Senior IS Business Analyst - Department of Technology (1053) - job 1 of 2

Announcement is reopening to accept additional applications.  Applicants that have already applied, do not need to reapply. 

IMPORTANT: Your application MUST include responses to the supplemental questionnaire found here: https://forms.office.com/g/e1Jn7K5aXh

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

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.

Are you ready to make an impact in one of the most innovative cities? The 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 

• Enterprise Application Services 

• 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 IT team!  

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.

The Department of Technology (DT) is looking for an Senior IS Business Analyst responsible for performing all aspects of the design, development, integration, installation, maintenance, and support of the JUSTIS data exchange HUB. The Senior IS Business Analyst 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 Senior IS Business Analyst must perform work of a complex, technical nature and require a high level of functional and technical skills.

The Senior IS Business Analyst 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 the general direction of the IS Technical Project Director, this position will be responsible for creating, designing, and maintaining the JUSTIS data exchange HUB that supports sharing of data via system integration or web bases application portal.

Position Responsibilities

• Be part of the team to design, develop and maintenance reusable, testable server-side components such as PL/SQL procedures, develop system integration, and build and maintain web application front end using PL/SQL, Oracle APEX, Python, Java, etc.
• Create and maintain database tables, views, PL/SQL procedures using Oracle 10g, 12C and 19C
• Experience in system integration and data exchange using JSON, and working knowledge of SOAP and XML
• Implement and maintain functions and reports. 
• Create data visualizations with tools like PowerBI.
• Review, verify, and validate the PL/SQL code developed in the project.
• Ability to work with other team members and willing to assist teammates in performing tasks listed above.

Nature of Work:

Incumbent will conduct the majority of work at the Department of Technology, 1 south Van Ness in San Francisco.  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 four days in the office every two weeks.

Education:

An associate degree in business administration, public administration, information systems, economics, finance, computer science or a 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 one of the fields above or a closely-related field].

Experience:

Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

License and Certification:

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 one of the fields above or a closely related field.

Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

Desired Qualifications:

• Knowledge of Oracle SQL PL/SQL, Python, Java, HTML, CSS, Data Catalog.
• Strong interpersonal skills, ability to interact with people at all levels. 
• Good organization, writing, communication and presentation skills.
• Criminal Justice Systems Business Analyst Experience

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

Note:

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

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. 

Nature of Work 

The incumbent must be willing to work on-site at our San Francisco office in person four days a week and one day remote (for a total of 40 hours - specify the work schedule; for example, a 40-hour week) as determined by the department. Travel within San Francisco may be required. 

Compensation:

• $126,958 to $159,744 (annually) 

How to Apply:

• Applicants are encouraged to apply immediately as this recruitment may close at any time, but not before Friday, June 20, 2025. 
  • 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:https://forms.office.com/g/e1Jn7K5aXh  
  • You may contact Jason Wong via email at [email protected] with questions regarding this opportunity. 

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

Helpful Information

• Information About The Hiring Process
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Veterans Preference
• Right to Work
• Copies of Application Documents
• Diversity Statement

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.  

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.