Job Posting: Senior Data AI Engineer

Department of Insurance

JC-538244
-
Senior Data AI Engineer
INFORMATION TECHNOLOGY SPECIALIST II

$8,625.00 - $11,557.00 per Month
New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

Final Filing Date: 11/23/2026

Job Description and Duties

This recruitment may be used to fill multiple vacancies in this location.

This position is pending budgetary approval.

Do you enjoy working in a fast-paced environment with variety in your work? The California Department of Insurance (CDI) is seeking a dynamic Senior Data AI Engineer with experience in software development, data engineering and/or architecture, including data warehouse and/or data lake and/or data mart design, data modeling and/or data governance.

 

If this is you, then CDI may be the employer for you!

 

Under general direction of an Information Technology (IT) Manager I, the IT Specialist II serves as the Senior Data Artificial Intelligence (AI) Engineer for the California Department of Insurance (CDI) Information Technology Division (ITD). This position operates within the Data Engineering, Analytics and Software Engineering domains, and is responsible for the analysis, design, development and implementation of CDI’s Snowflake-based data stores, e.g.. data warehouse, data marts, data lakes, cloud data pipelines, data integration, sanitation, conceptual and physical data modeling, Sigma data analytics, data visualization and data security. The incumbent develops and supports CDI's data intensive applications, business intelligence, diagnostic, predictive and prescriptive analytics solutions while providing technical leadership, analysis and design expertise in the development and execution of CDI’s enterprise data strategy.

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


New to state service? Learn how to apply
here.

 

Please, take two minutes to check us out.

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

Working Conditions

  • Ability to work in a high-rise building.
  • Ability to transport documents and/or equipment up to 15-20 lbs., i.e. laptop computers, files, reference manuals, solicitation documents, etc.
  • The incumbent may telework in accordance with CDI's Telework Policy. Teleworking employees may be required to report to their headquarters office location on designated telework days. Travel expenses are not reimbursed; however other authorized transit subsidies do exist for those who qualify.
  • Occasional travel may be required within and/or outside the state of California via private or public transportation (i.e., automobile, airplane, etc.). Travel may include overnight stay. Extended work hours may occur depending on business demands.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Position Details

Job Code #:
JC-538244
Position #(s):
413-105-1414-015
413-105-1414-012
Working Title:
Senior Data AI Engineer
Classification:
INFORMATION TECHNOLOGY SPECIALIST II
$8,625.00 - $11,557.00 A
New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.
# of Positions:
2
Work Location:
Sacramento County
Telework:
Hybrid
Job Type:
Permanent, Full Time

Department Information

The CDI is the consumer protection agency for the nation's largest insurance marketplace and safeguards all of the state’s consumers by fairly regulating the insurance industry. With annual direct premiums of $340 billion, California is the largest insurance market in the United States and the fourth largest insurance market in the world.

 

Nearly 1,400 dedicated employees work at CDI to oversee more than 1,400 insurance companies and license more than 425,000 agents, brokers, adjusters, and business entities.

 

ADMINISTRATION AND LICENSING SERVICES BRANCH
INFORMATION TECHNOLOGY DIVISION
APPLICATION DEVELOPMENT & MAINTENANCE BUREAU

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

Special Requirements

Please attach (upload) all the required documents to verify that you meet the minimum qualifications for this position (i.e., degree, transcript, license, certificate). If you fail to provide the required documentation, your application package will be marked as incomplete and not considered for an interview.

 

  • Exam list eligibility
  • Transfer eligibility, if applicable, for current/former civil service employees
  • Statement of Qualifications
  • Resume

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: 11/23/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 www.CalCareers.ca.gov. 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 Insurance
CDI Jobs Inquiries
Attn: Classification & Consultation Unit
Human Resources Management Division
300 Capitol Mall, 13th Floor
Sacramento, CA 95814

Address for Drop-Off Application Packages

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

Department of Insurance
CDI Jobs Inquiries
Classification & Consultation Unit
Human Resources Management Division
300 Capitol Mall, 13th Floor
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 www.CalCareers.ca.gov. 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 - Instructions may be found in the Statement of Qualifications Section of this job posting.
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:
  • Extensive experience in software development, data engineering and/or architecture, including data warehouse and/or data lake and/or data mart design, data modeling and/or data governance.
  • Strong background and hands-on work experience with database schema design, development, complex SQL queries implementation and SQL queries performance tuning, data security at rest and in motion, and data backup/recovery strategies.
  • Knowledge and expertise with Snowflake or other cloud-based data warehouse solutions.
  • Extensive work experience in data analytics, data algorithms, data presentation, data security.
  • Deep Knowledge of AI/ML and prompt engineering, working with large language models.
  • Experience with ETL and Data Cataloging tools (e.g., Snowflake Data Pipelines, Azure Data Factory, AWS Glue, AWS Data Catalog, Scribe, Talend, etc.).

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 performance evaluation, employees may receive a 5% salary increase until they reach the maximum salary for the position.

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: http://www.insurance.ca.gov
Human Resources Contact:
Classification & Consultation Unit
(916) 492-3300
CDIJobinquiries@insurance.ca.gov

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:
EEO Officer
(916) 492-3024
OCR@insurance.ca.gov
California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.

Statement of Qualifications

All interested candidates must submit a completed Statement of Qualifications (SOQ) in order to be considered for this position. Applications received without a response to all questions will not be considered. Resumes, cover letters, and other materials do not take the place of the SOQ.

The SOQ is a narrative discussion of your education, training, experience, and skills as it relates to Duty Statement and desirable qualifications listed above. 
The SOQ should not be more than 3 pages in length, formatted in 12pt Arial font, have one inch (1") margins at the top bottom and sides, include a centered header on each page with the Job Control, and titled "Statement of Qualifications". The SoQ should address each of the following questions:

  1. Provide an example of a major data migration and/or data modernization and/or data warehouse and/or data lake and/or data mart system optimization project you led. Describe the tools, technologies, and methodologies you used (e.g., Power BI, Sigma, ETL tools, Snowflake, Microsoft Dynamics CRM, Share Point, big data technologies). Explain the challenges you faced, your approach to solving them, and how your leadership contributed to the success of the project.
  2. Describe your work experience designing and developing ETL (extract, transform and load) data pipelines including using cloud technologies. Please include the technologies you used. Describe how you secured and scaled the data pipelines.
  3.  Describe your work experience using AI/ML and prompt engineering technologies, working with LLMs (large language models), integrating AI/ML solutions into data pipelines and applying secure and responsible AI/ML practices.

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.

Application Methods:
Electronic (Using your CalCareer Account)
By Mail
Drop-off