Job Posting: Data Engineer

Department of Technology

JC-210849
-
Data Engineer
INFORMATION TECHNOLOGY SPECIALIST I

$5,562.00 - $8,999.00 per Month

Final Filing Date: 8/29/2020

Job Description and Duties

The California Department of Technology (CDT) is focused on improving how state government develops and implements innovative solutions to meet the public’s evolving needs, enrich customer experiences, and improve critical technological applications. CDT’s Office of Enterprise Technology (OET) plays a critical role to enhance digital government and build a California that works for all Californians. We do this by providing foundational platforms and technology (such as GIS/Open Data, Web Portals, Software Engineering and Open Source code curation) for organizations to provide innovative digital services.

Under the direction of the Information Technology Manager II (ITM II) over Data and Geospatial Services, the Information Technology Specialist I (IT Spec I) serves as Data Engineer performing a variety of data engineering and data maintenance tasks and activities. The IT Spec I will be responsible for data engineering support for both internal and external customers. The IT Spec I works with cross-functional teams and business programs to analyze their business problems and assist with all parts of Data Warehouse reporting systems including Extract, Transform and Load(ETL) tools and processes, Data modeling, Reporting for end users, and data pipelines. Additionally, the IT Spec I will plan, organize and facilitate various communities of practice which enable the state’s greater technology community and business programs to share knowledge and best practices, ask questions of their colleagues, and directly engage on high priority topics,

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

Working Conditions

  • During state emergencies or activation by the California Office of Emergency Services, incumbents may be asked to work extended hours, 12-hour shifts, and/or off-site and occasionally out-of-town.

  • May be required to carry and use a cell phone or mobile device.

  • May occasionally be required to work some weekends.

  • May occasionally be required to work outside of normal business hours.

  • May occasionally be required to travel between Rancho Cordova and Sacramento.

 

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Additional Documents

Position Details

Job Code #:
JC-210849
Position #(s):
695-540-1402-022
Working Title:
Data Engineer
Classification:
INFORMATION TECHNOLOGY SPECIALIST I
$5,562.00 - $7,454.00 A
$6,116.00 - $8,197.00 B
$6,715.00 - $8,999.00 C
# of Positions:
1
Work Location:
Sacramento County
Job Type:
Permanent, Full Time
Work Shift:
8;00 AM-5:00 PM
Work Week:
Monday - Friday

Department Information

California Department of Technology
P.O. Box 1810
Rancho Cordova, CA 95741-1810
Inquiries: Marianne Ternes, (916) 431-6253
Department Website: http://cdt.ca.gov

Special Requirements

Do not submit the "'Equal Employment Opportunity" questionnaire (page 5) with your completed state application (STD. 678).  This page is for exam use only.

Please do NOT include your Social Security Number on any of the submitted documents.

Statement of Qualificafions

The SOQ serves as a documentation of each candidate's ability to present information clearly and concisely in writing.  Resumes, cover letters and other materials will not take the place of the SOQ.

Instructions

The SOQ must be typed and not more than two pages in length and 10 point font and must be submitted along with your State Application (STD 678). Should include “Statement of Qualifications”, name and RPA number in header.

  1. Based on duties stated in the duty statement, describe your relevant work experience, education, and achievements. Include examples of your work experience related to the duties for this position with a focus on Data Engineering.

     

  2. Describe an experience when you have been provided a dataset and been asked to create a complex Extract Transform Load / Extract Load Transform process.  Please be specific about the methods and tools used to accomplish this task.

  3. Describe your experience directly working with external partners and customers on Data Engineering projects.

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: 8/29/2020

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:

Department of Technology
Attn: Angie, RPA 20-022/JC 210849
Selection Services Unit
P.O. Box 1810
Rancho Cordova, CA 95741

Address for Drop-Off Application Packages

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

Human Resources
10860 Gold Center Drive
Rancho Cordova, CA 95670
Drop Off 2nd Floor Security, Attn: Angie, RPA 20-022/JC 210849
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 - Required.  Please see "Special Requirements" section for further information.
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:

  • Bachelor's Degree in Computer Science, Information Technology, Statistics, Mathematics, Engineering or a quantitative discipline is desired.

  • Knowledge/experience with data engineering principles.

  • Experience or education in one or more of the following technologies: SQL / SQL, RDBMS, SQL Server, Oracle, PostgreSQL, ETL / ELT, Data Lakes, Data Warehouses and Enterprise Metadata Management Systems.

  • Experience with Azure Data Factor, Amazon Glue / Lamda, FME, 5TRAN, Matillion

  • Knowledge and experience with Data Warehouse concept and architectures, Online Analytical Processing (OLAP) technologies, Star-schema, Snowflake schema and Aggregation etc.

  • Experience building end-to-end data solutions using Data models, Data pipelines and BI products.

  • Experience or education of programming in one or more of the following languages: C#, Java, SQL, R, Python.

  • Experience producing requirements documents, systems architecture and interfaces, data model diagrams, configuration management documents etc.

  • Ability to conceive and portray the big picture; creatively think outside the box with the ability to power through challenges in pursuit of a solution.

  • Excellent communication and customer service skills, including the ability to present ideas and information effectively, both orally and in writing.

  • Knowledge of project management best practices.

  • Ability to critical think and approach problems with creatively while using a variety of analytical techniques to resolve said problems.

Benefits

Benefit information can be found on the CalHR website and the CalPERS website.

Contact Information

The Hiring Unit Contact is available to answer questions regarding the position or application process.

Department Website: http://cdt.ca.gov
Hiring Unit Contact:
Marianne Ternes
(916) 431-6253
marianne.ternes@state.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:
Thomas Willis
(916) 431-5358
Thomas.Willis@state.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.

The Fine Print

  • When applying for a Job Opening, you must be sure to submit one state application per RPA #. You must indicate the RPA # you are applying for on your application, as well as your eligibility in the Explanations box; otherwise, your application may not be processed.

     

  • If you have questions about the State Hiring Process visit our Career Opportunities webpage at https://cdt.ca.gov/career-opportunities/state-hiring-process.

     

  • Training and Development Assignment may be considered.  This recruitment may be used to fill multiple vacancies occurring in this unit for this classification within the next 60 days.

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.