System Analyst / Programmer @ County of Ventura, CA - Ventura, CA

Job Overview

2 months ago

System Analyst / Programmer

County of Ventura, CA - Ventura, CA


Under general direction, coordinates and monitors the progress of office automation projects from original analysis through final implementation; performs high level systems analysis and provides technical assistance to department/agency personnel by supporting and coordinating tasks related to office automation systems. This position offers an exciting opportunity to enter the complex, evolving, and challenging realm of health care information technology.

The ideal candidate will be self-motivated, coachable, whilst possessing a diverse knowledge base and proven experience in multiple areas of Information Technology. These specific areas include Structured Query Language (SQL), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Cognizant QNXT or similar healthcare enterprise applications. The successful candidate will be able to blend their technical abilities with excellent customer support skills by acting as a liaison with users and Health Care Plan IT to establish the appropriate objectives for developing new or enhancing existing personal business computer-based office systems.

DEPARTMENT/AGENCY: Health Care Agency - Ventura County Health Care Plan

PAYROLL TITLE: Office Systems Coordinator IV

EDUCATIONAL/BILINGUAL INCENTIVE: Possible educational incentive of 2.5%, 3.5%, or 5% based on completion of Associate's, Bachelor's, or Master's degree. Incumbents may also be eligible for bilingual incentive depending upon operational need and certification of skill.

Office Systems Coordinator IV is represented by the Service Employees International Union (SEIU) and is not eligible for overtime compensation.

The eligible list established from this recruitment may be used to fill current and future Regular (including Temporary and Fixed-term), Intermittent, Extra Help vacancies, for this position or similar positions only. There is currently one (1) Regular vacancy within the Ventura County Health Care Plan.

OPENING DATE: 1/27/2023
CLOSING DATE: Continuous
(Previously 2/27/23)
First application review 2/27/23

Examples Of Duties

Duties may include but are not limited to the following:

  • Coordinates specific office systems projects in progress and under consideration for individual personal computers, and/or local area networks and data communications;
  • Liaises with managers to assess departmental needs and mandated compliances within the Health Care Plan;
  • Successfully analyzes and interprets large amounts of complex data and develop reports in SSRS, SQL and PowerBI;
  • Maintains and develops SSIS ETL solutions;
  • Administers one or more health care-specific applications supporting Health Care Agency clients or members;
  • Provides technical and managerial support for the analysis, development, design, and integration of technical solutions for the Health Care plan using a variety of programming platforms and languages;
  • Upgrades and administers Windows servers, including Internet Information Services (IIS), Active Directory, SQL Server and Hyper-V;
  • Assists management in setting office systems priorities and strategies;
  • Performs tasks typically assigned to subordinate levels in the series as required by the department/agency to ensure timely completion of projects and;
  • Performs other related duties as required.

Typical Qualifications

These are entrance requirements to the exam process and assure neither continuance in the process nor placement on an eligible list.

Progressively responsible experience in automated office systems coordination which has led to the acquisition of the required knowledge, skills, and abilities. The required knowledge, skills, and abilities also can be obtained by completion of some pertinent office systems coursework with five (5) or more years of progressively related experience.

Necessary Special Requirements:

  • Three (3) years of experience minimum, using Microsoft reporting, management, and database tools (SQL Server Reporting Services - SSRS, SQL Server Integration Services -SSIS and SSMS or Azure Data Studio).
  • 3+ years of experience with relational databases and advanced T-SQL – must have the ability to write complex, high-optimized queries using large datasets.
  • Proficiency in Microsoft Windows Server.
  • Must be proficient in the use of Microsoft Excel.
  • Experience with Cognizant QNXT or similar healthcare enterprise applications.
  • Knowledge of design tools and implementation methods, including the use of Visual Studio, dot Net and experience with programming languages.
  • Familiarity with data structures and machine-readable file formats such as XML and JSON.
  • Experience managing software development projects.
  • Experience supporting and implementing software and applications.
  • Web design and front-end development experience.
  • Skills of the following: SQL; C#; .NET; HTML, CSS; Asp; Python, Rest API.
  • Strong communication, organizational, planning, problem solving, technology, analytical, judgment, and research skills.
This position may be subject to State Health Officer Orders regarding vaccine verification and/or testing. These requirements are a condition of employment. Depending on assignment and work location(s), successful candidates for this position will be required to submit proof of vaccination and/or booster against COVID-19 or request an exemption for qualifying medical or religious reasons during the onboarding process.

