Business Analyst Sql R Python Jobs in Oakland, CA

Salary: $4,021.15 - $4,888.47 Biweekly
Location : 400 McAllister Street, Room 205, San Francisco, CA
Job Type: Full-Time Permanent
Job Number: 2026-00029
Department: Data & Business Analytics
Opening Date: 08/05/2026
Closing Date: 8/16/2026 12:00 PM Pacific
Description
ADMINISTRATIVE ANALYST III
Data & Business Analytics
(Class Code 374C)
Current San Francisco Superior Court Employees Only
The Administrative Analyst III position in Data & Business Analytics is only open to current employees of the Superior Court of California, County of San Francisco (the Court). The Court invites applications from qualified individuals interested in the Administrative Analyst III position to provide support to the Data & Business Analytics team. The Administrative Analyst III develops SQL queries, analyzes data models, and builds data dashboards; works closely with Court judicial officers, management, and staff in the development of data solutions, including extraction and quality assurance queries; tests and validates data; executes complex detailed research and analytical assignments; manages various data analytical projects such as resource allocation modeling, program evaluation, and time studies; prepares reports; makes presentations for various internal and external audiences; executes ad hoc assignments; coordinates and actively participates in meetings, and prepares meeting materials including, but not limited to, agendas, briefing documents, meeting notes/minutes; and performs other job-related duties as required.
The Administrative Analyst III will work under the direction of the Chief Data Officer and in close collaboration with Judicial Officers, executive management staff, other staff, and the public.
This selection process is being conducted in accordance with San Francisco Superior Court Personnel Rule 4. An eligibility list will not be established.
FINAL FILING DATE: 12:00PM, August 16, 2026
COMPENSATION: $4,021.15 to $4,888.47 biweekly ($104,550 to $127,100 annually)
The Court offers a generous benefits package including a variety of health and dental insurance plans, life insurance, a contributory retirement plan, a deferred compensation savings program, paid vacation, sick leave, floating holidays, and holiday pay.
Examples of Duties
POSITION OVERVIEW
This position will be assigned to the Data & Business Analytics department, working with the Chief Data Officer in developing SQL queries for multiple data systems, building data dashboards in Power BI, analyzing data models, and performing resource allocation modeling. The position manages program data and conducts specialized research and analyses. Manages all aspects of meetings including, but not limited to, planning and developing agendas and preparing briefing documents, meeting reports, minutes, and other meeting materials.
Performs administrative and analytical assignments including, but not limited to, program and performance analyses and special projects; collects information on special issues, preparing analysis of data and developing reports as assigned; organizes information for formal presentations and makes presentations as directed; performs cost analyses to plan for future expenditures; assists with a variety of special projects as assigned.
Work is performed in an office environment with continuous contact with Judicial Officers, staff, outside agencies, and the public.
Typical Physical Requirements: Sit for extended periods; frequently stand and walk; normal manual dexterity and eye-hand coordination; lift and move objects weighing up to 25 lbs.; corrected hearing and vision to normal range; verbal communication; use of office equipment, including computer, telephone, calculator, copiers. Must be able to travel within San Francisco for work-related meetings.
Qualifications
REQUIRED QUALIFICATIONS
Any combination of training and experience which would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the required knowledge and abilities would be:
Three years of progressively responsible professional analytical work experience, preferably in a governmental setting, performing work duties related to project management, public outreach, administrative support and services, program tracking and data entry, and facilities management.
DESIRABLE QUALIFICATIONS
A bachelor's degree from an accredited college or university in business administration, public administration, or a closely related field is highly desirable.
Knowledge of:

• Functions, organizations, programs, and policies of the Court and an assigned unit or division.
• Research and information-gathering techniques.
• Project management and coordination.
• Statistical methods and analysis.
• Performance measures such as workload measures and terminology.
• Public and community outreach principles.
• Development of SQL queries.
• Microsoft Office Suite (Outlook, Word, Excel, and PowerPoint).
• Knowledge of programming languages such as R, Python, and DAX.
• Other statistical software and data management products (such as Power BI, Power Automate, and SPSS), including the ability to structure complex formulae.

