INFORMATION TECHNOLOGY SPECIALIST II

State of California•Sacramento, CA

84d•Hybrid

About The Position

Do you enjoy working in a fast-paced Hybrid Centered environment with variety in your work? The California Department of Insurance (CDI) is seeking a dynamic Information Technology Specialist II with experience in enterprise data architecture and modern cloud-based warehouse data solutions. If this is you, then CDI may be the employer for you! The IT Specialist II serves as the Senior Data Analyst for CDI Information Technology Division (ITD) within the Software Engineering and System Engineering domains. The incumbent is responsible for providing vision, leadership, analysis and design expertise in creating and executing an enterprise data strategy applying advanced technical understanding and knowledge of data modeling and data analysis principles to accommodate needs of the department. Effective July 1, 2025, the California Department of Human Resources (CalHR) implemented the Personal Leave Program (PLP) 2025 and related Pay Differential 386. PLP 2025 requires employees to receive a reduction in pay in exchange for monthly hours of PLP 2025 leave credits. The salary range(s) included on this job posting do not reflect the reduction in pay. For more information, visit the CalHR website (www.calhr.ca.gov). Please, take two minutes to check us out or provide your feedback. You will find additional information about the job in the Duty Statement.

Requirements

Exam list eligibility - refer to exam link below.
Transfer eligibility, if applicable, for current/former civil service employees
Statement of Qualifications
Resume

Nice To Haves

Seven (7) years or more of progressively responsible experience in enterprise data architecture, including database design, data modeling, and data governance.
Five (5) years or more of hands-on experience with Microsoft SQL Server, including performance tuning, security, and backup/recovery strategies
Three (3) years or more of experience with Snowflake or other modern cloud-based data warehouse solutions.
Three (3) years or more of experience with ETL tools (e.g., SSIS, Informatica, Azure Data Factory, or Scribe).

Responsibilities

Providing vision, leadership, analysis and design expertise in creating and executing an enterprise data strategy
Applying advanced technical understanding and knowledge of data modeling and data analysis principles to accommodate needs of the department

Benefits

Flexible work hours
Remote work options
Medical Benefits - including health, dental,and vision insurance
Employee Wellness Program
Employee Assistance Program
On the Job Training
Career Services Program
Recognition Program
Paid Holidays and leave
Defined benefit retirement program
Savings Plus Program (401 (k), 457)
Every 12 months, based on performanceevaluation, employees may receive a 5%salary increase until they reach the maximum salary for the position.