Job Description

Job Description and Duties

THIS POSITION MAY BE ELIGIBLE FOR A HYBRID WORK SCHEDULE. THE AMOUNT OF TELEWORK IS AT THE DISCRETION OF THE DEPARTMENT AND IS SUBJECT TO CHANGE 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 (ITB)?

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 may be eligible for a hybrid work schedule. The amount of telework is at the discretion of the Department and is subject to change as business needs arise. Employees are required to report to their headquarters office on their assigned in-office days. Travel expenses to and from the assigned headquarters are the responsibility of the employee.

Position is located at EDD's headquarters office at 751 N St, Sacramento, California.”

• Close to the major freeways, light rail and transit stops.
• Enclosed bicycle parking.
• Close to downtown shopping and restaurants
• Close to the Golden 1 Center

You will find additional information about the job in the .

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.

Standard office environment. Cubicle, some travel may be required.

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.

Examination/Assessment 

To apply for this position, you must obtain list eligibility by taking and passing the examination. If you already have list eligibility for this classification, you do not need to retake the examination unless your list eligibility has expired.

Click the examination link below for more information and to take the exam:

For more information about the State hiring process,  click here . To watch tutorials on how to apply for a State job,  click here .

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 of 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, data mart 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 work flexible hours to address critical business needs.

Benefits

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

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 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 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 statement below, including specific examples:

Please restate the questions with your response.

1. Using the duty statement as a guide, please describe your experience which best qualifies you for this position. Be specific to your experience working in business intelligence (BI) teams and implementing successful BI solutions for business stakeholders (e.g. SAS, SSIS, Tableau, reporting and analytics, and Data Warehouse).

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.

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.

Job Tags

Permanent employment, Full time, Work at office, Remote work, Flexible hours,

Similar Jobs