Report Developer

Excelsior University; City of Albany (NY); On-site; USD 85,000 - 95,000; Full time

Job summary

Excelsior University in Albany, NY is seeking a full-time Report Developer to join their BI team. This role involves collaboration with stakeholders to deliver business intelligence solutions, focusing on report design and development using Ellucian Banner.

Candidates should have a Bachelor's degree in a related field and at least three years of experience with SQL queries. The hiring salary range is between $85,000.00 and $95,000.00, reflecting the importance of this role in the organization.

Qualifications

• Bachelor's degree required in relevant field.
• Minimum of three years' experience with SQL queries.
• Strong understanding of relational database systems.

Responsibilities

• Analyze and fulfill requests for reports from transactional systems.
• Design and develop reports and dashboards using Ellucian Banner.
• Assist in BI systems testing, including data quality assurance.

Skills

Oracle SQL

PL/SQL

Microsoft SQLServer

Data analysis

Business intelligence

Education

Bachelor's degree in computer science or related field

Tools

Ellucian Banner

Power BI

QlikView

Qlik Sense

Job description

The Report Developer is a full‑time position based at 3 Columbia Circle in Albany, NY. The role is part of the BI team within Information Technology Services and reports to the Reporting Manager. The developer collaborates with stakeholders, analysts, business users, and technology staff to deliver business intelligence solutions for Excelsior University, including designing, developing, and maintaining reports or applications using Ellucian Banner and related systems.

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 PL/SQL 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

• 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 with Banner, Power BI, QlikView and Qlik Sense is desirable.
• Experience translating complicated technical concepts into simple and effective business terms for 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.

Excelsior University is an equal opportunity employer committed to ensuring all qualified applicants receive consideration for employment without regard to any legally protected characteristic.