Systems Software Analyst II

Salary :

$115,781.28 - $155,158.08 Annually

Location :

Contra Costa County, CA

Job Type:

Permanent Full-Time

Job Number:

LWVA-2024A

Department:

County-Wide

Opening Date:

06/10/2024

Closing Date:

6/21/2024 11:59 PM Pacific

FLSA:

Exempt

Bargaining Unit:

ZB

The Position

Why join the Contra Costa Health?
Contra Costa County was incorporated in 1850 as one of the original 27 counties of the State of California. It is one of nine counties in the San Francisco-Oakland Bay Area and covers approximately 733 square miles extending from the northeastern shore of San Francisco Bay easterly about 50 miles to San Joaquin County. The County has one of the State's most heterogeneous populations, rich in ethnic, cultural, and socioeconomic diversity. With a current population of more than 1.1 million, Contra Costa County is the ninth most populous county in California.

Selected candidates should expect to work out of CCHS facilities in Martinez or Concord. Contra Costa Health Services includes a Health Plan, Public Health, Hazardous Materials, Environmental Health, Housing Homeless and Health, Regional Medical Center, Behavioral Health, Emergency Management Services, and a full complement of ambulatory care sites including school-based services.

Contra Costa County Health is offering one excellent employment opportunity for a full-time Systems Software Analyst II assigned primarily to the Health Services Information Technology Unit located in Martinez, CA.

We are looking for someone who is:
Articulate . You will need to communicate clearly and professionally, both verbally and in writing, with staff, providers, and the vendor community.
A team player . You should be able to work well in a team.
Shows initiative and follow-through.
Organized . You should be able to effectively analyze and prioritize situations as they arise during the day, responding to urgent requests in a timely manner in an atmosphere with competing demands.
Inclusive . You should acknowledge and respect the cultural and linguistic differences of diverse populations.
Customer-focused . Demonstrates empathy in handling customer needs and builds a trusting rapport with customers.
A problem solver . You will need to assess issues and excel at troubleshooting.
What you will typically be responsible for:
Epic Clarity Administration
Epic Caboodle Administration
SSIS programming
SSRS administration
Qlik Administration
A few reasons you might love this job:
Your work will impact the lives, health, and wellbeing of all residents (with a focus on the diverse, marginalized communities) and businesses in Contra Costa County.
Professional development funds are available for each employee.
Offices are in the central part of the County.
The team you would work with is full of people passionate about their jobs, constantly innovating, and joyful collaborators.
The County offers a generous benefits package.
A few challenges you might face in this job :
Staff must adapt to new and ever-changing technology.
You may have to work under pressure and need to deliver resolutions in tight timeframes.
Multiple divisions in projects may not have the same priorities.
Competencies Required:
Analyzing & Interpreting Data:

Drawing meaning and conclusions from quantitative or qualitative data
Critical Thinking:

Analytically and logically evaluating information, propositions, and claims
Decision Making:

Choosing optimal courses of action in a timely manner
Delivering Results:

Meeting organizational goals and customer expectations and making decisions that produce high-quality results by applying technical knowledge, analyzing problems, and calculating risks
Innovative Problem Solving:

Identifying and analyzing problems in order to propose new ways to do business
Professional & Technical Expertise:

Applying technical subject matter to the job
Action & Results Focused (Taking Initiative):

Initiating tasks and focusing on accomplishment
Building & Maintaining Relationships:

Establishing rapport and maintaining mutually productive relationships
Customer Focus:

Attending to the needs and expectations of customers
Coaching & Developing Others:

Supporting others in stretching and expanding their capabilities
Teamwork:

Collaborating with others to achieve shared goals
Business Process Analysis:

Defining, assessing, and improving operational processes and workflow
To read the complete job description, please visit the website,

The eligible list established from this recruitment may be used to fill future openings for up to six (6) months.
Minimum Qualifications

Education:

Possession of a bachelor's degree from an accredited college or university which included completion of 30 semester hours in computer science, information processing, or a closely related field.

Experience:

One (1) year full-time or its equivalent experience as a Systems Software Analyst I in Contra Costa County

or

two (2) years full-time or its equivalent experience in the design, implementation, and maintenance of operating systems software on multi-user systems

plus

two (2) years full-time or its equivalent programming experience on multi-user systems. At least one (1) year of the systems software experience must have included the installation and maintenance of both operating systems and database software.

Substitution for education:

Additional applications programming experience in a higher level applications language or systems software experience of the type noted above may be substituted for the required education on a year-for-year basis up to a maximum of two (2) years. No substitution is allowed for the required 30 semester hours in computer science, information processing, or a closely related field.

