Business Intelligence Developer

Closing Date

April 19, 2022

Status

Full Time

Location

Albany, NY

Apply Now View All Jobs
The Business Intelligence Developer is a member of the BI team within Technology and Facility Services reporting to the Director of BI. Collaboration with stakeholders, analysts, business users and technology staff to deliver BI solutions to Excelsior College is expected. Gathering and analyzing business requirements; designing, developing, and maintaining reports or applications using QlikView, Qlik Sense and other BI tools is necessary. The BI 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 or analytical needs of the College. This is a full-time hybrid role with a minimum of two required days at Excelsior's home office of 7 Columbia Circle, Albany, NY, with the remainder of the days worked from home. 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 QlikView, QlikSense and other BI tools.
  • 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 business intelligence systems.
  • Create and maintain PLSQL and TSQL procedures to process and store data.
  • Assist in executing, monitoring, and administering data extract, transform, and load (ETL) processes within the production data warehouse environment.
  • 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 and data warehousing concepts. Experience in designing and developing dimensional models is desirable.
  • Experience with enterprise-level business intelligence applications and reporting tools. Experience in 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.

Application Information

If you have problems with online submission, please call 518-608-8270.

Excelsior College offers competitive compensation and a generous benefits package that includes paid time off, retirement, and excellent health insurance. Interested candidates should submit a letter of application, resume, and the names of three professional references. Please submit requested information by clicking the Apply Now button on this page.

AA/EOE/ADA

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

Apply Now View All Jobs