Senior Data Warehousing Engineer - Sacramento, United States - State of California

Description

TELEWORK IS CURRENTLY AVAILABLE, HOWEVER, STAFF MAY BE REQUIRED TO REPORT TO THEIR ASSIGNED HEADQUARTERS AS BUSINESS NEEDS ARISE.

Are you looking for a fast-paced and challenging position that will provide you with extremely valuable data warehousing, data infrastructure, and analytics experience, extensive variety, and frequent exposure to managers and staff in the Information Technology (IT) Branch? The Employment Development Department (EDD) is looking for a highly motivated and qualified individual to work in the Business Intelligence Data Warehousing Group (BI DWG). The IT Specialist II works as a lead Data Engineer in the development and maintenance of scalable data pipelines and build out new API integrations. The incumbent will develop data strategies, data analysis, and research in the use of Data Warehousing tools, establish BI standards and practices, and define appropriate API Governance Standards, Policies and Framework.

The incumbent will represent the BI DWG in support of the EEDNext project, which consists of modernizing EDD's Unemployment and Disability Insurance and Paid Family Leave benefit systems. This large scale project will impact all Californians.

The incumbent represents the interest of EDD's program customers, Department goals, and IT Branch directives in developing new BI capabilities, which lead to cost savings, improved analytical decision making, and faster response times for external and internal information requests.

This position is headquartered in Sacramento, California and may be eligible for telework under EDD's telework policy. Employees are required to report to their headquarters office, as needed. Travel expenses to and from the assigned headquarters are the responsibility of the employee.
You will find additional information about the job in the Duty Statement .

Working Conditions

Visa Sponsorship

This position is not eligible for visa sponsorship. Applicants must be authorized to work in the US without the need for visa sponsorship by the start date of employment.
Typical office environment. Telework may be available at your home where access to high-speed internet would be required.

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

• INFORMATION TECHNOLOGY SPECIALIST II

Additional Documents

• Job Application Package Checklist
• Duty Statement

Position Details Job Code #:
JC

Position #(s):



Working Title:
Senior Data Warehousing Engineer

Classification:
INFORMATION TECHNOLOGY SPECIALIST II $8, $10,893.00 A

# of Positions:
2

Work Location:
Sacramento County

Telework:
Hybrid

Job Type:
Permanent, Full Time

Work Shift:
8:00 - 5:00pm

Work Week:
Monday-Friday

Department Information The Employment Development Department (EDD) is one of the largest State departments with employees at hundreds of service locations. For more than 70 years, the EDD has connected millions of job seekers and employers in an effort to build the economy of the Golden State. In order to continue our mission, we are constantly looking for the best and the brightest to join our ranks. Working at EDD presents many opportunities. If you strive to make a difference, we invite you to seek a career with EDD.
Department Website:

Special Requirements
It is strongly encouraged to apply through your CalCareer Account at .

Please only submit ONE application. Electronic applications submitted through your CalCareer Account are highly recommended and will be received/processed faster than other methods of filing.

If you are unable to apply electronically through your CalCareer account, please mail a completed and signed State Examination/Employment Application STD Form 678 and application package to the mailing address provided in the "Application Instructions' section below and ensure the following:

• Clearly indicate the Job Code #, Position Number and the Classification Title of this position in the "Examination or Job Title(s) For Which You Are Applying" section located on Page 3 of your State Examination/Employment STD Form 678.
• Clearly indicate the basis of your eligibility (list, transfer, reinstatement, etc.) in the "Explanations" section located on Page 3 of your State Examination/Employment Application STD Form 678.
• Remove and do not submit the "Equal Employment Opportunity" questionnaire (Page 10) with your completed State Examination/Employment Application STD Form 678. This page is for examination use only.
• Do not include your full Social Security Number on your documents and/or do not provide any LEAP information.

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: 5/4/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. Individuals who are eligible for a Training and Development assignment may also be considered for this position(s).

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 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:

Employment Development Department
Attn: Job Control #424814
Human Resource Services Division, MIC 54
PO Box
Sacramento , CA

Address for Drop-Off Application Packages

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

Employment Development Department
Attn: Job Control #424814
EDD/Human Resource Services Division (6th floor solar)
722 Capitol Mall
Sacramento , CA 95814

