Business Systems Analyst

Overview

The Judicial Council of California is accepting applications for the position of Business Systems Analyst for the Center for Families, Children & the Courts.

This newly established position provides technical and business process support for the CARE Act database. This position will lead moderately complex technical and data engineering projects related to CARE Act data management, including oversight of the design and implementation of CARE Act data reporting in the branch data warehouse, collaboration with Information Technology (IT) and Research, Analytics, and Data (RAD) offices, deliverance of training to court data contacts, and subject matter expertise on CARE Act data collection. The position will be responsible for establishing data quality control procedures and will work regularly with court data contacts to ensure timely data reporting and validation.

The Judicial Council 
The Judicial Council of California is the policy setting body for the state court system and has constitutionally conferred statewide rule-making authority. This authority includes developing, advocating for, and allocating the judicial branch budget. A majority of Council members are California state justices and judges; however, the Council also includes lawyers, legislators, and court administrators.

By enhancing its role as a leadership, knowledge, and service resource for the judicial branch, the Judicial Council’s staff organization seeks to continue to evolve as one of California’s most dynamic public service entities, focused on improving access to justice for all Californians by innovating and responding to the changing needs of the courts and the public. As a government body charged with improving the statewide administration of justice, the Judicial Council has multiple offices with diverse responsibilities relating to court policy and operations. As employees of the council, every member of staff should view and approach their work as one Judicial Council with a public service mission that is greater than the sum of its parts.

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.
 

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.

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 Information

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

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 June 13, 2025.  

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. 

Pay and Benefits

$7,294 - $10,942 per month

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)

Equal Employment Opportunity

The Judicial Council of California Is an Equal Opportunity Employer.

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