Job Standard for Programmer Analyst 1

View in Google Docs/Download

Employee Name:

Employee ID:

Employee PCN:

How to use this Job Standard:

1. Click “View in Google Docs/Download” and download to Word.
2. The Job Overview, Level Scope, Minimum Qualifications and Essential Job Functions are specific to this job’s competencies and cannot be edited.
3. For the Job Posting you may;
   1. update/change the purpose to add in department specific information, 
   2. add key responsibilities to the 35% of the time, specific to your department needs, 
   3. add a preferred qualifications section
   4. post the position using the business title

The statements on this job standard are intended to describe the general nature of the role and level of work being performed. They are not intended to represent an exhaustive list of all responsibilities, duties and skills required of the employee.

Programmer Analyst 1 Overview

• Work Type: Non-Classified/Professional
• Job Code: 75722
• Pay Grade: P6
• FLSA Status: Exempt
• Career Level: Associate
• Family: Information Technology
• Function: Development

Purpose

Responsible for providing technical professional programming work to design, maintain and support enterprise resource planning (ERP) applications for the Office of Information Technology.

Level Scope

Entry-level professional with limited or no prior experience to contribute on a project or work team. Incumbent learns to use professional concepts to resolve problems of limited scope and complexity under close supervision while achieving day-to-day objectives. Works on developmental assignments that are initially routine in nature, requiring limited judgment and decision making. This level is typically focused on self development. Requires theoretical knowledge through specific education and training.

Minimum Qualifications

Bachelor’s or Advanced Degree in Computer Science, Computer Information Systems, Information Technology or a related field or equivalent relevant experience.

Knowledge, Skills and Abilities

• Excellent analytical, troubleshooting and problem-solving skills.
• Experience working with relational database technology.
• Knowledge of Structured Query Language (SQL) to query data for problem solving, to create ad hoc reports, to repair data and to convert data in the database.
• Knowledge of and interest in, one or more object oriented programming languages.
• Knowledge of systems development life cycle (SDLC), including waterfall and iterative approaches.
• Ability to contribute to technical conversations and collaborate effectively with technical and non-technical staff members.
• Demonstrated successful performance with coordinating and completing multiple tasks to meet aggressive and changing deadlines.
• Excellent organizational and communications and interpersonal skills.
• Knowledge of or experience with role requiring confidentiality, timeliness, customer service, organization, prioritization and working independently.
• Ability to select which technical alternative best solves a problem by discussing and asking for input from colleagues, weighing client requirements, functionality, standards, performance, re-usability, long-term maintainability, extensibility and time to implement.
• Ability to determine when to file a case and/or to escalate an existing case with the vendor’s support center.
• Ability to determine when to escalate an issue to Manager.
• May require on-call availability and may require working outside of business hours and weekends.

Essential Functions

Key Responsibilities

60% of Time the Programmer Analyst 1 must:

• Use ERP software development tools to support, maintain and enhance ERP software and to write SQL to query and update data in the database. The assignments typically include simple requirements, small features and limited integrations; existing business processes; support of vendor-supplied updates; and/or program modifications. This position generally requires direction from more senior technical staff or a supervisor/manager.

• Provides incident/problem resolution and on-call support for enterprise applications during and outside of business hours and weekends.
• Investigates, gathers information, analyzes and researches to get beyond symptoms to expose the cause of each reported incident/problem. Resolves incidents/problems by making changes to enterprise software and/or writing SQL scripts to repair data in the database to resolve incidents/problems using standards and best practices. Incidents generally range from low to moderate complexity. Incidents often involve precedent and/or are routine.
• Demonstrates quality service and accountability in the process of resolving incidents, requests, fixes resulting in accurate, timely and efficient solutions and data as evidenced by meeting customer needs and by meeting or exceeding established performance metrics and task estimates.
• Contacts and works with software vendor(s) to resolve issues with delivered software. Follow-up with vendor(s) and escalate support requests as necessary.
• Supports maintenance efforts by reapplying impacted customizations during maintenance projects. Researches vendor provided modules, enhancements, updates, fixes and upgrades and determine impacts. Researches and applies vendor best practices and standards.
• Documents problem resolutions clearly and concisely in tracking system(s) according to department standards.
• Assignments include but are not limited to development, support, maintenance, configuration, customization, troubleshooting, upgrades, integration and maintenance of systems.

• Translates requirements into a technical design and programmatic solutions which are testable and easily maintained and which follow established standards and methodologies. Consults with other more senior staff and users in the design of solutions.
• Creates processes to update data within the ERP system according to standards.

• Uses appropriate tools for incident, problem, change and knowledge management.
• Utilizes analytical and communication skills to understand written procedures, processes, technical documentation and technical support knowledge bases. Proposes process and documentation improvements to senior staff.

• Stays current with relevant advances in technologies and ERP tools via on-the-job training, attending technical courses or conferences, reading, research, etc.
• Keeps manager updated on progress relative to performance development goals.
• Demonstrates skill development by applying new skills/knowledge to the job as evident by the ability to efficiently and effectively perform assigned duties, resulting in meeting or exceeding performance metrics and project estimates.

35% of Time the Programmer Analyst 1

Determined by department needs

5% of Time the Programmer Analyst 1

Perform other duties as assigned

Work Environment and Physical Demands

General Office – Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently (Frequently: activity or condition exists from 1/3 to 2/3 of the time) to lift, carry, push, pull, or otherwise move objects, including the human body. General office work involves sitting most of the time, but may involve walking or standing for brief periods of time.

Punctual, regular and consistent attendance is required.

On-Call – Requires on-call availability and may require working during non-business hours and on weekends.

Travel Requirement

May be required to travel to various locations on and off campus, possibly with overnight stays,  for training and/or conferences.

Career Path

Programmer Analyst 2.

Additional training/education or equivalent experience, as well as business need, are required for movement into higher level jobs.

Disclaimer

Incumbent must perform the essential duties and responsibilities with or without reasonable accommodation. The above statements are intended to describe the general nature and level of work. Final employment offers are  contingent upon a Final Candidate’s successful completion of a Background Verification and a determination by the University that the information derived from the Background Verification does not disqualify the individual. In addition, a Financial History Check and Motor Vehicle Record (MVR) Check may be required.