The Report Developer is a member of the BI team within Information Technology Services reporting to the Reporting Manager. Collaboration with stakeholders, analysts, business users and technology staff to deliver BI solutions to Excelsior University is expected. Gathering and analyzing business requirements; designing, developing, and maintaining reports or applications using Ellucian Banner are necessary.

The Report Developer is expected to develop an in-depth understanding of data maintained in various application systems, and how it is best organized or integrated. This position will participate in efforts to build, extend, and maintain the underlying data architecture that supports reporting needs of the University.

Este puesto está basado en la oficina central de la universidad en Albany, NY, con la opción de considerar candidatos remotos. Los empleados remotos tendrán que viajar ocasionalmente para asistir a reuniones, conferencias y oportunidades de desarrollo profesional. Se espera que los empleados remotos estén disponibles durante las horas de trabajo de 8:30 am a 5:00 pm hora del Este. La Universidad proporcionará el equipo necesario para realizar las funciones esenciales de este trabajo (por ejemplo, ordenador portátil, estación de acoplamiento). Los empleados son responsables de disponer de un espacio de trabajo en el que puedan participar en reuniones virtuales sin múltiples interrupciones ni ruidos.

Funciones y responsabilidades:

•  Work in collaboration with data analysts and business users to analyze, estimate, and fulfill requests for information and reports from transactional systems.
• Design and develop reports and dashboards using Elucian Banner
•  Assist in performing BI systems testing, including data quality assurance, operations process, performance, and usability testing.
•  Perform tasks related to the deployment, configuration, monitoring, and maintenance of reporting artifacts.
•  Create and maintain PLSQL and TSQL procedures to process and store data.
• Maintain a strong understanding of business workflow, processes, and events and how these are captured in transactional systems.
•  Write technical documentation and term definitions in Data Cookbook.
•  Enhance professional knowledge and skills by attending conferences and advanced training in required areas of expertise.

Cualificaciones: Para desempeñar este trabajo con éxito, un individuo debe ser capaz de realizar cada deber esencial de forma satisfactoria. Los requisitos que se enumeran a continuación son representativos de los conocimientos, la destreza y/o la capacidad necesarios. Se pueden realizar adaptaciones razonables para que las personas con discapacidades puedan realizar las funciones esenciales.

•  Bachelor's degree in computer science, information technology, systems engineering, database management or related field required.
• At least three years’ experience writing and troubleshooting complex Oracle SQL queries and PL/SQL code OR Microsoft SQLServer Queries and TSQL.
• Strong understanding of relational database systems. Experience in designing and developing dimensional models is desirable.
• Experience with enterprise-level business intelligence applications and reporting tools. Experience in Banner, Power BI, QlikView and Qlik Sense are desirable.
• Experience translating complicated technical concepts into simple and effective business terms to high-level leaders and non-technical people.

Cualificaciones preferidas:

• Experience in Banner, Power BI, QlikView and Qlik Sense.
• Strong understanding of relational database systems.

The hiring salary range for this position is $85,000.00 - $95,000.00. The hiring salary range above represents the University's good faith estimate at the time of posting