Information Technology Specialist Ii

4 weeks ago


Sacramento County CA, United States Department of Transportation Full time

The Department of Transportation (Caltrans) Information Technology (IT) Program - one of the largest IT programs within the State of California - is seeking a motivated and positive Information Technology Specialist II functioning as a Senior Oracle Data Warehouse Specialist with excellent verbal and written communication skills and demonstrated ability to work collaboratively with other IT professionals, vendors, and customers. If you want to be a part of a new office committed to successfully establishing and maintaining an Enterprise Data Warehouse (EDW) and Department-wide Business Intelligence (DBI) program, then this is the position for you.
- MAJOR FUNCTIONS:

- The incumbent provides technical leadership and expertise for the administrative and technical design and support for the EDW/DBI program. The incumbent's primary focus is on the standards, processes, procedures for the analysis, design, implementation, maintenance, and operations of data warehousing. This includes understanding data modeling, assisting with data ETL from OLTP sources to the EDW, database administration, security best practices, and Oracle Autonomous Data Warehouse database administrator duties. The incumbent's secondary focus is business intelligence, data analysis and reporting. The incumbent performs highly complex activities of the System Development Life Cycle, which includes systems: analysis, design, build, test, maintenance, and operations. The incumbent provides training to staff in the configuration and use of data warehouse and business intelligence technologies. The incumbent also performs functions including, but are not limited to, researching, writing, reporting, presenting, etc.
- DOMAINS:

- System Engineering
Software Engineering
- You will find additional information about the job in the **Duty Statement**.

Working Conditions

**Position located in Sacramento**.
- The incumbent performs work indoors in a climate-controlled environment under artificial lighting or telework. The incumbent may be required to work for extended periods of time in a computer room that maintains an approximate temperature of 70 degrees. The incumbent may work after regular business hours and/or weekends to perform activities to support business operations and/ or systems maintenance.
- The incumbent must carry a cell phone and respond to calls after hours to lead multi-disciplinary IT professionals team(s) in organizing, analyzing, troubleshooting and resolving IT system problems; may travel to various Caltrans locations to provide expertise for IT operations. Possession of a valid driver’s license is required when operating a state owned or leased vehicle. If the incumbent uses their personal vehicle they will be reimbursed for travel expenses. When available, a State vehicle will be provided.
- 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-426149
- **Position #(s)**:

- 900-170-1414-XXX
- **Working Title**:
**Senior Data Warehouse Specialist**

**Classification**:

- INFORMATION TECHNOLOGY SPECIALIST II
$8,130.00 - $10,893.00 A
- **# of Positions**:

- Multiple
- **Work Location**:

- Sacramento County
- **Telework**:

- Hybrid
- **Job Type**:

- Permanent, Full Time
- **Facility**:

- California Department of Transportation
- Department Information

**Caltrans Mission**: Provide a safe and reliable transportation network that serves all people and respects the environment.

**Caltrans Vision**: A brighter future for all through a world-class transportation network.

**The Caltrans workforce is made up of diverse and unique individuals who contribute to our organizational success. Caltrans is about celebrating diversity, valuing one another, and recognizing that Caltrans is strong not in spite of the diverse attributes of our workforce, but because of our diversity.**
- Special Requirements

**Statement of Qualifications (SOQ)**:

