Application Programmer / Analyst
Main Campus, Winterville, NC
Closes: Friday, June 30, 2023
Target Start Date
Expected Work Hours
Associates degree in a computer related field desired or a combination of at least two years of college education and proven progressive work experience in an IT environment.
- Visual Studio and .NET (C# preferable).
- Querying Databases using SQL and/or UniQuery for SQL-based or UniData environments, respectively.
- Reporting against databases and general experience in data analysis.
- Supporting, developing, and/or maintaining Ellucian’s Colleague ERP system (or similar ERP system) and associated applications.
- Knowledge of programming solutions that utilizes XML, JSON, and web service technologies (WSDL, SOAP, REST).
- Developing applications for Android and/or iOS.
- Setting up Windows Server/ IIS (or Apache Tomcat) web applications and services.
- Ability to present technical information to non-technical audiences.
- Ability to work successfully in a team environment, prioritize a variety of work assignments and meet deadlines.
- Good written and verbal communications skills.
Data Utilization: Requires the ability to review, classify, categorize, prioritize, and/or analyze data and/or information. Includes exercising discretion in determining data classification and in referencing such analysis to established standards for the purpose of recognizing actual or probable interactive effects and relationships.
Human Interaction: Requires the ability to provide guidance, assistance, and/or interpretation to others on how to apply procedures and standards to specific situations.
Equipment, Machinery, Tools, and Materials Utilization: Requires the ability to operate, maneuver and/or control the actions of equipment, machinery, tools, and/or materials used in performing essential functions, personal computers, and printers. Also requires the use of various word processing software, database systems, desktop publishing, academic specialty software, and spreadsheet software.
Verbal Aptitude: Requires the ability to utilize a variety of reference data and information, such as computer software manuals, documentation, and PCC policy manual.
Mathematical Aptitude: Requires the ability to perform addition, subtraction, multiplication, and division; ability to calculate decimals and percentages; ability to perform mathematical operations involving basic algebraic principles and formulas.
Functional Reasoning: Requires ability to apply principles of rational systems. Ability to interpret instructions furnished in written, oral, diagrammatic, or schedule form. Possess ability to exercise independent judgment, to adopt or modify methods and standards to meet variations in assigned objectives.
Situational Reasoning: Requires the ability to exercise the judgment, decisiveness and creativity required in situations involving evaluation of information against measurable or verifiable criteria.
Physical Ability: Tasks involve the ability to exert moderate, though not constant physical effort, typically involving some combination of climbing and balancing, stooping, kneeling, crouching, and crawling, and which may involve some lifting, carrying, pushing and/or pulling of objects and materials of moderate weight (12-20 pounds). Tasks may involve extended periods of time at a keyboard or work station.
Dexterity: Requires the ability to perform simple movements requiring moderate coordination, such as operating computer equipment and peripherals.
Sensory Requirements: Some tasks require the ability to perceive and discriminate colors or shades of colors. Some tasks require visual perception and discrimination, as well as oral communications ability.
Environmental Factors: Tasks may risk exposure to adverse environmental conditions, such as bright or dim lights, machinery, electric currents, or toxic agents.
Knowledge of Work: Has considerable knowledge of the methods, procedures and policies of Pitt Community College as such pertains to the performance of the essential duties of Application Programmer/Analyst. Has considerable knowledge of principles and practices of computer program design, support, and maintenance. Has considerable knowledge of the laws, ordinances, standards, and regulations pertaining to the essential duties and responsibilities of the position. Has working knowledge of the organization of the department, and of related departments and agencies. Clearly understands the occupational hazards and safety precautions required to perform the essential functions of the work. Has considerable knowledge of terminology and related professional languages used within the department as such pertains to work responsibilities. Knows how to maintain cooperative and effective relationships with intra-and interdepartmental personnel, as well as any external entities with whom position interacts.
Quality of Work: Maintains high standards of accuracy in performing duties and responsibilities. Exercises immediate remedial action to correct any quality deficiencies that occur in areas of responsibility. Maintains quality communication and interaction with intra- and interdepartmental personnel, and any external entities with whom position interacts.
Quantity of Work: Performs described Essential Functions and related assignments efficiently and effectively in a manner to produce a quantity of work which consistently meets established standards and expectations.
Dependability: Assumes responsibility for completion of assigned functions. Completes assigned work within established deadlines in accordance with directives, policies, standards, and prescribed procedures. Maintains accountability for assigned responsibilities in the technical, human, and conceptual areas.
Attendance: Attends and remains at work regularly and adheres to policies and procedures regarding absenteeism and tardiness. Provides sufficient notice to upper management with respect to vacation time and leave requests.
Initiative and Enthusiasm: Exhibits an enthusiastic, self-reliant and self-starting approach to meet job responsibilities and accountabilities. Strives to anticipate work to be accomplished, and initiates appropriate and acceptable action for the completion of work with a minimum of supervision and instruction.
Judgment: Exercises analytical judgment in areas of responsibility. Identifies issues or situations as they occur and specifies decision objectives. Identifies or assists in identification of alternative solutions to issues or situations. Implements decisions in accordance with prescribed and effective policies and procedures and with a minimum of errors. Seeks expert or experienced advisement where appropriate, and researches issues, situations, and alternatives prior to exercising judgment.
Cooperation: Accepts supervisory and managerial instruction and direction, and strives to meet the goals and objectives of same. Questions such instruction and direction when clarification of results or consequences is justified, i.e., poor communications, variance with established policies and procedures, etc. Offers suggestions and recommendations to encourage and improve cooperation both intra- and interdepartmentally.
Relationships with Others: Shares knowledge with managers, supervisors and co-workers for mutual benefit. Contributes to maintaining high morale among all employees. Develops and maintains cooperative and courteous relationships both intra- and interdepartmentally, and with external entities with whom position interacts. Tactfully and effectively handles requests, suggestions, and complaints in order to establish and maintain good will. Emphasizes the importance of maintaining a positive image.
Coordination of Work: Plans and organizes daily work routine. Establishes priorities for the completion of work in accordance with sound time-management methodology. Avoids duplication of effort. Estimates expected time of completion for work elements, and establishes a personal schedule accordingly. Attends required meetings, planning sessions and discussions on time. Implements work activity in accordance with priorities and estimated schedules.
Creativity: Regularly seeks new and improved methodologies, policies and procedures for enhancing the effectiveness of department and College. Employs imagination and creativity in the application of duties and responsibilities. Supports achievement of goals and objectives.
Safety and Housekeeping: Adheres to all established safety and housekeeping standards, to include regulatory entities. Ensures such standards are not viola
Under general supervision, the purpose of the position is to provide customization and maintenance support for application programs of the College’s enterprise information system. Gather, analyze and modify data using high level programming languages and report creation software. Position is responsible for maintaining state mandated administrative application software; developing and implementing local custom administrative software; and providing technical support of all administrative software and administrative related hardware needs. Supervised by and reports to the Director of Application Development.
The list of essential functions, as outlined herein, is intended to be representative of the tasks performed within this classification. It is not necessarily descriptive of any one position in the class. The omission of an essential function does not preclude management from assigning duties not listed herein if such functions are a logical assignment to the position.
Gathers information on administrative user’s situation; diagnoses the problem or request and if necessary, refers to documentation or external resources to resolve the situation.
Designs and develops computer programs and/or queries to meet user need requirements. Examples include file creation, update and maintenance and report queries; develops entire modules as needed.
Designs, develops and writes web applications for ERP system including the integration of database files with said applications. Develops and maintains database management system computed fields and may include the creation and customization of localized files.
Sets up and configures the automation of program execution when needed.
Installs and troubleshoots externally provided administrative software for the NC Community College System and other vendors.
Develops and maintains data exported to third party systems including the creation, formatting and transfer of the data.
Converts and maintains unsupported programs and reports to ensure continued functionality.
Train users in capabilities, limitations and proper use of automated systems.
Assist Information Systems’ Systems Administrators with troubleshooting application code.
Identify data issues needing process refinement or development.
Perform quantitative and qualitative data analysis as it relates to data cleanup or data modifications.
Performs other related duties as required or assigned.