Careers at RMU

The Senior Programmer/Analyst provides application development and IT analysis services. This role will focus on web based dashboard, report and ad-hoc query SQL-PL/SQL-PostgresQL development/support as well as data transfer/synchronization development/support (via sFTP/files and vendor API use). The scope also includes learning and supporting various 3rd party applications. The incumbent develops requirements and specifications for new software applications, analyzes change requests for existing applications, and translates requirements into technical solutions. The incumbent creates / maintains documentation for software applications and processes. 

The Senior Programmer/Analyst collaborates closely with internal customers throughout the University to identify and document project requirements, specifications and priority. The incumbent participates in and/or leads business process mapping and gap analysis activities and well as collaborates with vendors as needed.

Responsibilities include:

Functional verification and testing activities (test plan creation and execution); ensuring that the developed software applications meet customer requirements based on the specifications, ensuring minimal defects. Accountable for identification and documentation of risks, defects, and issues throughout the project lifecycle.

Assisting in the resolution of risks, defects, and issues. May be directly accountable for a project schedule / deliverables.

Providing proactive project feedback to IT management and/or internal customers. May provide guidance to student worker(s).

General Requirements:

1. Bachelor’s degree in Computer Science, Information Science or a related field.

2. 3+ years experience as a software developer/analyst. Experience developing web based dashboards (using tools such as Ellucian Insights or Tableau), reports, ad-hoc queries (SQL, PL/SQL, or PostgresQL) and data transfer/synchronization solutions is required.

3. Advanced SQL skills are required. Experience working with relational databases such as Oracle and/or Microsoft SQL*Server is required; PostgresQL experience is a plus.
   
   
4. Experience with the Ellucian higher education product suite, specifically Banner (required), Insights and DataConnect is strongly desired. Experience with Evisions Argos / FormsFusion is desired.

5. Experience with some of the following technology is required: Microsoft .Net framework (C#.Net), Javascript, Microsoft SSRS/SSIS/SSAS, Oracle Hyperion/Essbase, Microsoft SQL Server/Management Studio, Toad, pgAdmin, Powershell Scripting, HTML, SQL, PL/SQL, PostgresQL, API use/Postman (desired), sFTP, SaaS.

6. The ability to work in a self-directed manner as well as part of a team is required.

7. Strong analytical and problem-solving skills are required. 

8. Strong interpersonal and customer service skills are required.

9. Strong organizational skills and flexibility to work in a performance driven, multi-tasking environment are required.

10. Experience working with sensitive/confidential information (ex.FERPA) is a plus.

11. Experience with / knowledge of secure IT coding / data transfer techniques (ex. use of encryption, sFTP) is a plus.

12. The ability to work effectively in a remote setting is required. The remote work location must be within a drivable distance to the Moon Township, PA campus as occasional trips to campus are required (Pittsburgh, PA regional area).