SYSTEMS ANALYSTUnion: SEIUFLSA: Non-exemptPay Grade: 11Hours: 37.5 per weekClass specifications are intended to present a descriptive list of the range of duties performed by employees in the class. Specifications are not intended to reflect all duties performed within the job.DEFINITIONTo perform a variety of complex technical duties in the design, application programming and development, PC configuration and support, testing and maintenance of the Village s computer application systems; and to perform a variety of technical duties as required.SUPERVISION RECEIVED AND EXERCISEDReceives general supervision from the Information Technology Director.EXAMPLES OF DUTIES – Essential and other important duties and responsibilities may include, but are not limited to, the following:Essential duties and responsibilitiesAnalyze, develop, implement and maintain computer hardware and software for Village of Oak Park users.Participate in defining programming requirements by performing detailed system analysis of existing business systems and workflow procedures; code software applications in appropriate languages.Develop and maintain computer systems from conception and design to implementation including designing screens; reports and programs; write and test new computer applications and systems; develop accurate time frames for assigned projects.Test and troubleshoot existing computer programs; analyze problems; make modifications to systems and individual programs as required.Perform database analysis to determine the most effective database structure designs; develop and implement new and improved database structures; monitor dataset performance.Confer with staff from various departments to solve system problems; coordinate system activities with users to identify needs; prepare manuals to assist users.Assist various departments with program and operational problems; analyze causes of problems and design solutions; take corrective action.Evaluate operations and activities of assigned system responsibilities, recommend improvements and modifications.Prepare documentation for new systems and changes to existing systems; ensure compliance with established standards and procedures.Participate in the training of users in the use of new or modified computer applications and procedures.Develop reports that enable users to verify and track system output; develop user documentation.Other important responsibilities and duties:Prepare a data processing disaster recovery plan; update the plan as needed.Compile and edit programs; adjust programs as necessary; coordinate projects between consultants and user departments for application development.Participate in the research of new software and hardware; prepare test data for testing various computer programs.Perform basic diagnosis of computer hardware and software malfunctions.Perform related duties and responsibilities as required.QUALIFICATIONSKnowledge of:Principles and techniques of various programming languages, database, computer programming, on-line programming, and programming documentation.A wide variety of computer programming languages and systems, such as, City View Permit, License & Inspection Suite, Laserfiche, ESRI ArcGIS, MS-SQL, Reporting Tools, Java and HTML.Systems analysis and design techniques, such as, database normalization, business analysis, workflow procedure, modular programming, stored procedures, and interface with operation system.Principles and practices of systems analysis, programming, design and documentation, such as application version control, naming conventions, report templates, documenting program code, creating flow charts, database relational diagrams, user documentation and technical documentation.Principles and operating procedures of computer systems and related equipment, such as, software and hardware for client/server environment, computer networking and security.Analyze, design, program, install, and maintain computer systems.Repairing PC components and working with various hand tools.Ability to:Read, interpret and apply complex technical publications, manuals and other documents. Analyze data and develop logical solutions to complex computer application and programming problems.Identify, evaluate and solve program problems.Train or instruct users in the use of computer equipment, software applications, and operating procedures.Make recommendations in computer selection and software application packages.Communicate clearly and concisely, both orally and in writing.Utilize office technology proficiently, such as, typing, word processor, spreadsheet, e-mail, calendar, telephone and voicemail.Establish and maintain interpersonal skills in the workplace to effectively communicate and interact with others.Maintain reasonable and predictable attendanceMaintain physical condition appropriate to the performance of assigned duties and responsibilities which may include the following:Walking, standing, or sitting for extended periods of time.Operating hand tools, such as, crimper, soldier, drill and knifeLifting and installing computer and printer equipment.Maintain effective audio-visual discrimination and perception needed for:Making observationsCommunicating with othersReading and writingOperating assigned equipmentExperience and Training GuidelinesExperience: One or more years of increasingly responsible experience in Windows Client/Server systems, MS Office, Adobe ColdFusion, Drupal, MS -Access, and SQL computer programming and/or systems analysis experience. ANDTraining:Bachelor s degree from an accredited college or university or equivalent, with major coursework in computer science, information technology or a related field, such as, Software Project Management, Web Development, Java, HTML, DBMS and SQL.WORKING CONDITIONSWork in an office environment; sustained posture in a seated position for prolonged periods of time; continuous exposure to computer screens.Diversity Equity & Inclusion StatementThe Village of Oak Park commits itself to diversity, equity and inclusion by recognizing that creating a mutually respectful, multicultural and equitable environment does not happen on its own, it must be intentional. This includes providing equal opportunities for everyone regardless of race, ethnicity, gender identity, sexual orientation, religion, ability, military or veteran status or any other characteristics.