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