Transcript
Cache County Job Description Title: Division: Department:
Programmer / Analyst Administration Information Technology
Code: Effective Date: 8/08 Last Revised: 6/12
GENERAL PURPOSE Performs a variety of technical and professional duties as needed to deliver computer services to county departments and assure proper on-going system efficiency and effectiveness. Performs technical programming duties, as well as system analysis and design. SUPERVISION RECEIVED Works under the general supervision of the Information Technology Director. SUPERVISION EXERCISED Provides functional supervision to system users as needed to prevent workflow disruptions and maintain system efficiencies. Provides close to general supervision of IT Technicians on a project by project basis on related work. ESSENTIAL FUNCTIONS General: Performs software analysis, design, and development; consults with supervisor, department heads, and elected officials on specific program needs; receives, records and schedules written job requests for existing systems or new system development; completes software development for assigned and planned applications; determines project priorities in concert with supervisor and follows up on schedule deadlines; provides technical assistance to IT staff as needed to solve technical problems. Software Development: Develops custom applications in a team environment; responsible for individual projects and assigned areas of county systems, maintains and troubleshoots existing applications; involved in various types of applications from data processing to end user applications; develops applications that access database systems, files, and network resources; Involved in entire software development lifecycle including design, planning, development, testing, debugging, and maintenance of projects; responsible for designing intuitive and useful user interfaces; responsible for testing applications; writes clean, well documented, and reusable code; safeguards program source code and ensures check in of verified and working code; responsible for fixing issues with existing code; requires ability to read and understand existing code; ensures that modifications to existing code are sound; identifies system and file security needs and levels of confidentiality and ensures protection of data; Analysis and Design: Translates real world processes and data into software solutions and participates in architecture discussions; required to plan, research, design, and collaborate on workable solutions and see them through completion; aids with implementation of third party software solutions; determines optimum configuration for third party applications; identifies user and system requirements; develops program specifications; ensures integrity of interrelated systems, develops integration requirements with other processes and systems (both manual and computerized); designs and develops database structures in concert with Database Administrator; creates modeling diagrams, flowcharts, and algorithms when needed and communicates with users and departments on the correctness of planned projects; aids in data conversions when required; coordinates system implementations with users and departments; confers with supervisors and department representatives to resolve questions of program intent, output requirements and related controls over programs and data; audits programs and processes to ensure data integrity; reviews and rewrites programs to increase operating efficiency.
Documentation and Training: Trains and instructs county personnel in the use of implemented computer applications and systems; produces user and developer documentation for county applications and processes, including user manuals and online documentation available in user applications; assures that processes and applications are explained and well documented, including time critical and sequence critical processes; Miscellaneous: May assist in selection, installation, and maintenance of computer and server hardware; provides customer support; assists in general county-wide "help desk" operations to ensure efficient and effective operations unique to each county department; Performs other related duties as required. MINIMAL QUALIFICATIONS 1. Education and Experience: • Graduation from accredited college with a bachelor's degree in computer science, management information systems, programming, systems analysis, or related field of study; AND • Two (2) years of progressively responsible experience in programming, system analysis and design, and relational databases; OR • An equivalent combination of education and experience. 2. Required Knowledge, Skills, and Abilities: Considerable knowledge of .NET and Visual Studio Development (.NET Framework 2.0 and above); Requires specific experience with VB.NET; mature understanding of programming fundamentals and object oriented design; proficiency in development of Windows Forms and Class Libraries; Strong skills with ADO.NET; thorough understanding of SQL and relational database concepts and implementation, with a working knowledge of SQL queries, views, stored procedures, and functions; database tuning experience helpful; specific experience with SQL Server 2005/2008 and T-SQL helpful; experience with report design and creation; understanding of user interface design principles and ability to create intuitive applications. Possess advanced skill in the operation of a computer and computer systems; understanding of operating system fundamentals (Windows XP – 7, Server 2003-2008, Linux); knowledge of software applications including but not limited to Microsoft Office Suite (Word, Excel, Access); HTML and related web development knowledge helpful; knowledge of ASP.NET helpful; setup and installation of computer hardware including, but not limited to personal computers, printers, scanners, network interfaces, and other computer peripherals; understanding of computer networking, enterprise network devices, and network protocols (TCP/IP, etc.); Skill in typing (50 wpm). Ability to organize, plan, prioritize, and deal with competing demands on time while managing complex computer system operations; ability to read and understand code, manuals, and language references; aptitude for learning new technologies; recognize and solve problems related to data, software, and processes; understanding of system design and information system management concepts; negotiation techniques; understanding of county government and property tax administration helpful; knowledge of accounting and billing and payment systems helpful; knowledge of telephone systems and voice messaging programs helpful; ability to clearly document processes and programs;
Works well within a team; personable and able to develop effective working relationships with supervisors, elected officials, fellow employees, and citizens; can communicate technical information effectively both verbally and in writing; 3. Special Qualifications: • Must have a valid Utah Drivers’ License with fewer than two moving violations within the past 24 months, and no DUI or ARR violations within the past five (5) years. • May be required to work extended daily hours and weekends as needed to maintain computer operations; may be required to be or become Spillman System Certified; occasional travel required. 4. Work Environment Daily performance of duties involves activities that require walking, standing, stooping, sitting, climbing, and lifting (50 lbs); muscular strength of arms, hands, back and legs is necessary; Talking, hearing, and seeing essential to the performance of essential functions, as well as common eye, hand, finger, leg and foot dexterity; duties generally performed indoors in controlled climate; requires mental acuity and the ability to concentrate for long periods of time; mental application requires emotional stability in dealing with time deadlines, problem solving, and stresses of emergency response needs.
