Information Systems Programmer and Analyst I

Contra-Costa-County; California (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

Contra Costa County Department of Conservation & Development is seeking an Information Systems Programmer and Analyst I to support and maintain the department’s IT systems in Martinez. The role emphasizes SQL Server, SSRS/Crystal Reports, Oracle/Access databases, and JavaScript, with desirable experience in .NET, Power BI, API interfaces, and web development.

You will design, test, and troubleshoot both front-end and back-end applications, develop dashboards, and translate user requirements into

Qualifications

• Possession of an Associate of Arts degree from an accredited college 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.
• One year of full-time or its equivalent experience performing software applications programming or systems analysis.
• Desirable qualifications include .NET framework development experience, MSSQL database, Crystal Reports or SSRS, JavaScript, C#; familiarity with Power BI; backend infra such as servers, VMware, API connections; web/mobile app design, development, testing and troubleshooting.

Responsibilities

• Developing new applications and maintaining existing applications.
• Familiarizing yourself with department 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.

Skills

MSSQL databases

SQL queries

SSRS

Crystal Reports

Oracle databases

Access databases

JavaScript

ASP.NET/.NET framework

Power BI

Visual Studio

C#

API development

Web development

HTML

CSS

Education

Associate of Arts degree in computer science or information processing

Tools

Accela Land Management

Microsoft Visual Studio

API interfaces

Power BI tools

Job description

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.

Please note, the Information Systems Programmer and Analyst I classification is used in various departments throughout the County.

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.

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

Application Filing and Evaluation:

1. Applications will be evaluated to determine which candidates will move forward in the next phase of the recruitment process
2. 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%)
3. 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 [e-mail]. For any technical issues, please contact the GovernmentJobs’ applicant support team for assistance at [phone].

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