Database Systems Analyst/Programmer

Lake County, IL; Waukegan (IL); On-site; USD 70,000 - 110,000; Full time

Job summary

Lake County, Illinois is seeking a Database Systems Analyst & Programmer to support and develop applications for the Court organization. The role designs, codes, tests, and analyzes software, researching and modifying specifications to deliver effective solutions.

The position requires strong technical expertise, independent work, and after-hours Help Desk support, reporting to the Director of Judicial Information Systems & Technology.

Qualifications

• Requires bachelor’s degree in computer science or master’s degree.
• Experience with enterprise and desktop applications preferred.
• Knowledge of Django and Python preferred.
• Knowledge of HTML, CSS, and JavaScript preferred.

Responsibilities

• Provide application support and development of new applications for the Court organization.
• Design, code, test, and analyze software programs and applications.
• Research, design, modify software specifications, and resolve issues.
• Provide daily and after-hours Help Desk support as needed.
• Create documentation explaining processes, procedures, system changes.

Skills

Django

Python

HTML

CSS

JavaScript

Relational databases

Documentation

Requirements analysis

Testing

Education

Bachelor's degree in Computer Science

Master's degree in Computer Science or related field

Tools

SQL

Job description

The Database System analyst & Programmer provides application support and development of new applications required by the Court organization.

The Database Systems Analyst & Programmer designs, codes, tests, and analyzes software programs and applications. Responsibilities include researching, designing, and modifying software specifications, resolving application issues and providing status updates as needed.

The position requires strong technical expertise and independence, provides daily and after-hours Help Desk support, and reports to the Director of Judicial Information systems & Technology.

Hours of Work

Monday through Friday 8am-5pm

• Demonstrates proficiency in programming languages identified by the JIS Division, to develop efficient, well-structured programs and procedures.
• Demonstrates an ability to interpret requirements and to develop clear, concise programming specifications, procedures, and functions for system enhancements and new development.
• Demonstrates the ability to analyze existing processes, and develop effective, efficient solutions.
• Demonstrates knowledge of relational database concepts.
• Proposes database changes in a manner that ensures the consistency of database files and fields
• Follows established JIS programming standards and change management procedures.
• Maintains an organized development library containing active code.
• Performs thorough unit testing ensuring programs meet specifications while minimizing rewrites,
• Designs, develops, modifies, tests, and debugs data entry display screens, reports, and other system outputs.
• Creates clear, concise documentation explaining processes, procedures, system changes, and proposed solutions.
• Assesses user business needs; defines requirements, conducts feasibility studies and recommends appropriate technology solutions.
• Conducts user training on systems and applications.

This job description is not designed to cover or contain a comprehensive listing of all required activities, duties, or responsibilities. Duties, responsibilities, programs, and activities may change, or new ones may be assigned

• In-depth, hands‑on knowledge of and experience with enterprise and desktop applications.
• Working knowledge of the principles of computer programming and systems analysis, design, testing and documentation.
• Working knowledge of Django and Python is preferred
• Working knowledge of HTML, CSS, and JavaScript is preferred.
• Working knowledge of the general operating principles and capabilities of computer hardware and software
• Working knowledge of software reference libraries and related utility programs
• Working knowledge of computer security systems and procedures
• Working knowledge of computer networking and telecommunications
• Working knowledge of computer operating systems
• Working knowledge of database management systems
• Ability to prepare and interpret computer program documentation
• Ability to adhere to standards, procedures, guidelines and technical manuals
• Ability to analyze policies, procedures and operations, organize their component parts into system specifications, databases and/or programs and adapt them to an automated system
• Ability to troubleshoot and resolve routine hardware and/or software problems
• Working knowledge of the principles of project management
• Ability to work outside of normal business hours
• Able to develop and interpret technical documentation for training and end user procedures.
• Knowledge of trends in technology relating to software applications.
• Ability to present ideas and communicate in both technical and user-friendly language
• Understanding of the branch’s goals and objectives.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Experience working in a team-oriented, collaborative environment.
• Possesses the understanding and ability to work with confidential information on a regular basis.
• Ability to understand and carry out oral and written instructions. Follows policy and cooperates with supervisor.

Education and Work Experience Requirements (Ed and/or Other Requirements)

• Requires education or training equivalent to a bachelor’s degree in computer science or master’s degree.

Other Qualifications

• Valid Illinois driver's license
• Must pass a criminal background check

Physical Requirements

Requires light to medium work involving standing or walking some of the time, exerting up to 50 pounds of force on a regular basis, and moderate dexterity in operating machinery, tools, or office equipment.

Lake County offers a competitive salary and benefit package. Visit our Prospective Employee page to get additional information on why you should work for Lake County!

Any offer of employment is contingent upon the successful completion of a background screening, drug and alcohol testing and may include a pre-employment medical exam. Only employees who have completed the probationary period are eligible for a transfer or promotion.

Lake County is committed to being a diverse and inclusive workplace and is proud to be an equal opportunity employer.