Information Systems Programmer and Analyst I

The Position

Bargaining Unit: Local 21 - Non-Supervisory Management

Why join the Contra Costa Department of Conservation & Development?

The Department of Conservation and Development (DCD) facilitates land use and development consistent with the County General Plan, administers and enforces Building and Zoning Codes, and coordinates a wide range of County programs. In addition to these core responsibilities, DCD staff oversee numerous initiatives that strengthen communities, support vulnerable residents, and reflect the department’s commitment to delivering excellent public services.

DCD is led by a Director and includes six divisions managed by a Senior Deputy Director, Deputy Director, or Assistant Deputy Director. These divisions include Current and Advance Planning; Building Inspection Services; Business and Information Services; Housing and Community Improvement; Habitat Conservancy and GIS/Mapping; and the Water Agency and Transportation. Located in Martinez, the department has approximately 175 staff members serving Contra Costa County.

DCD is currently seeking to fill one vacancy for an Information Systems Programmer and Analyst I. This role will work closely with other IT staff to support and maintain the department’s existing systems. It offers an exciting opportunity to apply technical expertise while contributing to the technology infrastructure that enables essential services across the County.

Ideal candidates will bring strong knowledge of Microsoft SQL Server databases and advanced querying, SSRS and Crystal Reports development, Oracle and Access databases, and JavaScript. Experience with Accela Land Management, API interfaces, the .NET framework, website development, Power BI tools, Visual C, and C# are highly desirable.

If you are a collaborative technology professional with strong analytical and problem-solving skills, and you enjoy supporting and enhancing enterprise systems, we encourage you to apply and become a valued member of the DCD team.

Please note, the Information Systems Programmer and Analyst I classification is used in various departments throughout the County. All qualified applicants are encouraged to apply.

We Are Looking For Someone Who Is

• Driven. You have a proven track record of successful work delivery in day-to-day operations and larger project initiatives
• Experienced. You are experienced in designing, coding, testing, and troubleshooting front-end and back-end applications. You have expertise in requirements gathering, scripting, forms and workflow development, report development, documenting and evaluating the effectiveness of system change
• Knowledgeable. You are experienced with MSSQL databases, .NET framework, Microsoft Visual Studio, SSRS/Crystal Reports, API development and modern web technologies
• Team oriented. You communicate clearly and effectively, work collaboratively with others, maintain a positive and adaptable attitude, and foster positive working relationships in a team oriented environment
• Able to take the initiative. You are independent and have the drive to learn and research on your own

What You Will Typically Be Responsible For

• Developing new applications and maintaining existing applications
• Familiarizing yourself with the department’s databases and other information systems
• Learning and staying abreast of relevant laws, policies, ordinance, rules, and regulations that affect information system changes, workflows, business processes and report requirements
• Working with staff to interpret user/department requirements for system enhancements or reports
• Testing, troubleshooting and implementing system upgrades and systems enhancements
• Providing information and guidance on applicable information systems policies, procedures, methods, and techniques
• Writing SQL queries to extract data and writing stored procedures for batch processing
• Creating ad-hoc queries and reports, and analyzing data using Excel, Power BI, SSRS and other tools.
• Building and maintaining dashboards and reports using Power BI
• Developing front end interfaces and adding BI content into internal sites using HTML, CSS, JavaScript
• Monitoring and tracking projects and reporting on progress or problems encountered.
• Writing and updating documentation of business processes and system configurations
• Providing first-level support for vendor solutions
• Completing Assigned tasks in a timely manner

A Few Reasons You Might Love This Job

• You will have a wide breadth of impact, not just with Contra Costa County, but with services shared across multiple counties
• The work environment is friendly, supportive, and efficient
• Generous benefits packages are offered by the County
• You will have the opportunity to learn about various technological products and services

A Few Challenges You Might Face In This Job

• You will work with internal and external customers who have varying levels of knowledge and experience. Some individuals may require additional support and guidance to achieve successful outcomes
• You will need to navigate complex, outdated, or conflicting business rules and policies while supporting staff in meeting operational goals
• The demands and needs of the department can change rapidly, requiring you to adapt and reprioritize your workload
• Conducting after-hours system implementations and maintenance work

Competencies Required