Comprehensive knowledge of modern office procedures, automated equipment, personal computer programming and systems design; and software and hardware products and their use in office automation. Diverse knowledge base and proven experience in multiple areas of Information Technology. Thorough knowledge of modern IT development methodologies, including but not limited to n-tier architecture, SQL server database environments, and both in-house developed and vendor-supplied systems.

Considerable skills in: Structured Query Language (SQL), C-sharp (C#), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), .NET, Hyper Text Markup Language (HTML), Application Service Provider (ASP), Python, Power BI, Rest API, Extensible Markup Language (XML), and JavaScript Object Notation (JSON).

Working ability to: coordinate all facets of personal computer-based system development and direct the efforts of others in meeting related goals. Comprehensive ability to: perform abstract reasoning; make arithmetic calculations rapidly and accurately; perform minor systems maintenance/repairs; develop independence in the responsible performance of assigned duties; develop and maintain effective working relations with others; understand and work with personal business computers in the office environment; perform complex analysis and design for integrated systems in the office environment; develop and support the concept of data communications networking of personal office computers.

Recruitment Process

FINAL FILING DATE: This is a continuous recruitment and may close at any time; therefore, apply as soon as possible if you are interested. Your application must be received by County of Ventura Human Resources in Ventura, California, no later than 5:00 p.m. on the closing date.)

To apply online, please refer to our website at If you prefer to fill out a paper application form, please call (805) 654-5129 for application materials and submit them to County of Ventura Human Resources, 800 South Victoria Avenue, L-1970, Ventura, CA 93009.

Note to Applicants: It is essential that you complete all sections of your application and supplemental questionnaire thoroughly and accurately to demonstrate your qualifications. A resume and/or other related documents may be attached to supplement the information in your application and supplemental questionnaire; however, it/they may not be submitted in lieu of the application.

LATERAL TRANSFER OPTION: If presently permanently employed in another "merit" or "civil service" public agency/entity in the same or substantively similar position as is advertised, and if appointed to that position by successful performance in a "merit" or "civil service" style examination, then appointment by "Lateral Transfer" may be possible. If interested, please click here (Download PDF reader) for additional information.

SUPPLEMENTAL QUESTIONNAIRE – qualifying: All applicants are required to complete and submit the questionnaire for this examination at the time of filing. The supplemental questionnaire may be used throughout the examination process to assist in determining each applicant's qualifications and acceptability for the position. Failure to complete and submit the questionnaire will result in the application being removed from consideration.

A Training and Experience Evaluation (T&E) is a structured evaluation of the job application materials submitted by a candidate, including the written responses to the supplemental questionnaire. The T&E is NOT a determination of whether the candidate meets the stated requirements; rather, the T&E is one method for determining who are the better qualified among those who have shown that they meet the stated requirements. In a T&E, applications are either scored or rank ordered according to criteria that most closely meet the business needs of the department. Candidates are typically scored/ranked in relation to one another; consequently, when the pool of candidates is exceptionally strong, many qualified candidates may receive a score or rank which is moderate or even low resulting in them not being advanced in the process.

ORAL EXAMINATION - 100%: A job-related oral examination may be conducted to evaluate and compare participating examinees' knowledge, skills, and abilities in relation to those factors which job analysis has determined to be essential for successful performance of the job. Examinees must earn a score of seventy percent (70%) or higher to qualify for placement on the eligible list.

NOTE: The selection process will likely consist of an Oral Exam, which may be preceded or replaced with the score from a Training and Experience Evaluation (T&E), contingent upon the size and quality of the candidate pool. In a typical T&E, your training and experience are evaluated in relation to the background, experience and factors identified for successful job performance during a job analysis. For this reason, it is recommended that your application materials clearly show your relevant background and specialized knowledge, skills, and abilities. It is also highly recommended that the supplemental questions within the application are completed with care and diligence. Responses such as "See Resume" or "Refer to Resume" are not acceptable and may disqualify an applicant from further evaluation.

If there are three (3) or fewer qualified applicants, a T&E or an Oral Examination will not be conducted. Instead, a score of seventy percent (70%) will be assigned to each application, and each applicant will be placed on the eligible list.

Applicants successfully completing the examination process may be placed on an eligible list for a period of one (1) year.

