Data Engineer

Job Description and Duties

This is a reposting. If you previously submitted an application for this position, you do not need to reapply.

This position supports the California Department of Education's (CDE) public reporting efforts and is a key position in supporting the DataQuest modernization project. DataQuest is CDE's public data and statistics publishing portal.

The position will work with the Application Support Unit II, the Analysis, Measurement & Accountability Division and data warehouse implementation team to develop report data requirements, lead data source development for integration into BI reports and a public facing webapp.

Duties include:

• Work with program staff and management to understand individual needs of the existing reports, including aggregations, visualizations, and data sources.

• Work with program staff and management to identify and current business and data workflows

• Analyze current business processes and make recommendations for improvement (As Is - To Be)

• Build pipelines, notebooks and semantic models in Azure warehouse environment for BI reports and webapp integration.

Maintain knowledge of CDE's business processes, data, and transactional applications. Participates in complex development efforts and analyzes data relationships and map source data to BI data warehouse targets. Validates data integration results and automates data refreshes by scheduling jobs. Recognize and apply technology trends and industry best practices related to data warehousing, reporting, and analysis.

Personal Leave Program 2025

Effective July 1, 2025, the State of California implemented the Personal Leave Program (PLP) 2025. This position is subject to PLP 2025 and will have a monthly base pay reduction of 3% in exchange for 5 hours of leave credits through June 2027. The salary range(s) shown on this job posting does not reflect the salary reduction.

CDE is an E-Verify employer. E-Verify is a web-based system that allows enrolled employers to confirm the eligibility of their employees to work in the United States. Additionally, this position is not eligible for visa sponsorship.

For more information click here: 

You will find additional information about the job in the .

Working Conditions

HYBRID

This position is headquartered in Sacramento and may be eligible for a hybrid telework schedule for eligible applicants residing in California. Currently, the hybrid telework schedule includes working remotely and working a minimum of 2 days per week in the office.

Special Requirements

To be considered for this job opportunity, applicants must be reachable on an employment list, have transfer eligibility, or have reinstatement eligibility. If you are new to California State service and you do not have list eligibility, you must take the exam for this classification.

The examination bulletin(s) may be viewed on the California Department of Education Web page at: or at the link below:

Information Technology Specialist I:

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 with continuous integration/continuous delivery workflows in an Agile environment
• Experience working with confidential data, and/or secure data environments
• Experience using dev ops tools (Azure DevOps, JIRA, Confluence)
• Experience eliciting and developing requirements, and documentation for data based projects.
• Experience with data engineering in a cloud environment.

Benefits

The State of California provides comprehensive benefits packages determined by the employee’s bargaining unit. Some of these benefits include:

• Medical benefits, including health, dental, and vision insurance

• Paid holidays: 11 paid State holidays, 1 personal paid holiday, and 2 professional development days

• 401(k) and 457(b) Plans (Savings Plus)

• Employee Assistance Program

• Commute Program

More benefit information can be found on CalHR’s website: Benefits Summary

Important Application Instructions

• How to Apply for state jobs:
• Electronic applications submitted through your CalCareer account are highly recommended.
• DO NOT include any confidential information on any documents you submit for this job vacancy. Confidential information that should be excluded or removed from these documents includes, but is not limited to, your Social Security Number (SSN), birthdate, age, student identification number, driver license (unless required), examination results, LEAP status, and marital status.
• Incomplete or late application packages will NOT be considered.
• For experience to be considered, your STD 678 (state application) must be complete and include dates, accurate hours per week, total time worked, duties and responsibilities, and contact names and phone numbers of supervisors. Applications that are submitted blank or with “see resume” in place of duties performed will be considered incomplete.
• For civil service classifications, do not use working titles.
• If you choose not to submit electronically and are mailing or dropping off your hard copy State Application (STD. 678), use the revised 06/2024 version.
• If you are using education to meet the minimum qualifications, you must submit a copy of your transcripts or diploma. Foreign transcripts must be accompanied by an academic credential evaluation. List of approved agencies:
• Please note that the CalCareer system will not allow you to make changes to your application once it is submitted.
• Candidates who reside outside of the State of California may be admitted to the job interview but must provide proof of residence in California prior to being eligible for appointment.

For general information about getting a job with the state, please view the job series videos here:

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.
• Other - Cover Letter
• Statement of Qualifications -

  Interested individuals MUST submit a Statement of Qualifications (SOQ) with their application. Resumes, letters, and other materials do not take the place of the SOQ. The SOQ should have a title of “Statement of Qualifications, Your Name ,” be no more than 2 pages, no smaller than 12-point font, and address the following:
  

  1. Describe your experience gathering and documenting data or reporting requirements from stakeholders with different levels of technical expertise, and how you translated those requirements into actionable development work.

  2. Describe your experience designing, developing, or supporting data pipelines, databases, and business intelligence or analytics solutions. Include tools or technologies you have used.

  3. Describe your experience defining As Is / To Be data processes or workflows.