Data Engineer INFORMATION TECHNOLOGY SPECIALIST I

　　$6,139.00 - $9,932.00 per Month

　　Final Filing Date: 2/9/2024

　　Job Description and Duties

　　Under the direction of the Information Technology Manager I in the Data Engineering Unit (DEU), the Information Technology Specialist I (ITSI) provides guidance and technical expertise in performing a wide variety of tasks requiring innovative problem-solving where guidance is not readily available. Assist with the implementation of effective solutions to complex business problems or technical challenges by analyzing existing systems and infrastructure to identify gaps and seek innovative solutions; maintain awareness of the technology and assist in the performance of research to advise DEU Manager on designs and best practices; possess a customer-centric mindset to effectively engage with stakeholders; articulate complex concepts for achieving business goals, identify opportunities for improvement, and solution design that drives business value.

　　The ITS I will perform duties in the Business Technology Management, Client Services, and Information Technology Project Management domains.

　　Other duties:

　　Develop and maintain data pipelines using data integration tools and custom code. Optimize pipeline performance for use with Terabyte-scale data.

　　Develop custom data views and reports for the data warehouse. Respond to ad-hoc requests for data quereies and reports.

　　Work with end-users and other DEU staff to develop relational data models for data stored in the data warehouse.

　　Minimum Qualifications (MQs): The MQs for this classification can be found at CalHR - Information Technology Series (https://www.calhr.ca.gov/state-hr-professionals/pages/1400.aspx) . The documents you submit in your application package must highlight how you meet the MQs. If the MQs are not met, you will not be considered for this position.

　　Please let us know how you heard about this position by taking a brief survey at CEC Recruitment Survey (https://www.surveymonkey.com/r/CECRecruitmentSurvey) .

　　You will find additional information about the job in the Duty Statement (https://www.CalCareers.ca.gov/CalHrPublic/FileDownload.aspx?aid=22099175&name=ITSpecIDutyStatementFINAL.pdf) .

　　Working Conditions

　　The California Energy Commission offers a hybrid workplace model that is designed to support a distributed workforce of both office-based and remote-centric workers that relies on a high level of telework. Limited-in person attendance and occasional travel may be required based on the needs of the division. Regular and consistent attendance - whether office-based or remote-centric is essential to the successful performance in this position. This position is remote-centered which means the incumbent works 50 percent or more of their time monthly from an alternate work location (i.e., teleworking).

　　Minimum Requirements You will find the Minimum Requirements in the Class Specification.

　　INFORMATION TECHNOLOGY SPECIALIST I (https://hrnet.calhr.ca.gov/CalHRNet/SpecCrossReference.aspx?ClassID=1402)

　　Additional Documents

　　Job Application Package Checklist (http://calcareers.ca.gov/CalHrPublic/Jobs/JobApplicationPackageChecklist.aspx?JobControlId=413090)

　　Duty Statement

　　Position Details

　　Job Code #:

　　JC-413090

　　Position #(s):

　　535-210-1402-952

　　535-210-1402-951

　　Working Title:

　　Data Engineer

　　Classification:

　　INFORMATION TECHNOLOGY SPECIALIST I

　　$6,139.00 - $8,228.00 A

　　$6,751.00 - $9,048.00 B

　　$7,413.00 - $9,932.00 C

　　# of Positions:

　　2

　　Work Location:

　　Sacramento County

　　Telework:

　　Hybrid

　　Job Type:

　　Permanent, Full Time

　　Department Information

　　The CEC was established by the Legislature in 1974 to address energy challenges facing the state. Today, the CEC is the state's primary energy policy and planning agency and is leading the state to a 100% clean energy future. Serving all Californians, the CEC embodies diversity, equity, and inclusion and has taken an active and meaningful role in creating an environment that enables each employee to thrive. The CEC supports a hybrid workplace model with a workforce of office-based and remote-centered workers. The CEC operates under the umbrella of the California Natural Resources Agency and shares offices with the agency in a LEED Platinum Certified Building (https://resources.ca.gov/About-Us/our-new-headquarters) in downtown Sacramento.

　　The California Energy Commission seeks two Information Technology Specialist I in the Data Engineering Unit . If you are interested in a challenging and exciting career in clean energy and are passionate about renewable, efficient, and reliable energy that addresses climate change, join our diverse team of global energy leaders! The California Energy Commission plays a lead role in creating the energy system of the future, not just in California but globally.

　　This position is open to interested applicants both inside and outside of state service. To be eligible to apply and be hired as a new-to-state-service employee, you must:

　　Create an online CalCareers (https://www.calcareers.ca.gov/CalHRPublic/CreateNewAccount.aspx) account. For a tutorial on the state application process, visit California State Hiring Process Instructional Video Series – YouTube or contact [email protected] .

　　Complete an assessment (https://www.energy.ca.gov/careers/examsassessments) and score in the top ranks. Your assessment score determines your rank.

　　Submit an application package through your CalCareers account. An application package must include all items under the “Required Application Package Documents” section. Resumes will not be accepted in place of a State Examination and Employment Application (STD. 678). Applications must include “to” and “from” dates (month/day/year), time base (full-time/part-time/number of hours per week/month), and applicable civil service classifications.

　　Department Website: https://www.energy.ca.gov

　　Special Requirements

　　You must include the following if you are applying by mail or in person:

　　1) How you are eligible (list eligibility, transfer within state service, reinstatement, SROA/surplus, etc.) in the Explanations box on the first page of the STD. 678.

　　2) The Job Control number 413090 and the title of the position you are applying for in the Examination(s) or Job Title(s) box on the first page of the STD. 678.

　　3) Request for Personnel Action Number RPA 210-365/210-366 in the Explanations box of the STD. 678.

　　4) Your original signature at the bottom of the first page of the STD. 678.

　　5) Include unofficial school transcripts with your application package if the position you are applying for has an educational requirement. You may be required to provide official transcripts if hired.

　　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: 2/9/2024

　　Who May Apply

　　Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list 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:

　　California Energy Commission

　　Attn: RPA 210-365/210-366|JC-413090

　　715 P Street, MS-3

　　Sacramento , CA 95814

　　Address for Drop-Off Application Packages

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

　　California Energy Commission

　　RPA 210-365/210-366|JC-413090

　　1516 9th Street, MS-3

　　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.

　　School Transcripts

　　Statement of Qualifications - Include an SOQ that answers the questions below. Your SOQ should be no longer than two pages, single-spaced, with no smaller than 12-point font. Applications received without an SOQ will not be considered. Visit How to Write a Statement of Qualifications for instructions. 1. Summarize your experience with data engineering and the development and maintenance of data pipelines. 2. Describe your experience with the following tools and concepts specifically and with related tools and concepts if relevant: Amazon S3, Snowflake data warehousing and Snowpipe, Data Vault 2.0 relational modeling, FiveTran, and dbt Labs’ database transformation tool (dbt). 3. Describe your experience working with Terabyte-scale data. Please provide an example of a big data challenge you worked on and how you resolved it.

　　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:

　　A minimum of 3 years of professional experience in the field of data engineering.

　　Experience with Structured Query Language, Python, principles of data warehousing and relational data models, cloud-based architecture, and data integration tools.

　　Experience with some or all of the related technology, including: Amazon S3, Snowflake data warehousing and Snowpipe, Data Vault 2.0 relational modeling, FiveTran, and dbt Labs’ database transformation tool (dbt).

　　Excellent communication and interpersonal skills.

　　Benefits

　　Benefit information can be found on the CalHR (https://www.calhr.ca.gov/Pages/California-State-Civil-Service-Employee-Benefits-Summary.aspx) website and the CalPERS (https://www.calpers.ca.gov/) website.

　　Contact Information

　　The Human Resources Contact is available to answer questions regarding the position or application process.

　　Department Website: https://www.energy.ca.gov

　　Human Resources Contact: Personnel Office (916) 654-4309 [email protected]

　　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: Carousel Gore (916) 661-8122 [email protected]

　　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.

　　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.