• Analyzing & Interpreting Data: Drawing meaning and conclusions from quantitative or qualitative data
• 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
• Reading Comprehension: Understanding and using written information
• Professional & Technical Expertise: Applying technical subject matter to the job
• Displaying Ownership and Accountability: Holding self and others accountable for measurable high-quality, timely, and cost-effective results
• Oral Communication: Engaging effectively in dialogue
• Writing: Communicating effectively in writing
• Building & Maintaining Relationships: Establishing rapport and maintaining mutually productive relationships
• Customer Focus: Attending to the needs and expectations of customers
• Involving Others (Engaging Teams): Engaging others for input, contribution, and shared responsibility for outcomes
• Teamwork: Collaborating with others to achieve shared goals

To read the complete job description, please visit the website, www.cccounty.us/hr

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 an Associate of Arts degree from an accredited college with a major in computer science or information processing; OR completion of 24 college semester units, or 36 quarter units in computer science or information systems or closely related field.

Experience: One (1) year of full-time or its equivalent experience performing software applications programming or systems analysis.

Substitution for Education: Additional-qualifying experience may be substituted for the required education on a year-for-year basis, up to a maximum of two years.

Desirable Qualifications

• Minimum of one (1) year of experience as a .NET framework developer on the Windows platform who is familiar with using Microsoft Visual Studio, MSSQL database, Crystal Reports or SSRS
• JavaScript, C# coding languages used
• Experience with Power BI or other Business Intelligence tools
• Familiar with backend infrastructure such as servers, VMware, API, and service connections
• Web and mobile application design, development, testing, and troubleshooting experience

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: Consists of an evaluation of each candidate's relevant education, training and/or experience as presented on the application and supplemental questionnaire. (Weighted 100%)
• Departmental Hiring Interview: To be scheduled once the eligible list is established.

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 Christine Bissada 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.

Contra Costa County is committed to providing equal access and opportunity to qualified individuals with disabilities in its employment practices. If you believe you may anticipate needing reasonable accommodation, please visit our job seeker resources page at: Special Testing Accommodations | Contra Costa County, CA Official Website.

To find more information on Benefits offered by Contra Costa County, please go to https://www.contracosta.ca.gov/1343/Employee-Benefits

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 an Associate of Arts degree (or higher) from an accredited college with a major in Computer Science or Information Processing or closely related field?

• Yes
• No

03

If your major is in a "closely related field," please type in your degree's major field of study. (Type "N/A" if this does not apply to you).

04

Have you completed 24 college semester units, or 36 quarter units in Computer Science or Information Systems or closely related field?

• Yes
• No

05

How many years of experience do you have performing software applications programming or systems analysis?

• None
• Less than one (1) year of full-time experience
• One (1) year or more, but less than two (2) years of full-time experience
• Two (2) years or more, but less than three (3) years of full-time experience
• Three (3) years or more, but less than four (4) years of full-time experience
• Four (4) years or more of full-time experience

06

If you indicated you have one (1) year or more of full-time, or its equivalent, experience in performing software applications programming or systems analysis, please list the company names and employment dates below. (Note: See Resume will not be considered)

07

How many years of experience do you possess writing queries, extracting, and analyzing data from Oracle or MSSQL databases?

• None
• Less than one (1) year of full-time experience
• One (1) year or more, but less than two (2) years of full-time experience
• Two (2) years or more, but less than three (3) years of full-time experience
• Three (3) years or more, but less than four (4) years of full-time experience
• Four (4) years or more of full-time experience

08

How many years of experience do you possess using Microsoft Visual Studio, SSRS and/or Crystal Reports?

• None
• Less than one (1) year of full-time experience
• One (1) year or more, but less than two (2) years of full-time experience
• Two (2) years or more, but less than three (3) years of full-time experience
• Three (3) years or more, but less than four (4) years of full-time experience
• Four (4) years or more of full-time experience

09

How many years of experience do you possess developing C# or JavaScript programming language?

• None
• Less than one (1) year of full-time experience
• One (1) year or more, but less than two (2) years of full-time experience
• Two (2) years or more, but less than three (3) years of full-time experience
• Three (3) years or more, but less than four (4) years of full-time experience
• Four (4) years or more of full-time experience

10

Please indicate your experience with backend infrastructure. Select all applicable options. If none of the listed options reflect your experience, select ‘None.’

• None
• Server Operating Systems
• VMware
• MSSQL Database Administration

11

How many years of experience do you possess with web and/or mobile app development and testing?

• None
• Less than one (1) year of full-time experience
• One (1) year or more, but less than two (2) years of full-time experience
• Two (2) years or more, but less than three (3) years of full-time experience
• Three (3) years or more, but less than four (4) years of full-time experience
• Four (4) years or more of full-time experience

12

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
• Department of Conservation and Development
• Health Services
• Sheriff (A Thorough Background Investigation, Including Polygraph Will Be Conducted)

13

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