08:00 AM - 04:30 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 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 -
  A Statement of Qualifications (SOQ) is Required.
  Please see "Statement of Qualifications Requirements" section for more information about the SOQ.

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, knowledge and/or training in the following areas:

• Database design and modeling.
• NET software lifecycle design, development, installation, integration, evaluation, enhancement, maintenance, and testing.
• Building Application Programming Interfaces (API) and/or API gateways and RESTful Web Services.
• Developing in various Cloud Environments (public cloud, private cloud, hybrid cloud).
• Business Intelligence (BI) solutions development in collaboration with business customers and other technical domain experts using Microsoft or other reporting and analysis software.
• Microsoft SQL Server database administration.
• Microsoft SQL Server databases, capacity planning, performance tuning, backup/restore, troubleshooting, and maintaining high availability in complex environments and mission critical applications.
• Creating scripts using VB Script, Batch Language, and Microsoft PowerShell.
  • Building/deploying/maintaining and supporting SSIS packages and SSRS reports.
• Building/deploying SQL jobs, including database maintenance packages.
• Microsoft SQL Server DBA hands-on skills in supporting a production databases in all operations, such as troubleshooting daily operational issues.
• Complex data analysis and integration using Microsoft SSIS.
• Writing SQL with complex joins, stored procedures, and database functions
  • C# programming.
• Data extraction from SQL and IBM Db2 databases.
• Planning, designing and implementing data models, DataMart, and data warehouses.
• ETL tools and processes.
• Integrating and extracting relevant information from large amounts of structured and unstructured data (internal and external) to enable analytical solutions.
• Manipulating large data sets through statistical software (ex. Software as a Service (SaaS)) or other methods.

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:
Hiring Unit Contact:
Sherry Belt


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


California Relay Service: TTY), Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.

Statement of Qualifications Requirements.
A Statement of Qualifications (SOQ) is Required. The SOQ serves as documentation of each candidate's ability to present information clearly and concisely in writing. The SOQ is not a resume or cover letter. Resumes and/or Cover Letters DO NOT take the place of the SOQ. Applications received without an SOQ may not receive further consideration and may be excluded from the hiring process.

The SOQ will be considered the first phase of the hiring process for this position. If your qualifications are competitive, you may be invited to an interview. The SOQ should be typed and not more than two pages in length, not less than 12 point font, single-spaced, with margins not less than one inch, including your first and last name at the top of the page, and must include a response to the statements below, including specific examples: Please restate the questions with your response.

Describe how your work experience and education qualifies you for the role and responsibilities of this position based on the desirable qualifications and the duty statement. Be specific to your experience leading business intelligence (BI) teams and implementing successful BI solutions for business stakeholders (e.g. SAS, SSRS, Tableau, AWS, Snowflakes, and Data Warehouse).

Describe your experience moving existing database and reporting environment solution to a different environment or cloud. Please elaborate on your role, responsibilities and challenges presented.

Describe your experience/knowledge with Application Programing Interface (API) development. Résumés and/or cover letters DO NOT take the place of the SOQ. Applications received without an SOQ or SOQs that do not include a response to the statement(s) above may not receive further consideration and may be excluded from the hiring process.

Background Investigation Requirement.

The position(s) may require an applicant to pass a background investigation. However, applicants will not be asked to provide information about a conviction history unless they receive a conditional offer of employment.

The department will make an individualized assessment of whether the conviction history has a direct or adverse relationship with the specific duties of the job and the work performed by the department. The department will consider potential mitigating factors, including, but not limited to, evidence and extent of rehabilitation, recency, nature and seriousness, and age at the time of the offense(s).

The investigation will consist of completion of a personal history statement and fingerprinting checks with the Federal Bureau of Investigation, Department of Justice, and/or local law enforcement agencies. Anyone failing to pass the background investigation will be provided information on how to appeal the process. A criminal conviction may not result in an automatic determination of "Not Qualified."

ADDITIONAL DEPARTMENT INFORMATION:

The Employment Development Department may require a new probation in accordance with applicable probationary period rules.

Click on the link to complete the Employment Development Department Recruitment Survey: EDD Recruitment Survey

Merit System Principles
Information regarding Merit System Principles provided to public employees by the State Civil Service Act can be found on the CalHR website at

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.