Business Intelligence Specialist

Under direction of the Business Intelligence and Enterprise Data Operations (EDO) Section Chief, the incumbent supports departmentwide data management to provide quality data and data access to the Department of Developmental Services' (Department) data requesters. The incumbent prepares data extractions and develops data marts, using our enterprise data warehousing solution in support of end user reporting, analysis, and data visualizations. The incumbent works with the business intelligence leads and the data engineering team to develop complex data marts, primarily using T-SQL. The incumbent takes part in quality improvement activities to support data sharing, data ingestion, data transfers between internal and external entities, and data operations within the EDO Section.

Effective July 1, 2025, State employees are subject to a salary reduction of three percent in exchange for five hours per month of the Personal Leave.


You will find additional information about the job in the Duty Statement .

Working Conditions


Open-spaced partitioned offices. Prolonged periods on a computer.

Under Government Code 14200, this position is a hybrid, in-office/telework position, and may be subject to change. Incumbent can be required to report to the office, or any designated location at any time. Telework agreements can be modified and/or cancelled at any time. All commute expenses to the reporting location will be the responsibility of the selected candidate.


Pursuant to California Government Code requirements, candidates must be residents of the State of California at the time of appointment.


This position requires lawful authorization to work in the United States. The Department does not sponsor employment visas for this position.


Minimum Requirements You will find the Minimum Requirements in the Class Specification.

• INFORMATION TECHNOLOGY SPECIALIST I

Additional Documents

• Job Application Package Checklist
• Duty Statement

Position Details Job Code #:
JC-522852


Position #(s):
472-518-1402-917

Working Title:
Business Intelligence Specialist


Classification:
INFORMATION TECHNOLOGY SPECIALIST I $6,513.00 - $8,729.00 A
$7,163.00 - $9,599.00 B
$7,864.00 - $10,537.00 C
New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.


# of Positions:
1


Work Location:
Sacramento County


Telework:
Hybrid


Job Type:
Permanent, Full Time


Department Information
The California Department of Developmental Services (Department) is the agency through which the State of California provides services and supports to individuals with developmental disabilities.


These disabilities include intellectual disability, cerebral palsy, epilepsy, autism and related conditions. Services are provided through state-operated developmental centers and community facilities, and contracts with 21 nonprofit regional centers. The regional centers serve as a local resource to help find and access the services and supports available to individuals with developmental disabilities and their families.


The Department is located in a modern, sustainable and innovative office building at 1215 "O" Street, Sacramento, California. Some amenities of the building include:

• First floor retail space (separate access from 12 th Street)
• Café with multiple vendors
• Outdoor seating for meal breaks
• Employee fitness center which includes a yoga studio, cardio equipment and weights
• Plaza area with kitchenette on each floor
• Lactation rooms

Department Website:


Special Requirements
The Statement of Qualifications (SOQ) must be numbered in the same order as the following areas, typed in 12-point Arial font, single spaced, include 1-inch margins and be no more than two pages in length. Applicants who fail to answer the questions or submit an SOQ may not be considered.

1. Describe your experience working with data warehousing solutions. Include specific details about your role, primary responsibilities, and the tools or platforms you used.

2. Describe your experience using an IT ticketing system, including the level of customer service you provided. Identify your customers and explain how you prioritized and managed multiple tickets simultaneously.

3. Describe your experience and skills in writing queries, data modeling, and SQL programming.

If you are using list eligibility from an on-line exam to qualify for this position, you MUST include with your application any documentation (i.e., copy of transcript, degree, license, etc.) to verify meeting the MQ's or you may not be considered for the position.

The MQs will be verified prior to interview and/or appointment. If it is determined that an applicant does not meet the MQs of the classification, the applicant may not be considered and withheld from the eligible list.


Application Instructions
Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.
Final Filing Date: 7/8/2026
Who May Apply
Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply. Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).


How To Apply
Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:


Address for Mailing Application Packages


You may submit your application and any applicable or required documents to:


Department of Developmental Services - Headquarters
N/A
Attn: Desiree Cervantes
Cert Unit
1215 O Street, MS 10-40
Sacramento , CA 95814


Address for Drop-Off Application Packages


You may drop off your application and any applicable or required documents at:


