INFORMATION TECHNOLOGY SPECIALIST II

$8,374 - $11,220/Yr

State of California - Sacramento, CA

Full-time - Mid Level

Hybrid - Sacramento, CA

Executive, Legislative, and Other General Government Support

About the position

The Employment Development Department (EDD) is seeking a Senior Data Warehousing Engineer classified as an Information Technology Specialist II. This position is located in Sacramento County and is a permanent, full-time role. The working hours are from 8:00 am to 5:00 pm, Monday to Friday. The position may allow for hybrid telework, requiring access to high-speed internet. The EDD has a long history of connecting job seekers and employers in California and is looking for qualified candidates to help continue this mission.

Responsibilities

• 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 experts using Microsoft or other reporting and analysis software.
• Microsoft SQL Server database administration.
• 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.
• Supporting 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 to enable analytical solutions.
• Manipulating large data sets through statistical software or other methods.

Requirements

• Must be authorized to work in the US without the need for visa sponsorship.
• Experience leading business intelligence (BI) teams and implementing successful BI solutions for business stakeholders.
• Experience moving existing database and reporting environment solutions to a different environment or cloud.
• Knowledge of Application Programming Interface (API) development.

Benefits

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