Programmer Analyst I

Position Details

Position Information

Job Title Programmer Analyst I Department Web & Enterprise Systems Job Code A44321 Job category Full Time Staff Terms and Hours Full Time Exempt Salary Range Starting Salary $64,562; commensurate with experience Job Summary

The Programmer Analyst I primary responsibility is to support key modules of the Banner Enterprise Resource Planning (ERP) platform at the University while working in collaboration with the Banner Team. The role involves working closely with functional staff in administrative offices to understand business needs and help execute solutions, build strong working relationships, and provide personalized guidance and support. The Programmer Analyst will support ERP business process efficiencies at the University by developing and troubleshooting reports, queries, and scripts. This position will build expertise with Banner and its data structures through cross-training with Program Analysts and reporting directly to the Banner Manager.

Core Duties

• Collaborate with departmental Banner users and University stakeholders to identify projects for system or organizational improvement to improve efficiency, add new capabilities, improve security, and/or cut expenses.
• Analyze functional and technical requirements related to Banner modules, ensuring accuracy, standards, and integrity of all data being added, changed and/or deleted. Utilize the ticketing system for production changes with the help of Database Administrator (DBA).
• Develop and maintain SQL and PL/SQL scripts to support Banner processes
• Design and generate reports using Argos.
• Document processes to support in the cross training of Programmer Analyst.
• Recognize critical or time-sensitive tasks and work with the Banner Manager and functional partners to provide business continuity within agreed timeframe and scope.
• As directed by the Banner Manager and the Director of Web and Enterprise Services, contribute key project deliverables in enterprise projects.
• Provide high quality support for Banner modules and assist customers with troubleshooting issues related to Banner modules, scripts and queries.
• Support departmental data leads to test, deploy, and troubleshoot new solutions and features within enterprise systems. Facilitate communications to support the flow and access to accurate data processes.
• As part of a coordinated team, monitor the health and performance of large relational databases, design queries to support project and task work, and troubleshoot issues.
• Identify and propose potential projects for systems or organizational improvements to improve efficiency, add new capabilities, improve security, or cut expenses.
• Execute successful project deliverables as driven by the Banner Manager and Director of Web and Enterprise Services.
• Work directly with the underlying Oracle database components of Banner, including tables, forms, and views to support business offices with existing and new processes through crafting, testing, and deploying scripts in PowerShell and/or Linux.
• Support the end-user offices to ensure a high degree of customer service with accuracy, privacy, and security of their administrative information.
• Build effective collaborative relationships within the Programmer Analyst team and among University departments to strengthen technical outputs and data management throughout the University.

Other duties as relevant to the duties of the position or as assigned by supervisor or designee.

Please note that the above list of duties is not comprehensive but generally demonstrates the types of matters under this position's purview and responsibility.

Education & Experience

• Required: Bachelor's degree; preferably in computer science or data disciplines.
• Required: 1 to 3 years professional experience within a technical role with strong database querying skills, specifically using Oracle PL/SQL.
• Preferred: Experience supporting a Finance/Accounting Team and translating business requirements into technical solutions, ideally within a higher education institution.
• Preferred: Experience with Ellucian Banner.
• Or a combination of equivalent education and/or experience.

Certifications & Licenses

• Preferred: None.

Knowledge, Skills & Abilities

• Technical knowledge of systems and concepts underlying enterprise application environments, including:

• Linux, Windows Server, Tomcat, Oracle, Microsoft SQL Server, PL/SQL, T-SQL, and command line interfaces such as PowerShell

• Relational database concepts and practices in an enterprise environment

• Common network protocols and standards used in web-based enterprise applications and integrations, such as HTTP/HTTPS, FTP/FTPS, SOAP/REST, etc.

• Ability to learn and understand relevant business processes & requirements of assigned departments.

• Strong orientation towards taking ownership of projects and assignments and proactive with projects, assignments, and process improvements.

• Ability to consistently handle and follow through with multiple projects and assignments and meet deadlines. Able to be flexible and adaptable to changing priorities to function effectively in a busy work environment.

• Project management skills with the ability to assist staff in discovery and communication.

• Excellent attention to detail and accuracy.

• Strong critical-thinking, problem-solving, and decision-making skills. Able to implement and use sound judgment.

