Careers at RMU

Overview:

The Programmer-Analyst / Senior Programmer-Analyst primarily provides Business Intelligence (BI), data integration, query and data analysis services. This role focuses on web-based data driven dashboard development, SQL based report development, SQL-PL/SQL-PostgreSQL query development/support, data mining / analysis as well as data integration (middleware) development leveraging sFTP and vendor APIs. The scope also includes learning and supporting various 3rd party software applications as needed. The incumbent develops requirements for new software solutions, analyzes change requests to existing applications, translates requirements into technical solutions and performs data analysis. The incumbent also creates / maintains documentation for software applications and processes.

The Programmer-Analyst / Senior Programmer-Analyst collaborates closely with internal customers throughout the University to identify and document project requirements, prioritize tasks, develop business intelligence-data driven solutions and provide data analysis / software support services. The incumbent participates in and/or leads business process mapping and gap analysis activities and well as collaborates with vendors as needed. This is a fully remote role that may require occasional trips to the Moon Township, PA campus. Preference will be given to candidates in the Pittsburgh, PA region.

Responsibilities:

Business Intelligence (BI) services, SQL development / data mining, data integration development, report development, general software support, verification and testing activities; ensuring that software solutions meet customer requirements while ensuring minimal defects. The incumbent is accountable for identification and documentation of risks, defects, and issues throughout a project lifecycle and providing proactive feedback to IT management and/or internal customers. The incumbent may also provide supervision / guidance to student worker(s).

General Requirements:

1. Bachelor / Masters level degree in Data Analytics, Computer Science, Information Science or related field.
2. Generally 3-10 years of experience in a programmer/data analyst type role; business intelligence (BI) related experience is a desired. Experience developing: web-based data driven dashboards (using tools such as Ellucian Insights, Power BI, Tableau and/or Excel), SQL based reports, queries (SQL, PL/SQL, or PostgreSQL) and data migration solutions (sFTP/APIs) is required. The desire and ability to learn and apply new technology is also required.
3. Advanced SQL skills and experience working with relational databases such as Oracle and/or Microsoft SQL*Server is required; PostgreSQL and Powershell experience is a plus.
4. Experience with the Ellucian higher education product suite, specifically Banner, Insights, DataConnect, and Ethos is desired. Experience with Evisions Argos reporting / FormsFusion is also desired.
5. Experience with C# and working with SaaS software solutions is desired and a plus. Experience using Excel or Google Sheets to support data analysis related activities is required.
6. The ability to work in a self-directed manner as well as part of a team is required.
7. Strong analytical, problem-solving skills, and data analysis skills are required. 
8. Effective communication, interpersonal and customer service skills are required.
9. Strong organizational skills and flexibility to work in a performance driven, multi-tasking environment is required.
10. Experience working with sensitive/confidential information (ex.FERPA) is a plus.
11. Experience working in higher education is a plus.
12. The ability to work effectively in a remote setting is required. Preference will be given to candidates within a drivable distance to the Moon Township, PA campus as occasional trips to campus may be required (Pittsburgh, PA regional area).