Programmer Analyst II

portlandcc; United States; Hybrid; USD 80,000 - 110,000; Full time

Job summary

Portland Community College seeks a Programmer Analyst II to troubleshoot complex data issues, design and implement reports and data extracts for diverse college needs. The role covers Academic Affairs and Student Affairs systems, with 95% remote work and occasional on-campus meetings.

Reporting to the Academic Systems Manager, you will support Workday reports, large database designs, and data analytics while collaborating across PCC teams.

Qualifications

• Experience developing Workday reports.
• Experience supporting & programming systems with large database designs.
• Experience with SQL.
• Experience with Higher Education.
• Ability to work in a collaborative environment.
• Self-starter, can plan own work & manage time.
• Good oral and written communication skills for a variety of audiences.
• Problem solving and data analytics skills.
• Ability to translate user requirements into user accepted solutions.
• Knowledge of data security.

Responsibilities

• Develops, modifies and maintains complex programs and reports for PCC data needs.
• Analyzes and plans systems based on PCC requirements and staff input.
• Designs and documents systems and data flows for university workflows.
• Develops databases, programs and procedures to integrate systems and ensure reliability.
• Documents systems for user departments in line with PCC standards.
• Assists users with implementation, training and troubleshooting of systems.
• Provides technical advice, ad-hoc reports, data corrections and vendor liaison as needed.

Skills

Workday reports

Large database designs

SQL

Higher Education

Collaborative work

Self-starter

Verbal & written communication

Problem solving

Requirements translation

Data security

Education

Associate degree

Job description

Join our Team at Portland Community College

Please Note: PCC currently limits employment to individuals residing in Oregon and Washington. Employment offers are contingent upon the ability to establish residence in Oregon or Washington.

Portland Community College will also ensure that applicants requiring reasonable accommodation for the hiring process are provided for. If reasonable accommodation is needed, please contact the PCC Talent Acquisition Team at [e-mail].

Portland Community College is the largest post-secondary institution in Oregon and 19th largest in the nation, serving approximately 80,000 full- and part-time students. With four comprehensive campuses, five workforce training and education centers, and 200 community locations in the Portland metropolitan area, our unique role is to make high-quality education accessible to everyone, creating opportunities for our students and contributing to the economic development of our community.

We are seeking a creative, solutions-oriented collaborator to join our growing team. Our team interacts with others at all levels of Portland Community College and enjoys constant variety and challenge. If you are an enthusiastic contributor who enjoys being in the middle of important work, wants to help shape organizational change, and are interested in working with large scale, complex information systems (such as Workday and Banner) that serve students and staff in higher education, this position is for you.

Reporting to the Academic Systems Manager, the Programmer Analyst II troubleshoots complex data issues, assesses potential data-focused solutions, and designs and implements reports and data extracts for diverse higher education needs, including both technical and non-technical audiences. Additionally, you may serve as a consultant and technical expert during the development of more complex business processes and procedures.

This position is responsible for both Academic Affairs and Student Affairs application systems.

This position is 95% remote with occasional required on-campus meetings.

See the classification description for additional information: https://www.pcc.edu/hr/employment/classified-jobs/proganal2/ What You’ll Do and Who We Are Looking For

Typical Duties and Responsibilities

• Develops, modifies and maintains complex programs. Monitors the operation of assigned programs and responds to problems by diagnosing and correcting errors in logic and coding. Develops special programs, such as a critical path analysis program to assist in managing a special project. Reviews user requirements and needs for new software and performs analysis, design, implementation, installation and training related to new software developed and/or acquired.
• Analyzes and plans systems based on consultations with PCC management and/or staff. Document system plan and establishes an implementation schedule.
• Designs and documents systems based on analysis results and further consultation with PCC management and staff.
• Develops data bases, programs and procedures necessary to integrate and/or implement the system. Tests system fully to determine its operational reliability.
• Documents system for user department and ITS conforming to institutional standards.
• Assists user and operating areas in implementing and supporting systems including system installation, training and troubleshooting.
• Carries out fact-finding and program analysis of problems; determines most appropriate procedures to resolve. Provides technical advice and support to users. This includes creating ad-hoc reports, data analysis and correction, training and problem solving. Assists in selecting hardware and software to be used by college staff. Maintains contact with vendors to assist support activities. Serves as technical advisor to user staff who do programming functions. May install, modify and maintain systems and utility software on server computer systems. Provides server support related to network software. May guide or provide work direction to lower level Programmer/Analysts, other technical staff and/or student employees.
• Positions in this classification may perform all or some of the responsibilities above and all positions perform other related duties as assigned.

These qualifications, skills and abilities are critical for success in this position. Throughout the screening process, you will be evaluated based on the demonstration of these qualifications.

• Experience developing Workday reports
• Experience supporting & programming systems with large database designs
• Experience with SQL
• Experience with Higher Education
• Ability to work in a collaborative environment
• Self-starter, can plan own work & manage time
• Good oral and written communication skills for a variety of different audiences (both technical & functional)
• Problem solving and data analytics skills
• Ability to translate user requirements into user accepted solutions
• Knowledge of data security

Minimum Qualifications

Associate de