Report Developer

Excelsior; United States; Remote; USD 85,000 - 95,000; Full time

Job summary

Excelsior University is seeking a Report Developer for the Albany, NY area with remote work options. You will design, develop, and maintain BI reports and dashboards using Ellucian Banner, PL/SQL and T-SQL, and collaborate with data analysts and business users to fulfill information requests.

The role focuses on building data architectures to support university reporting, requiring 3+ years of SQL experience and a strong BI toolkit including Banner, Power BI, QlikView and Qlik Sense.

Qualifications

• Bachelor's degree in computer science, information technology, systems engineering, database management or related field.
• At least three years’ experience writing and troubleshooting complex Oracle SQL queries and PL/SQL or Microsoft SQLServer queries and TSQL.
• Strong understanding of relational database systems; experience in dimensional modeling desirable.
• Experience with Banner, Power BI, QlikView and Qlik Sense.
• Translate complex concepts into business terms for leaders and non-technical stakeholders.

Responsibilities

• Collaborate with data analysts and business users to analyze, estimate, and fulfill information requests.
• Design and develop reports and dashboards using Ellucian Banner.
• Assist in BI testing including data quality, operations, performance, and usability.
• Deploy, configure, monitor, and maintain reporting artifacts.
• Create and maintain PL/SQL and T-SQL procedures for data processing.
• Understand business workflows and how they’re captured in transactional systems.
• Write technical docs in Data Cookbook.
• Attend conferences and trainings to enhance expertise.

Skills

Oracle SQL

PL/SQL

Microsoft SQL Server

TSQL

Banner

Power BI

QlikView

Qlik Sense

Data modeling

Education

Bachelor's degree in computer science/IT/systems

Tools

PL/SQL

SQL

Job description

Home Office
7 Columbia Circle West Dr
Albany, NY 12203, USA

Description

The Report Developer is a full-time position based at 3 Columbia Circle in Albany, NY. 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.

This position is based out of the university’s home office in Albany, NY with the option of considering remote candidates. Remote employees will have mandatory occasional travel for meetings, conferences, and professional development opportunities. Remote employees are expected to be available during work hours 8:30 am – 5:00 pm Eastern time. The University will supply necessary equipment to perform the essential functions of this job (e.g., Laptop, docking station). Employees are responsible for having a workspace where they can participate in virtual meetings without multiple interruptions and noise.

Duties and Responsibilities:

• 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.

Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• 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.

Preferred Qualifications:

• 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

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.