BACKGROUND INVESTIGATION: A thorough pre-employment, post offer background investigation which may include inquiry into past employment, education, criminal background information, and driving record may be required for this position.

For more information about this recruitment, please contact Brett Ramirez by email at [email protected] or by phone at 805-654-2277.

The County of Ventura 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.

Similar Jobs


CMMS System Analyst

B. Braun Medical Inc.

Irvine, CA

B. Braun Medical Inc., a leader in infusion therapy and pain management, develops, manufactures, and markets innovative medical products and services to the…


SAP Payroll Consultant

Cygnus Professionals

Universal City, CA

Note: Try to share local profiles only as client will consider local candidates first. Also make sure to submit candidates who have experience in payroll.

El Monte, CA

Design and develop the framework of Complete the specific project assigned by the team lead and the management team.


Lead System Analyst Senior - 2978

Range Generation Next LLC

Vandenberg AFB, CA

Experience with MAXIMO and/or similar supply management system. Responsible for accuracy of data between supply systems, specifically Cost Point and MAXIMO.

Industry, CA

Perform in system analysis, computer configuration, planning and training of employees on the assigned functional area’s automated systems to ensure optimal…


SharePoint developer


Fountain Valley, CA

Analyze all user requests to determine if change to system is necessary. Analyze, Design, Develop, and Implement projects/program changes to your system.


Salesforce Admin

Woongjin, Inc

Fountain Valley, CA

Test existing system enhancements and new system functionality, in collaboration with QA team and Business team. Test Salesforce configuration and setup.


Quality Business Analyst

UnitedHealth Group

El Segundo, CA

Quality Business Analyst is responsible for leading all analytics and data driven solutions by understanding and interpreting complex programs, initiatives, and…

Los Angeles, CA

You work hand in hand with each department, aiding the doctors in all day to day departmental needs. Guide members through their treatment experience, making…

Diamond Bar, CA

Develop lasting relationships with great people. SharePoint / Office 365 Analyst II. The SharePoint / Office 365 Analyst II is responsible for gathering…


Systems Integrator

California State University

Long Beach, CA

Demonstrated ability to implement customizations in 3rd party systems (such as OnBase, DocuSign, and imaging systems). Expertise in SQL and PL/SQL.


Systems Integrator

California State University, Long Beach

Long Beach, CA

Demonstrated ability to implement customizations in 3rd party systems (such as OnBase, DocuSign, and imaging systems). Expertise in SQL and PL/SQL.

Costa Mesa, CA

Lead functional system configuration for Workday HCM implementations. Oversee system configuration requirements to meet all business needs.

Los Angeles, CA

Lead functional system configuration for Workday HCM implementations. Oversee system configuration requirements to meet all business needs.

Manhattan Beach, CA

Lead functional system configuration for Workday HCM implementations. Oversee system configuration requirements to meet all business needs.

Los Angeles, CA

Accenture Flex employees work in their local metro area onsite at the project, significantly reducing and/or eliminating the demands to travel.

Industry, CA

Defines / Designs applications and unit and system testing, documentation. Job Title:* *Oracle SOA Middleware Developer (Full time with the Client)*.

Los Angeles, CA

The Application Developer establishes and maintains collaborative partnerships with constituents within IT Services and campus departments to implement new…


Salesforce Developer

Wilshire Law Firm PLC

Los Angeles, CA

Serve as primary system administrator/developer for the Salesforce environment with over 320 users and multiple department-specific platforms.


Claims, Business Analyst - Work from Home

Mercury Insurance Services, LLC

Los Angeles, CA

Manages the Business Solutions Hotline and ensures that Claims users are trained in all claims business systems. Communicates challenges directly to IT.

Santa Barbara, CA

Experience with applying systems engineering principles to small or medium sized systems, driving scalable programs for requirement analysis, verification and…


ServiceNow Developer

University of California - Irvine

Irvine, CA

Demonstrated ability to develop conversion and system implementation plans. Demonstrated ability to understand functional needs and how systems can support…

Vandenberg AFB, CA

This position may be eligible for a (hybrid) telecommuting schedule / remote. Tasks for this position must be performed largely on-site, but later assignments…

Vandenberg AFB, CA

Tasks for this position must be performed on-site. Assist Range Operations with developing and maintaining procedures to clearly describe current, approved…