Job Description

Job Description

Application Deadline: 06/26/2023, 11:59 PM

To read the complete job description and apply to the position, please use the following link: https://www.governmentjobs.com/careers/contracosta/jobs/4043074/information-systems-programmer-and-analyst-ii

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

The Department of Conservation and Development (DCD) is seeking to fill one (1) Information Systems Programmer and Analyst II vacancy. The Programmer will be working with other IT staff and is responsible for supporting and maintaining existing systems in DCD. We are looking for candidates fluent with Microsoft SQL server database knowledge and advanced querying, SSRS report development, Oracle database, Access databases, and Javascript. Experience and knowledge of Accela Land Management, API interfacex, .NET framework, website development, Power BI tools, Visual C, C# are highly desired.

All interested and qualified individuals are encouraged to apply.

We are looking for someone who is:

• Experienced with SQL database, Oracle SQL developer, SSRS, Microsoft Visual Studio, web development, APIs, Javascript, JSON, .Net Windows framework, IIS, XML, Visual Basic, C++, C#, HTML, CSS, Access Database and MS Office 365
• Knowledgeable in coding, testing, and troubleshooting issues in front-end and back-end applications
• Experienced with requirement gathering, scripting, forms, workflow, report development, and evaluating the effectiveness of change
• Driven and has the desire to learn new technology and adapt to these changes
• Is a collaborator that is articulate both verbally and in writing, and communicates clearly and professionally with the team and with internal/external customers
• Dependable as your team and office will rely on you for support

What you will typically be responsible for:

• Learning and updating department’s information system databases and applications
• Testing and implementing department’s system upgrades and systems enhancements
• Resolving application problems via cross-functional team participation
• Working with staff to identify client needs and recommend/implement resources
• Learning how to create ad-hoc queries, design reports and provide analysis of data in the form of complex Excel spreadsheets, and charts using PowerBI, SSRS, or other reporting tools
• Coordinating and documenting systems, projects, and processes including end-user training
• Developing and validating user acceptance test data for accuracy of expected results
• Maintaining confidentiality, meeting critical deadlines, and managing priorities and workload
• Acting as a representative on a variety of related work projects
• Learning the pertinent laws, ordinances, regulations, policies, MOUs, rules, and regulations and advising staff as necessary

A few reasons you might love this job:

• You will work with a great team that is passionate about their work
• You will have the opportunity to engage with a wide variety of stakeholders to create innovative solutions
• We offer a 9/80 work schedule
• You will work in a multifunctional work environment where you can get hands-on experience and learn a wide range of systems infrastructure with room for growth, advancement, and career training
• Professional development funds are available for this position

A few challenges you might face in this job :

• You will encounter various levels of expertise from internal and external customers, and some may require more support and guidance to be successful
• You will need to learn to navigate through complex, sometimes outdated/ conflicting business rules and or policies to assist others in reaching operational objectives
• The demands and needs of the department can change rapidly and you will need to adapt
• Conducting after-hours system implementation 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

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: Two (2) years 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:

• Experience with Accela Land Management
• Experience extracting and analyzing data from Oracle or SQL databases
• Experience with managing MSSQL database and creating batch jobs
• Integrate data from various back-end services and databases
• Experience with web and mobile app development
• Knowledge of various web-based system front-end API/GUI frameworks (SharePoint, .NET, REST API) and backend database platform for GIS Server/Datastore)

Company Description

Why join the Contra Costa Department of Conservation and Development?

The Department of Conservation and Development (DCD) is responsible for facilitating land use and development consistent with the County General Plan, administering, and enforcing the Building and Zoning Codes, and coordinating various programs for the County. In addition, DCD staff administers a variety of programs and initiatives that improve our communities, serve some of our most vulnerable residents, and pride themselves on providing excellent public services.

DCD’s is headed by a Director, and within DCD there are five (5) divisions under a Deputy Director or Assistant Deputy Director: 1) Current Planning, 2) Policy Planning, 3) Building Inspection Services, 4) Business and Information Services, and 5) Housing and Community Improvement. DCD’s main office is located in Martinez. DCD has a total staffing of approximately 165 positions serving the entire County of Contra Costa.

Company Description

Why join the Contra Costa Department of Conservation and Development?\r\n\r\nThe Department of Conservation and Development (DCD) is responsible for facilitating land use and development consistent with the County General Plan, administering, and enforcing the Building and Zoning Codes, and coordinating various programs for the County. In addition, DCD staff administers a variety of programs and initiatives that improve our communities, serve some of our most vulnerable residents, and pride themselves on providing excellent public services.\r\n \r\nDCD’s is headed by a Director, and within DCD there are five (5) divisions under a Deputy Director or Assistant Deputy Director: 1) Current Planning, 2) Policy Planning, 3) Building Inspection Services, 4) Business and Information Services, and 5) Housing and Community Improvement. DCD’s main office is located in Martinez. DCD has a total staffing of approximately 165 positions serving the entire County of Contra Costa.