Programmer Analyst I

University of Portland

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
positions purview and responsibility.

Education & Experience

• Required: Bachelors 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 Universitys 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 Universitys 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 Universitys 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.

Special Instructions
Summary
To apply, please visit: https://uportland.peopleadmin.com/postings/5311

jeid-405412cb2466a349b2c976d989139a8a

Tagged as: CSS