- The Statement of Qualifications is a narrative discussion of how your education, training, experience, and skills meet the minimum and desirable qualifications and qualify you for the position. The Statement of Qualifications serves as a documentation of your ability to present information clearly and concisely in writing and must be typed in a minimum of 12-point font, single spaced, on letter sized paper (8.5” x 11”), and no more than two pages in length. Applications submitted without the Statement of Qualifications will not be considered. You must write, “Statement of Qualifications” at the top of your document. If your qualifications are competitive, you may be invited to an interview. When completing the SOQ, explain your answers thoroughly, but succinctly.
Describe your education and experience that qualify you for this IT Specialist II position. Please include the classification and dur



  • Sacramento County, CA, United States Department of Technology Full time

    **Telework Information: Telework is available.** Under the general direction of the Information Technology Manager I (IT Mgr I), the Information Technology Specialist II (IT Spec II) demonstrates a depth of leadership and expertise in one or more domains. The IT Spec II has significant responsibilities for technical support for the Office of Digital...


  • Sacramento County, CA, United States Department of Technology Full time

    **Telework is available.** - **June 3, 2024** **June 17, 2024** **July 1, 2024** You will find additional information about the job in the **Duty Statement**. Working Conditions - Must pass a fingerprint background criminal record check completed by the Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). - The IT Spec II must be...


  • Sacramento County, CA, United States Department of Health Care Services Full time

    **About this Role**: The ITS II/ISE-II will lead teams, uphold organizational values, and manage projects, advising on solutions that significantly impact business success. They are responsible for planning and implementing critical technological solutions, demonstrating effective leadership, and mentoring staff and customers in complex technical...


  • Sacramento County, CA, United States Public Employees Retirement System Full time

    **Anticipated Interview Dates**:Virtual interviews are anticipated to start the week of July 8, 2024. CalPERS seeks a dynamic and experienced technical project manager who enjoys working with business programs and information technology (IT) partners to execute technical and complex projects. With a hybrid work schedule, you get the benefits of an office...


  • Sacramento County, CA, United States Employment Development Department Full time

    **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.** Under direction of the Information Technology Manager I, the incumbent functions as an Information Technology Specialist II in the Data and Information Architecture Section. The...


  • Sacramento County, CA, United States California Department of Aging Full time

    **The Position is headquartered in Sacramento.** Under the general direction of the Information Technology Manager I, Application Development and Database Administration Branch, the incumbent is responsible for a wide variety of data, analytical processing, and administration activities necessary to analyze, design, code, document and maintain the integrity...


  • Sacramento County, CA, United States Department of Health Care Services Full time

    **About this Role**: This recruitment has been posted for more vacancies than currently exist as it may be used to fill additional identical vacancies which occur within 180 days of the closing date of this bulletin. - This recruitment may be filled via a Training and Development assignment. - You will find additional information about the job in the **Duty...


  • Sacramento County, CA, United States California Victim Compensation Board Full time

    Are you an experienced Information Technology professional as a Technical Security Engineer? Are you looking to be part of a dynamic Information Security team? Then CalVCB has an excellent opportunity for you. - The Information Technology Specialist II (ITS II) is responsible for supporting the protection of mission critical systems and data by developing...


  • Sacramento County, CA, United States Employment Development Department Full time

    **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 a wide range of Information Technology experience, an extensive variety of projects, and frequent exposure to managers and staff in the...


  • Sacramento County, CA, United States CA Department of Tax and Fee Administration Full time

    Are you interested in making life better for Californians? Are you looking for a career and not just a job? Do you want to create a meaningful impact in your community? If you answered yes to any of these questions, then the California Department of Tax and Fee Administration (CDTFA) has a career opportunity waiting for you! California not only needs you, it...


  • Sacramento County, CA, United States Department of Transportation Full time

    Under the general direction of the Information Technology Manager I, the incumbent will function as a lead IT project manager and quality assurance analyst for the Fi$Cal onboarding project in the Project and Portfolio Management Section (PPMs). The Department of Transportation (Department) Information Technology (IT) Enterprise Portfolio Management Services...


  • Sacramento County, CA, United States Public Employees Retirement System Full time

    **Anticipated Interview Dates**:In-person interviews are anticipated to be held the week of 5/27/2024. **Telework Information**: This position is eligible for hybrid work schedule, with up to two days of remote work and three days or more onsite, per week. Join our team if you're ready to leverage your expertise in SaaS platforms, particularly in call...


  • Sacramento County, CA, United States Department of Social Services Full time

    **Benefits**: The state offers comprehensive benefits including health, dental, vision, long-term care and disability insurance, as well as paid leave. Please see the Benefits section below for more details. Click here to view all the attractive benefits available to state employees! You will find additional information about the job in the **Duty...


  • Sacramento County, CA, United States Franchise Tax Board Full time

    - **About the Technology Services Division (TSD) **The mission of TSD is to securely deliver and support information technology solutions and services essential to the success of the FTB’s mission. By acting on our TSD mission, we will realize our vision of a collaborative and diverse team of IT experts who further innovation and empower our business...


  • Sacramento County, CA, United States Department of Human Resources Full time

    **This position provides hybrid telework opportunities, with employees required to work in-person at least two days per week.** You will find additional information about the job in the **Duty Statement**. Minimum Requirements You will find the Minimum Requirements in the Class Specification. - INFORMATION TECHNOLOGY SPECIALIST II Additional Documents -...


  • Sacramento County, CA, United States Employment Development Department Full time

    **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.** The Employment Development Department (EDD) Information Technology Cybersecurity Division has immediate openings for lead Senior Cybersecurity and Fraud Engineers. This role involves...


  • Sacramento County, CA, United States Department of Developmental Services - Headquarters Full time

    **_ You will find additional information about the job in the **Duty Statement**. Working Conditions - Prolonged periods on a personal computer up to 90% of the time. - Occasional trvel up to 5% for overnight or day trips. Minimum Requirements You will find the Minimum Requirements in the Class Specification. - INFORMATION TECHNOLOGY SPECIALIST...


  • Sacramento County, CA, United States Department of Social Services Full time

    The incumbent will lead and participate in the process to identify and document services and opportunities with enterprise impacts that support ISD and the CDSS. They will also help to mature and promote continual Organizational Process Improvement Methodologies across the enterprise and establish best practices to support and enable consistent and efficient...


  • Sacramento County, CA, United States Public Employees Retirement System Full time

    **Anticipated Interview Dates**:Virtual interviews are anticipated to begin the week of June 10th, 2024. **Telework Information**:This position is eligible for a hybrid work schedule, with up to two days of remote work and three days or more onsite, per week. The California Public Employees' Retirement System (CalPERS) User Experience (UX) and Information...


  • Sacramento County, CA, United States Department of Technology Full time

    **Telework is available.** - Under the direction of the Information Technology (IT) Manager I, the IT Specialist I has responsibility for development of innovative procurement approaches and coordinates and controls all aspects of difficult and sensitive acquisitions related to reportable IT and Telecommunications (Telecom) projects in accordance with Public...