Desirable Qualifications:
Epic Clarity Administration Certification
Expert level knowledge of ETL programming and tools like SSIS
Advanced perl, C#, etc. programming knowledge to support automation scripting
Advanced Qlik knowledge to support both on prem and cloud administration

Selection Process

Application Filing and Evaluation:

Applications will be evaluated to determine which candidates will move forward in the next phase of the recruitment process.
Training and Experience Evaluation:

Candidates who possess the minimum qualifications will be assessed with a Training and Experience Evaluation. Questions are included on the application as a part of the Supplemental Questionnaire. (Weight 100%)
Departmental Hiring Interview: July 2024

Meeting the minimum qualifications does not guarantee an invitation to participate in the selection process.

The Human Resources Department may change the examination steps noted above in accordance with the Personnel Management Regulations and accepted selection practices.

For recruitment-specific questions, please contact Sanyukta Singh at [email protected]. For any technical issues, please contact the GovernmentJobs' applicant support team for assistance at +1 855-524-5627.

CONVICTION HISTORY

After you receive a conditional job offer, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction conflicts with the specific duties and responsibilities of the job for which you have received a conditional job offer. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances. Having a conviction history does not automatically preclude you from a job with Contra Costa County. If you accept a conditional job offer, the Human Resources Department will contact you to schedule a fingerprinting appointment.

DISASTER SERVICE WORKER

All Contra Costa County employees are designated Disaster Service Workers through state and local law. Employment with the County requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.

EQUAL EMPLOYMENT OPPORTUNITY

It is the policy of Contra Costa County to consider all applicants for employment without regard to race, color, religion, sex, national origin, ethnicity, age, disability, sexual orientation, gender, gender identity, gender expression, marital status, ancestry, medical condition, genetic information, military or veteran status, or other protected category under the law.

To find more information on Benefits offered by Contra Costa County, please go to

01

The purpose of the questionnaire is to provide applicants the opportunity to elaborate on their experience, education, and training for the position and to assist Human Resources staff in assessing each applicant's qualifications. Your responses to the questionnaire will be used to better understand relevant experience, education, and training to determine which applicants will be invited to participate in the next step of the recruitment process.

Do not answer any of the questions by indicating "see attached application" or "see resume."

I understand

02

Do you possess a valid driver's license?

Yes
No

03

Which of the following best describes your highest level of education?

I do not have a High School Diploma or GED
High School Diploma or GED
Some College
Associate's Degree
Bachelor's Degree
Master's Degree or higher

04

Please select your degree's major field of study.

Computer Science
Information Processing
Other
I do not have a degree

05

If you selected "Other", please type in your degree major field of study. (Type "N/A" if this does not apply to you).

06

Do you have at least

30 semester hours

in computer science, information processing, or a closely related field

Yes
No

07

How many years of experience do you have in the design, implementation, and maintenance of operating systems software on multi-user systems?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

08

How many years of experience do you have in installation and maintenance of both operating systems and database software?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

09

How many years of programming experience do you have on multi-user systems?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

10

How many years of experience do you have analyzing data to identify trends, patterns, and insights to inform decision-making?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

11

How many years of experience do you have evaluating the accuracy and reliability of data for data integrity?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

12

How many years of experience do you have using Epic Clarity?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

13

How many years of experience do you have using Epic Caboodle?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

14

How many years of experience do you have designing and implementing packages to extract, transform, and load data from various sources?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

15

How many years of experience do you have developing interactive dashboards for stakeholders?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

16

How many years of experience do you have using SSIS programming?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

17

How many years of experience do you have with SSRS Administration?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

18

How many years of experience do you have with Qlik Administration?

I do not have any experience as described.
Less than one (1) year of experience as described.
One (1) year or more, but less than two (2) years, of experience as described.
Two (2) years or more, but less than three (3) years, of experience as described.
Three (3) years or more, but less than four (4) years, of experience as described.
Four (4) years or more, but less than five (5) years, of experience as described.
Five (5) years or more of experience as described.

19

What Department(s) would you like to work for?**If you do not select "All Departments" then you will ONLY be referred to the Department(s) you select you would be willing to work for**Please note: this eligible list may be used to fill vacancies in any of the following departments throughout the period that the list remains active; however, this does not guarantee that there is or will be a vacancy in any specific department.

All Departments
Health Services
Sheriff (A Thorough Background Investigation, Including Polygraph Will Be Conducted)

20

By checking this box, I am confirming that all statements made in this supplemental questionnaire and on the application are accurate and true; and I understand that misstatements or omissions of material facts will result in being rejected from this recruitment process, or released from future employment with Contra Costa County.

I agree

Required Question