Address
Form of workTELEWORK 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 warehouse, data infrastructure, and analytics experience, extensive variety, and frequent exposure to managers and staff in the Information Technology 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 Information Technology Associate works as an Associate Data Warehousing Solution Developer for the Employment Development Department's (EDD) BI DWG.
The incumbent represents the interest of EDD's program customers, Department goals, and IT Branch directives in developing new Business Intelligence (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 722 Capitol Mall, Sacramento, CA, 95814 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.
Position exists at 722 Capitol Mall in the heart of downtown Sacramento.
Benefits of working at this location include:
- Close to major freeways, light rail, and transit stops
- Enclosed bicycle parking
- Close to downtown shopping and restaurants
- Close to the Golden1 Center
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.
Hybrid 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 ASSOCIATE
- Job Application Package Checklist
- Duty Statement
Position Details Job Code #:
JC-423916
Position #(s):
280-343-1401-976
Working Title:
Associate Data Warehousing Solution Developer
Classification:
INFORMATION TECHNOLOGY ASSOCIATE $4,651.00 - $6,234.00 A
$5,113.00 - $6,852.00 B
$5,589.00 - $7,491.00 C
$6,147.00 - $8,238.00 D
$5,757.00 - $7,716.00 N
$6,332.00 - $8,487.00 O
# of Positions:
1
Work Location:
Sacramento County
Telework:
Hybrid
Job Type:
Permanent, Full Time
Work Shift:
8:00 am - 5:00 pm
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: http://www.edd.ca.gov
Special Requirements
It is strongly encouraged to apply through your CalCareer Account at www.calcareers.ca.gov .
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: 4/8/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 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:
Employment Development Department
Attn: Job Control # 423916
Human Resource Services Division, MIC 54
PO Box 826880
Sacramento , CA 94280-0001
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 # 423916
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 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 -
A Statement of Qualifications (SOQ) is Required.
Please see "Statement of Qualifications Requirements" section for more information about the SOQ.
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, knowledge and/or training in the following areas:
- 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.
- Database design and modeling.
- Understanding of building APIs and/or API gateways.
- Understanding the development in various Cloud Environment (public cloud, private cloud, hybrid cloud).
- Microsoft SQL Server databases, capacity planning, performance tuning, backup / restore, troubleshooting, and maintaining high availability in complex environments and mission critical applications.
- Create scripts using VB Script, Batch Language and Microsoft PowerShell.
- Microsoft SQL Server, Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS).
- Building/deploying / maintaining and supporting SSIS packages and SSRS reports.
- Building/deploying SQL Jobs, including database maintenance packages.
- C# programming.
- Data extraction from SQL and IBM Db2 databases.
- BI software support and user training .
- Planning, design and implementation of data models, DataMart and data warehouses.
- ETL tools and processes.
- Experience in integrating and extracting relevant information from large amounts of both structured and unstructured data (internal and external) to enable analytical solutions.
- Experience manipulating large data sets through statistical software (ex. SAS) or other methods.
- Ability to produce technical documentation that helps people understand and use a product or service.
- Experience researching and discovering new methods to acquire data, and new applications for existing data.
- Ability to produce technical documentation that helps people understand and use a product or service.
- Experience researching and discovering new methods to acquire data, and new applications for existing data.
- Ability to work flexible hours to address critical business needs.
Benefits Benefit information can be found on the CalHR website, www.calhr.ca.gov , and the CalPERS website, www.calpers.ca.gov .
Contact Information
The Hiring Unit Contact is available to answer questions regarding the position or application process.
Department Website: http://www.edd.ca.gov
Hiring Unit Contact:
Sherry Belt
(916) 654-7532
Sherry.Belt@edd.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:
EEO Officer
(916) 654-8434
EEOMail@edd.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.
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.
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 one page 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 statement below, including specific examples:
Please restate the question with your response.
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 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...