Department of Developmental Services - Headquarters
N/A
Desiree Cervantes
Cert Unit
1215 O Street, MS 10-40
Sacramento , CA 95814


08:00 AM - 05:00 PM


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 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at 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 required and must be included.
• Statement of Qualifications -
  A Statement of Qualifications (SOQ) is required and is a narrative discussion of how the candidate's education, training, experience, and skills meet the minimum and desirable qualifications and qualify them for the position. The SOQ serves as a documentation of each candidate's ability to present information clearly and concisely in writing. SEE "SPECIAL REQUIREMENTS" ABOVE FOR INSTRUCTIONS.
  

Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.


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:


Knowledge of: Database structures, theories, principles, and practices with emphasis on cloud platform; business intelligence development and implementation; data lake, data warehouse, and data mart architectures, dimensional data modeling, and slowly changing data dimensions; evolving industry trends and standards; strong organizational, analytical, and communication skills; writing T-SQL, DAX as well as experience with scripting languages such as JavaScript and Python; implementation, development, and support of Data Visualization tools such as Power BI, Tableau, and AWS services; building and designing business intelligence solutions from a technical or business perspective; installation, configuration, and stabilization of medium to large scale BI/Enterprise Reporting implementations; relational and dimensional modeling, data warehousing concepts, and methodologies; extracting data from mainframe, relational, and other data sources; securing Personal Information (PI), Personal Health Information (PHI) and other confidential data; common data visualization and user interface design techniques.

Ability to: Work both independently and in a team environment; complete work assignments in an effective, accurate, and timely manner; perform data analysis on complex data models; write complex T-SQL queries; develop data marts for delivery and reusability; analyze situations accurately and take effective action; reason logically and creatively and draw valid conclusions; foster commitment and trust; facilitate open exchange of ideas and opinions; make effective presentations to individuals or groups and perform completed staff work.


Benefits
As a state employee working for the Department of Developmental Services, you and your family will have access to excellent medical, dental and vision insurance benefits in addition to retirement benefits.


Benefit eligibility may be based on job classification, bargaining unit, time base and length of appointment. Additional benefits may also be outlined for specific bargaining units in employee collective bargaining contracts. For more information, please visit the links below:


State Employees - CalHR Benefits Website

CalPERS Health Benefit Summary 2026


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


Contact Information
The Human Resources Contact is available to answer questions regarding the position or application process.
Department Website:
Human Resources Contact:
Desiree Cervantes
View phone number on click.appcast.io
View email address on click.appcast.io


Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.
EEO Contact:
Equal Employment Opportunity Office
View phone number on click.appcast.io
View email address on click.appcast.io
California Relay Service: View phone number on click.appcast.io (TTY), View phone number on click.appcast.io (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.


Additional Information


Electronic application submission is highly encouraged.

Multiple positions may be filled from this recruitment. This recruitment may be utilized to fill future vacancies that may occur during the life of the certification list.

Possession of Minimum Qualifications will be verified prior to interview and/or appointment. If you are meeting Minimum Qualifications with education, you must include your unofficial transcripts/diploma for verification. Official transcripts may be required upon appointment. If it is determined an applicant does not meet the Minimum Qualifications, the candidate may be withheld from the eligibility list, rendering them inactive and ineligible to be hired for the position. Candidates who have been withheld may file an appeal with the California Department of Human Resources.

All appointments are subject to State Restriction of Appointment (SROA), Departmental Restriction of Appointment (DROA), Re-employment List procedures, pre-employment physical and fingerprint clearances. Further information on the definition of the above may be found on the California Department of Human Resources' website at:

If you have not taken the Information Technology Specialist I exam/assessment you may find the exam for this classification at the link below. You must take and pass the exam/assessment to obtain eligibility for hire. Click here to gain list eligibility.


Remove Any Confidential Information


Do not include any confidential information on any documents you submit for a job vacancy, such as your State application, resume, or educational transcripts.

Confidential information that should be excluded or removed from these documents includes, but is not limited to, your Social Security Number (SSN), birthdate, student identification number, driver's license number (unless required), basis of eligibility, examination results, LEAP status, marital status, and age. Confidential information on the first page of applications submitted electronically online, such as Easy ID number, SSN, examination related information, and driver's license number will automatically be redacted upon submission.


Equal Opportunity Employer
The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.


It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.