IT Business Strategy Architect

Job Description and Duties

This position is being re-advertised. To be considered for this recruitment you must submit your application and all required documents to this Job Control.

Do you enjoy working in a fast-paced environment with variety in your work? The California Department of Insurance (CDI) is seeking a dynamic IT Business Strategy Architect with experience developing and optimizing Snowflake data warehouse structures, proficiency using Sigma Computing to build interactive dashboards, analytical models, and performant visualizations based on large regulatory or actuarial datasets, and knowledge of actuarial data structures, insurance rate-related datasets, and analytical workflows used in regulatory or Proposition 103 environments.

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

Under the administrative direction of the Information Technology Manager II in the Business Technology Management Bureau (BTMB), the Information Technology Specialist III (ITS III) serves as the California Department of Insurance’s, senior-level data architect responsible for designing, implementing, and governing enterprise-wide data modeling, data analytics, and business intelligence (BI) enterprise solutions. This position also transforms regulatory, actuarial, and operational data into actionable insights, dashboards, predictive models, and strategic recommendations that support executive decision-making. The ITS III leads high priority data analytics initiatives with broad authority and independence to design and build data models and implement analytic tools that translate complex regulatory, actuarial, and operational needs into actionable insights, dashboards, data visualizations, and strategic recommendations. This role oversees future-state data solutions aligned with business objectives across software engineering, systems engineering, and project management domains.

This position is designated under the Conflict of Interest Code. The position is responsible for making or participating in governmental decisions that may potentially have a material effect on personal financial interests. The appointee is required to complete a Statement of Economic Interest (Form 700), which includes an Assuming Office filing within 30 days of appointment, annual filings, and a Leaving Office filing within 30 days of physical separation. Non-compliance with the Conflict of Interest Code requirements may result in the voiding of appointment, financial penalties, or enforcement actions.

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 ( New to state service? Learn how to apply

Please, take two minutes to or .

You will find additional information about the job in the .

Working Conditions

• The incumbent must be able 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 will/may include overnight stay.
• Overtime may be required.
  

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 - refer to exam link below.
• Transfer eligibility, if applicable, for current/former civil service employees
• Statement of Qualifications
• Degree and/or School Transcripts
• Resume

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:

• Experience developing and optimizing Snowflake data warehouse structures, including schemas, virtual warehouses, and ELT/ETL pipelines.
• Proficiency using Sigma Computing to build interactive dashboards, analytical models, and performant visualizations based on large regulatory or actuarial datasets.
• Ability to convert Microsoft Excel Actuarial Tools to Sigma Computing Worksheet to build interactive dashboards, analytical models, and perform visualizations based on large regulatory or actuarial datasets.
• Strong understanding of actuarial data structures, insurance rate-related datasets, and analytical workflows used in regulatory or Proposition 103 environments.
• Demonstrated ability to design secure, scalable cloud-based data architectures and implement data governance, access controls, and data quality frameworks.
• Experience collaborating with actuarial teams to translate analytical requirements into data models, transformations, and analytics solutions.
• Proven ability to integrate modern cloud data platforms with legacy regulatory systems, resolving data quality and mapping challenges.
• Excellent communication skills with the ability to explain complex technical concepts to non-technical staff, leadership, and program stakeholders.

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.

Examination Information

Step 1 - If you have not taken the Information Technology Specialist III examination, or if your eligibility has expired, and/or you have no other type of eligibility, you MUST take the examination to be eligible for appointment. Please click the link provided below for the examination information and instructions.

Information Technology Specialist III: Exam Bulletin

Step 2 - Submit your application including all required documents, by using the "Apply Now" button found at the top of this bulletin.

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 - Instructions may be found in the Statement of Qualifications Section of this job posting.