Programmer Analyst II

Portland Community College; Portland (OR); On-site; USD 72,000 - 88,000; Full time

Job summary

Portland Community College is seeking a Programmer Analyst II to design, implement and optimize data reports and extracts for Academic Affairs and Student Affairs. The role focuses on work with Workday reports, large databases, and cross‑functional collaboration to support campus operations.

The position is 95% remote with occasional on‑campus meetings. Minimum qualifications include an associate degree and 2 years in complex systems design and support.

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

Responsibilities

• Develops, modifies and maintains complex programs and reports for PCC administrative needs.
• Analyzes user requirements and designs data extracts and reports for diverse audiences.
• Provides technical guidance and support during development of business processes and procedures.
• Maintains and documents system plans, test results and user guides.
• Supports server and application environments and coordinates with vendors as needed.

Skills

Workday reports

SQL

Higher Education

Collaboration

Self-starter

Communication skills

Problem solving

Requirements translation

Data security

Education

Associate degree in computer related discipline

Job description

Join our Team at Portland Community College

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 degree in computer related discipline. Relevant experience may substitute for the degree requirement on a year-for-year basis.
• Two years experience in complex systems design, programming and systems software and support.

Why You’ll Love Working Here

The PCC district encompasses a 1,500-square-mile area in northwest Oregon and offers two-year degrees, one-year certificate programs, short-term training, alternative education, pre-college courses and life-long learning. As part of our College community, you’ll enjoy:

• A collaborative and inspiring campus community
• Opportunities for learning and professional development

Portland Community College embraces equity and inclusion as a priority. We are committed to building a community with a variety of backgrounds, skills, views, and life experiences. The more we value equity and inclusion, the more we will add value to the work we do and how we serve our students, engage with each other, and the Oregon Community that we serve. Creating a culture that honors equity and inclusion is our objective and the smart path forward.

Position Grade

Classified 25 (A)

Employment Type

Full time

Total Rewards Package / What We Offer

There is never a dull moment at PCC. We offer more than just a competitive salary. When you join our team at PCC you'll also enjoy:

Paid Leave (Pro-rated by FTE for Part-Time Employees) reference Classified Agreement

• Starts at 8 hours of vacation leave per month (additional vacation hours with years of service)
• 1 day of sick leave per month
• 12 paid holidays
• PCC Winter Break (when College is Closed)
• 24 hours of personal leave per year

Comprehensive benefit package

Oregon PERS contribution

Tax deferred annuity program and a deferred compensation program

Tuition waiver for you, your spouse/domestic partner, and dependent children under 24 years of age, as well as partial tuition reimbursement for full-time employees at other accredited institutions

Free access to the sport centers / campus gymnasiums, performing arts, and cultural events

More detailed information on the benefits plans, who is eligible, and how to enroll or make changes can be found at pcc.edu/hr/benefits. Please email [e-mail] if you have any questions.

How We Determine Initial Salary Placement

Minimum $79,763 to range midpoint of $82,154. Placement will generally not exceed the mid-point, based on qualifications, experience, and internal equity.

Oregon Veterans' Preference in Public Employment

Portland Community College complies with the Oregon Veterans' Preference in Public Employment law which provides qualifying veterans and disabled veterans with preference in employment. You will be given instructions during the application process to claim Veterans' Preference in the recruitment of this position, and to provide the documents required for verification of eligibility. Please do not send your documentation to the hiring manager directly. For verification of eligibility, please submit the following documentation:

• Veterans: DD214
• Disabled Veterans: DD214 and Letter from the Department of VA

Notice of the Availability of the Annual Security Report

Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act (Clery Act), you may view Portland Community College’s (PCC) most recent Annual Security Report (ASR) on the Department of Public Safety website. The ASR contains current security and safety-related policy disclosure statements, emergency preparedness and evacuation information, crime prevention and sexual assault prevention information and resources, and drug and alcohol prevention programming. The ASR also contains crime statistics for Clery Act crimes which occurred on PCC properties for the last three calendar years. Paper copies of the ASR are available upon request at all Department of Public Safety offices.

PCC Employment Offers are Contingent Upon the Successful Completion of a Criminal Background Check

Please note that Portland Community College is not currently able to provide visa (e.g. H1-B Visa) sponsorship for potential employees.

Contact PCC at [e-mail] if you have questions

Contact PCC at [e-mail] if you have questions.