Sr. Programmer Analyst

Full Time / {Category:2}

District Office

Basic Function
Under the general direction of the Director of Software Applications and Development or higher-level administrator, perform design, programming, testing, installation, and maintenance of information systems.

Representative Duties
Develop, test, install, maintain, and modify information systems, software components, and computer programs according to overall system specifications; document new programs and changes to existing programs in accordance with established standards and procedures; analyze, debug, and test various programs using online tools, assigned languages, and utilities. E

Analyze user needs and develop program specifications for small information systems or components of larger systems. E

Create production and ad-hoc reports using a variety of reporting tools and programming languages per specifications from users and senior programming staff. E

Make recommendations and propose solutions to improve business operations and resolve problems. E

Provide technical support to end users; respond to requests and inquiries regarding the operation, use, and capabilities of information systems; work in conjunction with user support staff to troubleshoot and resolve systems and application problems; prepare end user and technical documentation and instructions; conduct user training sessions as required. E

Implement and participate in the planning, organization, and scheduling of information technology projects. E

Analyze and develop relational databases per specifications; design and create stand alone databases for data collection, analysis, and reporting as assigned. E

Participate in the implementation, maintenance, and testing of new releases of administrative systems provided by third-party vendors. E

Perform ongoing system, application, and software maintenance; perform upgrades, modifications, and enhancements as necessary. E

Assist in the maintenance of appropriate test databases and environments for testing and debugging application systems. E

Perform other duties as assigned.

E = Essential Duties

Minimum Qualifications
A bachelor's degree, preferably with an emphasis in information technology, computer science, management information systems, or a related field AND one year of recent (gained in the past three years) experience performing business applications programming. Experience programming and maintaining components within an enterprise resource planning (ERP) system is preferred.

OR

An associate degree, preferably with an emphasis in information technology, computer science, management information systems, or a related field AND three years of recent (gained in the past five years) experience performing business applications programming. Experience programming and maintaining components within an enterprise resource planning (ERP) system is preferred.

OR

Graduation from high school or evidence of equivalent educational proficiency AND five years of recent (gained in the past seven years) experience performing business applications programming. Experience programming and maintaining components within an enterprise resource planning (ERP) system is preferred.

Knowledge, Skills, and Abilities
KNOWLEDGE OF:

Methods and techniques of software development and programming

Functions and capabilities of computer software applications, including database and spreadsheet applications

Functions and capabilities of various server and workstation operating systems applicable to the position

Principles, procedures, and methods used in data acquisition, storage, structuring, and retrieval

Principles and techniques of systems analysis, design, and testing

Methods and techniques of program documentation and version control

Reporting and query tools applicable to the position

Programming and script languages applicable to the position

Tools and methods used in web page design and development

Enterprise Resource Planning (ERP) systems

New trends in the field of information technology

Principles of database design

Relational database management systems (RDBMS)

Principles of business writing and administrative report preparation

Principles of training

ABILITY TO:

Code highly complex programs

Prepare clear and logical systems design

Present and explain technical concepts to a non-technical audience

Communicate clearly and concisely, both orally and in writing

Establish and maintain effective working relationships with those encountered in the course of work

Provide technical support and training to end users

Work independently with little direction

Identify, analyze, evaluate, and solve complex system and programming problems

Interpret, apply, and explain rules, regulations, policies, and procedures

Organize and prioritize timelines and project schedules in an effective and timely manner

Learn the characteristics of new systems and update skills to adapt to changing technology

Write clear and comprehensive reports, instructions, and program documentation

Understand and carry out oral and written directions