System Analyst / Programmer

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.

Desired

• 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. 

OTHER REQUIREMENTS
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.

KNOWLEDGE, SKILLS, and ABILITIES:
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.FINAL FILING DATE:  Applications must be received by County of Ventura Human Resources no later than 5:00 p.m. on February 13th, 2023.
 
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 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 brett.ramirez@ventura.org 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.

Salary : $85,152 - $113,089