Information Systems Programmer and Analyst I
Contra Costa County
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
Contra Costa County’s Department of Conservation & Development seeks an Information Systems Programmer and Analyst I to support and maintain enterprise systems. You will work with IT staff across MS SQL Server, SSRS/Crystal Reports, Oracle/Access, and web technologies to deliver reliable data solutions.
The role emphasizes developing new applications, reporting, and BI dashboards while staying current with laws, policies, and department workflows.
Qualifications
- Education: AA degree in CS or information processing or 24 college credits in CS/IS.
- Experience: 1 year of software applications programming or systems analysis.
- Substitution: additional experience may substitute for education.
Responsibilities
- Developing new applications and maintaining existing ones.
- Familiarizing with department databases and information systems.
- Learn/apply laws, policies, and regulations affecting information systems changes.
- Work with staff to interpret requirements for system enhancements or reports.
- Test, troubleshoot and implement system upgrades and enhancements.
- Provide guidance on information systems policies and procedures.
- Write SQL queries and stored procedures for batch processing.
- Create ad-hoc queries and reports using Excel, Power BI, SSRS, and related tools.
- Build and maintain dashboards and reports using Power BI.
- Develop front end interfaces and BI content in internal sites using HTML, CSS, and JavaScript.
- Monitor and report on project progress and issues; document business processes.
Skills
Education
Tools
Job description
- Providing first-level support for vendor solutions
Bargaining Unit: Local 21 - Non‑Supervisory Management
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.
- 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
- 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
- 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
- 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
- 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
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.
- 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: 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.
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.
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.
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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
