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

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.

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

EDUCATION, TRAINING, and EXPERIENCE:
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.

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 https://hr.ventura.org. 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.

TRAINING & EXPERIENCE EVALUATION:
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.

EQUAL EMPLOYMENT OPPORTUNITY
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.