RFP Title: JUDICIAL BRANCH DATA WAREHOUSE AND DATA INTEGRATION SERVICES
RFP Number: IT-2023-58-DM
REQUEST
FOR
PROPOSALS
JUDICIAL COUNCIL OF
CALIFORNIA
REGARDING:
JUDICIAL BRANCH DATA
WAREHOUSE AND DATA
INTEGRATION SERVICES
RFP NO: IT-2023-58-DM
PROPOSALS DUE:
April 19, 2024, NO LATER THAN 1:00 P.M.
(PACIFIC TIME)
1
rev December 2023
RFP Title: JUDICIAL BRANCH DATA WAREHOUSE AND DATA INTEGRATION SERVICES
RFP Number: IT-2023-58-DM
1.
BACKGROUND
1.1 Judicial Council of California and Superior Courts of California
The Judicial Council of California (the “Council”) is the policymaking body of the California courts, the
largest court system in the nation. Under the leadership of the Chief Justice, and in accordance with the
California Constitution, the council is responsible for ensuring the consistent, independent, impartial,
and accessible administration of justice. Council staff help implement the council’s policies and provide
services to the following Judicial Branch Entities (JBE):
▪ The Supreme Court of California,
▪ The Courts of Appeal,
▪ The 58 Superior Courts of California located in each of the 58 counties,
▪ The Habeas Corpus Resource Center (HCRC),
▪ The Commission on Judicial Performance (CJP), and
▪ The COUNCIL. There are two locations for the Council: San Francisco and Sacramento
1.2 Judicial Branch Data Analytics-Data Integration Program (DA/DI)
The Judicial Council and the Courts of California are looking to modernize use of data analytics in the
judicial system. In 2021, a Data Analytics Pilot Program (“Pilot Program”) was established to
demonstrate the use of data analytics to help the courts and the judicial branch obtain better insight to
improving access and services for the citizens of California. Through the Pilot Program, the Council was
able to develop a common, centralized data warehouse platform (the “Platform”) unifying data from
several different case management systems into a single, cloud-based warehouse that could be used for
analytical purposes. The Pilot Program was designed to help courts use data more effectively to
understand business practices and obtain better insight into improving access and services for the
citizens of California. The Platform enables the Council and the courts to collect, analyze, and report
data to support multiple initiatives and meet legislative and other reporting requirements.
The program’s goals include:
• Build on the established Pilot Program and successfully onboard six (6) new court participants
onto the Platform. Additional courts may be added at the Council’s election.
• Build on the established Pilot Program and successfully onboard the remaining four (4) Courts of
Appeal to the Platform.
• Create new CARE Act and Community Mental Health datasets, dashboards, and reports.
• Add data from two additional datasets: the CARE Act and Community Mental Health, as described
further below.
• Load case-level data for the onboarding courts and the new datasets into the Platform for analytics
and business intelligence dashboards. Incorporate the new court participants into existing
dashboards.
2
rev December 2023
RFP Title: JUDICIAL BRANCH DATA WAREHOUSE AND DATA INTEGRATION SERVICES
RFP Number: IT-2023-58-DM
• Onboarding of Courts
Onboarding is the connection of California courts to the Platform so that the courts can take
advantage of the functions and features of the Platform for their reporting and management
needs. The Platform combines data from various case management systems into a central
repository for data analysis. Onboarding provides courts with timely access to business data
dashboards for leadership decision making and to easily compare certain statistics for trial and
appellate courts.
At a high level, onboarding is achieved by:
1. Establishing a connection between the courts and their new Platform.
2. Mapping of case management data to a common data dictionary.
3. Testing and validating the courts’ data submissions to ensure sufficient data quality.
1.3 Judicial Branch Statistical Information System (JBSIS)
The Superior Courts report aggregate counts of filings, dispositions, and other workload indicators
using the Judicial Branch Statistical Information System (“JBSIS”). JBSIS fulfills the Council’s
requirement to report on the business of the Courts and is used as the basis for workload models that
allocate resources to courts based on the number of and type of matters heard in courts. Courts are
required to submit reports to JBSIS on a monthly basis. Because of the connection to funding, it is
critical that the data submitted are accurate, timely, and auditable. The specific data elements required
to be collected are specified in the JBSIS manual and in data matrices that are used to map the Court
Statistics Report and the workload models that are used for allocations of staff and judicial officers.
1.4 Community Assistance Recovery and Empowerment (“CARE”) Act
Community Assistance Recovery and Empowerment (CARE) will require data collection and reporting
to meet legislative guidelines. The CARE Act (SB 1338) creates a new pathway to deliver mental
health and substance use disorder services to the most severely impaired Californians who too often
suffer in homelessness or incarceration without treatment. The CARE Act moves care and support
upstream, providing the most vulnerable Californians with access to critical behavioral health services,
housing, and support.
CARE recognizes that to serve those with the most complex behavioral health conditions, we must do
the hard work of prioritizing those who need help the most, providing a comprehensive CARE plan that
3
rev December 2023
RFP Title: JUDICIAL BRANCH DATA WAREHOUSE AND DATA INTEGRATION SERVICES
RFP Number: IT-2023-58-DM
honors self-determination to the greatest extent possible, and holding ourselves accountable to
delivering services and housing that are key to long term stability and recovery.
1.5 Community Mental Health Services
The Council provides State Department of Health Care Services (“DHCS”) with data from each
Superior Court annually to support the Community Mental Health Services (“CMHS”) program’s
legislatively mandated data collection and reporting. The court data includes the number and outcomes
of certification review hearings held pursuant to Welfare and Institutions Code section 5256, petitions
for writs of habeas corpus filed pursuant to Welfare and Institutions Code section 5275, judicial review
hearings held pursuant to Welfare and Institutions Code section 5276, petitions for capacity hearings
filed pursuant to Welfare and Institutions Code section 5332, and capacity hearings held pursuant to
Welfare and Institutions Code section 5334 in each Superior Court.
1.6 The Request for Proposals (RFP)
The Council seeks information technology (IT) data analytics, data migration, integration, and
implementation, and data warehouse support (Data Services) to address the evolving data analytic needs
of the Council. Accordingly, this RFP seeks proposals from interested vendors (Proposers) that can
provide Data Services support by meeting the needs identified in the Statement of Work (Exhibit 1).
The goal of this RFP is to establish an agreement for an initial three (3) year term, with three (3)
additional consecutive one-year option terms for a potential maximum term of six (6) years. The
initial term of the Agreement is anticipated to cover the period of 6/30/2024 through 6/29/2027
(estimated).
The Council reserves the right to reject all proposals, to amend or cancel this RFP, to award an
Agreement in whole or in part and/or negotiate any or all items with individual Proposers if it is deemed
in the Council’s best interest, or to not award any Agreements based on submitted proposals.
2.
DESCRIPTION OF SERVICES
2.1 Scope
The Council seeks to contract with a single organization to provide Data Services associated with cloud-
based data warehousing, data visualization and reporting, and automated data integration capabilities to
support the Council and the courts of California. The scope of the RFP is to select a service provider
that can provide analysis, design, development, and rollout of data integration services associated with
the Platform.
4
rev December 2023
RFP Title: JUDICIAL BRANCH DATA WAREHOUSE AND DATA INTEGRATION SERVICES
RFP Number: IT-2023-58-DM
Preferred Requirements
Proposer shall have:
1. Five (5) years of experience with Snowflake data warehouse/data share-house technology.
2. Five (5) years of experience in architecting and implementing end-to-end, large scale Data
Integration projects with proven track record in ETL/ELT (Extract, transform, and load/extract,
load, and transform) processes using Talend Data Fabric.
3. Five (5) years of experience in designing and developing descriptive and predictive analytics
dashboards and reports using Power BI.
4. Five (5) years of experience in designing and implementing secure, enterprise grade cloud
infrastructure using MS-Azure, preferably in a Government Cloud environment.
5. Three (3) years of experience in design and execution of security implementations using Azure
AD.
2.2 Business and Technical Requirements
The Business and Technical Requirements (Exhibit 2) describes in detail the requirements for areas
of design and development, cloud data warehousing, automated data integration, automated data
collection and processing platform, data analytics, visualization and reporting platform, implementation
and testing.
5
rev December 2023
