INFORMATION TECHNOLOGY SPECIALIST I

California Department of Developmental Services; Sacramento (CA); Hybrid; USD 72,685 - 97,415; Full time

Benefits offered by this job

Medical, dental, and vision insurance

Retirement benefits

Modern office amenities

Job summary

A state government agency in California is seeking an Information Technology Specialist I to support department-wide data management, develop data marts, and improve data quality. The ideal candidate will have experience with T-SQL and data warehousing solutions. This hybrid role offers competitive pay and requires residency in California. Interested applicants must submit a Statement of Qualifications as part of the application process.

Qualifications

• Experience with data management and data access.
• Skills in developing data marts and complex queries.
• Ability to work with business intelligence and data engineering teams.

Responsibilities

• Support department-wide data management for data report requests.
• Develop complex data marts using T-SQL.
• Participate in data quality improvement activities.

Skills

T-SQL

Data warehousing

Data analysis

Communication skills

Education

Bachelor's degree in IT or related field

Job description

Job Title

INFORMATION TECHNOLOGY SPECIALIST I

Employer

California Department of Developmental Services

Base Pay Range

$6,513.00 - $8,729.00 (Classification A)

$7,163.00 - $9,599.00 (Classification B)

$7,864.00 - $10,537.00 (Classification C)

Job Description and Duties

Under the direction of the Chief, Business Intelligence/Data Operations Unit, Enterprise Data Operations (EDO) Branch, the incumbent supports department-wide data management to provide quality data and data access to 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 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 Branch.

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

Under Government Code 14200, this position is a hybrid, in‑office/telework position, and may be subject to change. The incumbent may 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. The incumbent must live and work in California. All commute expenses to the reporting location will be the responsibility of the selected candidate.

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

Position Details

• Job Code #: JC-499911
• Position #(s): 472-518-1402-003
• Working Title: Business Intelligence Specialist
• Classification: INFORMATION TECHNOLOGY SPECIALIST I
• # of Positions: 1
• Work Location: Sacramento County
• Telework: Hybrid
• Job Type: Permanent, Full Time
• Facility: Department of Developmental Services
• Seniority Level: Entry level
• Employment Type: Full-time
• Job Function: Information Technology
• Industries: Individual and Family Services

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 Department is located in a modern, sustainable, and innovative office building at 1215 “O” Street, Sacramento, California. Amenities include first‑floor retail space, a café with multiple vendors, outdoor seating, an employee fitness center with yoga studio, cardio equipment and weights, plaza area with kitchenette on each floor, and lactation rooms.

Department Website: http://www.dds.ca.gov

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, and be no more than two pages in length. Applicants who fail to answer the questions or submit an SOQ may not be considered.

• Describe your experience with a data warehousing solution. Please be specific on your duties, role, and the solution(s) used.
• Describe your experience with using an IT ticketing system and the level of customer service you provided. Who were your customers? How did you manage the multiple tickets at once?
• Describe your experience and skills in writing queries, data modeling, and SQL programming.

If you are using list eligibility from an online 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.

Final Filing Date: 12/22/2025

Application Instructions

Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. The Final Filing Date is 12/22/2025.

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:

Department of Developmental Services – Headquarters
Attn: Mimi Hairford
Cert Unit
1215 O Street, MS 10‑40
Sacramento, CA 95814

Address for Drop‑Off Application Packages:

Department of Developmental Services – Headquarters
Attn: Mimi Hairford
Cert Unit
1215 O Street, MS 10‑40
Sacramento, CA 95814
08:00 AM – 05:00 PM

• 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 www.CalCareers.ca.gov.
• Resume is optional.
• Statement of Qualifications – A Statement of Qualifications (SOQ) is required. 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 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

• 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; slowly changing data dimensions; evolving industry trends and standards.
• Strong organizational, analytical, and verbal/written communication skills; works both independently and in a team environment; completes work assignments effectively, accurately, and timely.
• Ability to 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 oral presentations to individuals or groups.

Benefits

• 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 for specific bargaining units are outlined in employee collective bargaining contracts.
• More information can be found on the State Employees CalHR Benefits Website and CalPERS Health Benefit Summary 2025/2026.

Contact Information

Human Resources Contact:
Mimi Hairford
(916) 654‑3378
[e-mail]

EEO Contact:
Equal Employment Opportunity Office
(916) 654‑1888
[e-mail]
California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice)

Additional Information

• Electronic application submission is highly encouraged.
• Multiple positions may be filled from this recruitment.
• Possession of Minimum Qualifications will be verified prior to interview and/or appointment.
• 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.
• See the California Department of Human Resources website at www.calhr.ca.gov for additional information.
• If you have not taken the Information Technology Specialist I exam/assessment, you may find the exam for this classification at the link below (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 includes, but is not limited to, your 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, 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 workplace. 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.