Job Standard for Programmer Analyst 2
How to use this Job Standard:
- Click “View in Google Docs/Download” and download to Word.
- The Job Overview, Level Scope, Minimum Qualifications and Essential Job Functions are specific to this job’s competencies and cannot be edited.
- For the Job Posting you may;
- update/change the purpose to add in department specific information,
- add key responsibilities to the 35% of the time, specific to your department needs,
- add a preferred qualifications section
- 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 2 Overview
- Work Type: Non-Classified/Professional
- Job Code: 75723
- Pay Grade: P8
- FLSA Status: Exempt
- Career Level: Intermediate
- Family: Information Technology
- Function: Development
Responsible for providing technical professional programming work to design, maintain and support enterprise resource planning (ERP) applications at an intermediate level.
Fully competent and productive professional contributor who applies acquired job skills, policies and procedures to complete substantive assignments/projects/tasks of moderate scope and complexity. Works independently with general supervision; exercises judgment within defined guidelines and practices to determine appropriate action. May provide guidance and assistance to entry level professionals and/or support employees.
Bachelor’s or Advanced Degree in Computer Science, Computer Information Systems, Information Technology or a related field and 2 years of professional experience or equivalent relevant experience.
Knowledge, Skills and Abilities
- Excellent analytical, troubleshooting and problem-solving skills.
- Experience working with relational database technology.
- Demonstrated ability to interpret and to write complex SQL statements.
- Proficiency in using PeopleSoft Tools (Application Designer, Application Engine, Process Scheduler, PeopleCode, XML Publisher and SQR).
- Experience designing and developing software using structured techniques.
- Proficiency with one or more procedural and/or object oriented programming languages.
- Demonstrated successful performance with coordinating and completing multiple tasks to meet aggressive and changing deadlines.
- Knowledge of systems development life cycle (SDLC), including waterfall and iterative approaches.
- Excellent organizational and communications and interpersonal skills.
- Experience with user interface design and knowledge of usability best practices.
- Skill in troubleshooting technical issues and in the use of troubleshooting and trace tools.
- Ability to determine how and when to create new and/or modify existing enterprise application program code, application objects and reports.
- Ability to select which technical alternative best solves a problem by discussing and asking for input from colleagues, weighing client requirements, functionality, standards, performance, reusability, long-term maintainability, extensibility and time to implement.
- May require on-call availability and may require working outside of business hours and weekends.
60% of Time the Programmer Analyst 2 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. Assignments require some originality and ingenuity and typically include moderate to complex requirements, features and integrations; changes to existing business processes and creation of new business processes; support of vendor-supplied updates; and/or program modifications.
- Works with multiple ERP application modules. This position generally requires direction from more senior technical staff or a supervisor/manager. Mentors junior staff.
- Comprehends and distills issues, identifies problem factors, determines appropriate information, checks assumptions against facts and generates solutions.
- Takes responsibility for work while seeking direction, guidance or assistance as needed. May require on-call availability and may require working outside of business hours and weekends.
- Provides incident/problem resolution and on-call support for enterprise applications during and outside of business hours and weekends.
- 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.
- 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.
- Assists and coaches junior staff in troubleshooting and resolving production support incidents/problems.
- Collaborates with users, customers, business analysts and other technical staff to review software requirements and functional specifications, delineating the gaps between customer requirements and the capabilities of existing technology and resources and recommending designs that are user-friendly and compliant with technical requirements. Proactively recommends improvements to requested features and functionality.
- Translates requirements into a technical design and programmatic solutions which are testable and easily maintained and which follow established standards and methodologies.
- Writes new and/or modifies existing ERP software programs, objects and reports including unit testing, coding, migration instructions and technical documentation (including entity relationship diagrams and program structure diagrams), for use with multi-application, multi-user database systems.
- Perform impact analysis of proposed ERP software customization’s, which includes reading through the software program code to determine the feasibility and impact of the customization’s.
- Stays current with relevant advances in technology via on-the-job training, attending technical courses or conferences, reading, research, etc.
- Mentors other staff.
- Facilitate peer review of own work and participate in peer reviews of team members.
- Follows project plans; records and tracks progress of project tasks, features and improvements. Reports status in a timely manner.
- Provides estimates for tasks based on experience and team standards. Provides status reports, exchanges relevant information with management and project teams and meets timelines. Notifies management of potential risks and issues.
- Effectively utilizes leadership, analytical and creative problem solving skills, interpersonal and communication skills, along with standard processes and methodologies, as evident by successful support and implementation of projects (including upgrades) resulting in project completion that meets requirements and quality expectations and that meets estimates.
35% of Time the Programmer Analyst 2
Determined by department needs
5% of Time the Programmer Analyst 2
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.
May be required to travel to various locations on and off campus, possibly with overnight stays, for training and/or conferences.
Programmer Analyst 3.
Additional training/education or equivalent experience, as well as business need, are required for movement into higher level jobs.
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.