• Ability to engage in analytical problem solving. Ability to review and analyze simple to more complex information and to learn and apply applicable University policies and processes.

• Strong organizational, time management and prioritization skills.

• Strong orientation towards continued learning and applying learning in the work setting.

• Ability to maintain confidentiality and effectively handle highly sensitive and personal information with sound judgment, tact, and discretion.

• Strong ability to work collaboratively, accomplish organizational goals, communicate clearly, manage conflict, and act proactively.

• Effective verbal and written communication skills.

• Ability to work independently but also to constructively receive supervisory direction and work collaboratively and effectively in a team setting.

• Competence with and commitment to inclusive excellence; ability to be an effective partner with diverse students, faculty, and staff.

• Ability to establish effective working relationships, professional rapport, and effectively accomplish work within a University setting that includes a wide array of individuals, groups, policies, and processes.

• Effective ability to use and learn computers, technology, software, and applications at level of sophistication required for the duties of the position, including, without limitation, Microsoft Office (Outlook, Word, Excel, and PowerPoint), the internet, and computerized maintenance management systems.

• All University of Portland positions require the ability to quickly learn and use new technologies, software, and applications in depth and at level of proficiency required for duties of the position. In most situations, the necessity of learning, using, and supporting new technologies, software, and/or applications does not change a job description nor make the position one that involves higher level duties.

Physical Requirements

• Frequently: sit, perform desk-based computer tasks; use fine manipulation and grasp; use a telephone; write by hand; sort and file paperwork.
• Occasionally: stand and walk; twist; lift, carry, push, and pull objects that weigh up to 10 pounds.
• Occasionally: ability to attend events and activities on or off campus.
• Frequently: ability to interact and communicate with members of the University and others as necessary.

Working Conditions

• Hours of employment: sometimes may require working flexible and/or longer hours, including nights and weekends, when necessitated by projects.
• Stress from work-related situations such as those involving challenging, important, urgent, time-sensitive, or multiple matters.

Work Standards

• Respect for the University's mission and Catholic identity: demonstrates commitment to learning, respecting, and contributing to the mission of the University, a Catholic and Congregation of Holy Cross institution. The University's mission statement states in relevant part: "we pursue teaching and learning, faith and formation, service and leadership in the classroom, residence halls, and the world."The University's Statement of Inclusion states in relevant part: "Our belief in the inherent dignity of each person is founded upon the social teaching of the Catholic Church. At the center of that teaching is the fundamental mandate that every person, regardless of race, color, religion, gender, sexual orientation, social or economic class, age, or disability shall be treated with respect and dignity."

• The full Mission Statement is at: www.up.edu/about/mission.

• The full Statement of Inclusion is at: www.up.edu/disclosures/inclusion.

• Promote culture of safety: demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviors based on training and lessons learned.

• Compliance with laws and policies and procedures: subject to and expected to comply with all applicable University, departmental, and other applicable policies and procedures, including but not limited to, the personnel, business, and/or other policies of the University.

• Compliance with driving-related laws and requirements: when conducting university business while driving, must comply with the Oregon Vehicle Code and University of Portland driving requirements.

• Interpersonal skills: demonstrates the ability to work professionally with all University of Portland community members, external organizations, and any other person or organization employee interacts with in his or her University capacity.

Benefits

Medical and dental insurance, life insurance, sick time and vacation time consistent with University policies, long-term disability insurance, flexible spending account benefits, tuition remission benefits generally starting after 90 days (employee) or 2 years (spouse and children) of employment, retirement contributions generally starting after 2 years of employment, and eligibility for the University's home purchase assistance program consistent with program requirements. (Benefits are subject to all relevant University policies, practices, contracts, and any other relevant materials.)

Posting Detail Information

Posting Number S371-2023 Number of Vacancies Estimated Start Date Open Date Close Date Open Until Filled No Special Instructions Summary

Required Documents

Required Documents

• Resume
• Cover Letter

Optional Documents

Supplemental Questions

Required fields are indicated with an asterisk (*).

• What interests you about working in higher education and what appeals to you supporting the mission and operations of the University through technology?

(Open Ended Question)

• Describe your experience supporting business processes and operational requirements through technology solutions. Please include an example of how you identified a business need, gathered requirements, and implemented or supported a technical solution.

(Open Ended Question)