Business Systems Analyst JO#6490

Job Description and Duties

RESPONSIBILITIES

• Oversee design and implementation plan for CARE Act data reporting in Snowflake platform.

• Collaborate with IT to identify CFCC CARE Act team objectives during each phase of data warehouse development and complete tasks assigned to the CARE Act team by IT.

• Conduct UAT, ensure business requirements are represented in testing scenarios, and work with IT to rectify any issues that are discovered during UAT process.

• Lead CARE Act data management.

• Track monthly data reporting from all 58 trial courts through email, FTP, and automated methods to ensure complete reporting; communicate with court data contacts on the reporting schedule.

• Create and execute scripts to clean and validate data submissions.

• Support CARE Act data reporting and auditing processes.

• Research, design, and implement policies and procedures to resolve data mapping issues and implement data quality control protocols to ensure accuracy and completeness of data.

• Conduct internal auditing of CARE Act data to evaluate reporting quality.

Working Conditions

The Judicial Council strives for work-life balance, including substantial vacation and holiday time. In addition, we offer an excellent benefits package, including pension, medical, dental, and vision coverage, flexible spending, up to $130 per month reimbursement for qualifying commuting costs, and retirement savings plans. In San Francisco, the office is only a 7-minute walk from the downtown Civic Center BART station. In Sacramento, the office is minutes from downtown, just north of Discovery Park.

The Judicial Council offers hybrid work arrangements for many positions. The successful candidate will be expected to work in person at the Judicial Council’s San Francisco or Sacramento office at least two days per week, based on their office leader’s direction, and reside in the areas surrounding these locations.

Desirable Qualifications

In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:

MINIMUM QUALIFICATIONS

EDUCATION AND EXPERIENCE

Bachelor’s degree, and three (3) years of experience providing technical and business process

support and analysis for systems/applications. An additional four years of professional experience

as noted above may substitute for the bachelor’s degree. Or, additional directly related experience

and/or education may be substituted on a year-for-year basis.

OR

Three years as a Business Systems Coordinator, or two years as an Associate Analyst in the assigned

field, with the Judicial Council of California or three years of experience performing the duties of a

class comparable in the level of responsibility to that of a Business Systems Coordinator, or two

years as an Associate Analyst in the assigned field, in a California Superior Court or California state-

level government entity.

Desirable Qualifications:

• Proficiency in SQL.

• Expertise in database creation and management.

• Experience with Snowflake or other cloud-based data warehouse technologies.

• Familiarity with data quality assurance and validation principles.

• Knowledge of R, Python, SQL and other data management programs.

• Experience with Power BI, Tableau.

OTHER

Please note, if you are selected for hire, verification of employment eligibility or authorization to work in the United States will be required.

Benefits

HOW TO APPLY

This position is Open Until Filled and requires the submission of our official application, a resume and a response to the supplemental questions. To ensure consideration of your application for the earliest round of interviews, please apply by 5:00 P.M. on August 22, 2025.

To complete an online application, go to job opening # 6490 at

To complete the online application, please click the Apply for Job button.

The Judicial Council provides reasonable accommodation to applicants with disabilities who request such accommodation. Reasonable accommodation needs should be requested through Human Resources at (415) 865-4260.

PAYMENT & BENEFITS

$7,513 - $11,270 per month

Please note due to statewide fiscal conditions, the posted salary range is subject to a temporary 3% reduction. In exchange for this reduction, judicial branch employees accrue an additional 5 hours of paid personal leave per month through June 30, 2027.

Some highlights of our benefits package include:

• Health/Dental/Vision benefits program

• 14 paid holidays per calendar year

• Choice of Annual Leave or Sick/Vacation Leave

• 1 personal holiday per year

• Up to $130 per month reimbursement for qualifying commuting costs

• CalPERS Retirement Plan

• 401(k) and 457 deferred compensation plans

• Employee Assistance Program

• Basic Life and AD&D Insurance

• FlexElect Program

• Pretax Parking

• Long Term Disability Program (employee paid/optional)

• Group Legal Plan (employee paid/optional)

The Judicial Council of California Is an Equal Opportunity Employer.

Benefit information can be found on the CalHR website and the CalPERS website.

Supplemental Questions

To better assess the qualifications of each applicant, we will review your responses to the following questions. Please indicate for which employer you performed these functions. Your answers should not exceed a total of three pages.

1. Describe your experience with database creation and management, including your role in user acceptance testing, data management, and collaborating with business teams. Please provide specific examples that demonstrate your ability to handle such responsibilities.

2. Describe your experience using structured query language (SQL).

Required Application Package Documents

The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:

• Current version of the State Examination/Employment Application STD Form 678. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
• Resume is optional. It may be included, but is not required.