Ability to:

• Plan, organize, and coordinate various data analytical functions of an assigned area of Court operations, such as SQL query development, dashboard construction, and data analytical research.
• Perform a wide variety of analytical work and research assignments.
• Oversee, coordinate, and execute projects to their conclusion.
• Organize statistical and narrative information in a clear, concise manner.
• Schedule and manage meetings with different work units and summarize and process qualitative and quantitative information obtained from them.
• Gather, maintain, and analyze a variety of information regarding division or unit operations and functions.
• Administer surveys and work with survey data.
• Organize and present ideas and recommendations both orally and in writing.
• Interpret State, Federal, and local laws, codes, and regulations regarding the area of assignment.
• Gather, maintain, and analyze a variety of information regarding division or unit operations and functions.
• Prepare comprehensive, clear reports.
• Operate a computer and use appropriate software in the performance of administrative and analytical work.
• Effectively represent the San Francisco Superior Court and an assigned unit with the public, other Court staff, and other government agencies.
• Maintain confidential information when required by legal or ethical standards.
• Establish and maintain cooperative working relationships.

Supplemental Information
HOW TO APPLY
Selection is only open to current employees of the San Francisco Superior Court. Interested individuals must apply online and include a valid email address where the applicant can receive future correspondence regarding the position. Applicants must submit ALL the following items:

• Superior Court of California, County of San Francisco, online employment application (fully completed).
• Resume.
• One-page cover letter explaining why the applicant is interested in the position, and briefly describing the experience and education applicable to the position.

The online application, resume, and cover letter are very important to the selection process. It is recommended that applicants review the information in this announcement and on the application very carefully. Once the application has been submitted, it cannot be corrected, changed, or resubmitted. All applications must be submitted by the final filing date and time indicated in this announcement.
SELECTION PROCESS
Initial Screening:
Complete application packages received by the final filing date and time will be evaluated to determine if the applicants meet the minimum qualifications. The Court will further evaluate these documents and may interview only those applicants it deems may best meet the needs of the Court. Not all applicants will receive an interview.
Oral Interview:
If necessary, selected applicants may be interviewed to determine their relative knowledge, abilities, and skill levels in job-related areas. If interviews are scheduled, it is anticipated that they will be conducted in late August 2026.
Qualified applicants with disabilities requiring reasonable accommodation to participate in the selection process should complete the relevant section of the employment application.
OTHER APPOINTMENT INFORMATION
Employment is subject to security clearance. Any false statement or omission of material fact may cause forfeiture of employment. Information presented on employment applications, resumes, and attachments, and during the selection process is subject to verification. Employees are prohibited from engaging in activities that conflict with the interests of the Superior Court of California, County of San Francisco.
THE SUPERIOR COURT OF CALIFORNIA, COUNTY OF SAN FRANCISCO, IS AN EQUAL OPPORTUNITY EMPLOYER. APPLICANTS SHALL NOT BE FAVORED OR DISCRIMINATED AGAINST BECAUSE OF RACE, COLOR, RELIGION, GENDER, NATIONAL ORIGIN, ANCESTRY, CITIZENSHIP, AGE, MARITAL STATUS, PHYSICAL DISABILITY, MENTAL DISABILITY, MEDICAL CONDITION, SEXUAL ORIENTATION, GENETIC INFORMATION, UNION ACTIVITY, POLITICAL AFFILIATION, OR OTHER NON-MERIT FACTOR.
For questions on the above information, contact the Human Resources Office of the Superior Court of California, County of San Francisco, (415) 551-0381.
01
How many years of progressively responsible professional analytical work experience do you have performing work duties related to project management, public outreach, administrative support and services, program tracking and data entry, and facilities management? (Please answer in decimal format, #.##)
02
As instructed, I have attached my resume.

• Yes
• No

03
As instructed, I have attached my one-page cover letter explaining why I am interested in the position, and briefly describing my experience and education applicable to the position.

• Yes
• No

Required Question