Excelsior College

Business Intelligence Developer


Pay$85000.00 - $95000.00 / year
LocationAlbany/New York
Employment typeFull-Time

This job is now closed

  • Job Description

      Req#: BUSIN002247

      This full-time hybrid role reports to the Director of Business Intelligence (BI) within the Information Technology Services unit. Only two required days per week at Excelsior's home office: 7 Columbia Circle Albany, NY. The remaining days can be worked from home. The BI Developer is a member of the BI team participating in building, extending, and maintaining data architecture that supports the analytical needs of the University. Collaborating with analysts, end users, and other technology staff is expected. Gathering and understanding business requirements is essential. Developing an in-depth understanding of data maintained in various application systems, and how it is best organized or integrated is mandatory. Designing, building, and maintaining reports and dashboards is necessary.

      • Work in collaboration with business users to analyze, estimate, and fulfill requests for information and reports from transactional systems.
      • Understand business workflow, processes, and events. Relate your understanding to how these are captured in transactional systems.
      • Design and develop dashboards using QlikView, Qlik Sense, Power BI, and other BI tools.
      • Assist in BI systems, performance, and usability testing.
      • Deploy, configure, monitor, and maintain BI systems.
      • Develop, test, and maintain PLSQL or TSQL queries to meet customer requirements.
      • Assist in executing, monitoring, and administering extract/transform/load (ETL) processes within the data warehouse environment.
      • Prepare accurate time estimates for projects and manages tasks to meet timelines.
      • Write technical documentation and term definitions in Data Cookbook.
      • Enhance professional 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
      • Understanding of Higher Education business concepts, procedures, and practices is preferred.
      • At least five years' experience writing and troubleshooting complex SQL queries (PL/SQL and TSQL).
      • Proficiency with normalization techniques (5NF) and designing star schemas.
      • Experience with reporting tools like Power BI, QlikView, Qlik Sense is preferred.
      • Strong analytical, research, and critical thinking skills with attention to detail.
      • Experience in creating requirements analysis documentation accurately defining expectations of multiple projects and stakeholders.
      • Excellent organizational skills including managing multiple priorities, adhering to timelines, and providing high quality services.
      • Ability to learn and adapt new technologies

      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.

      Qualifications

      Education

      Required

      Bachelor of Science

      Bachelor of Science

  • About the company

      Excelsior College is a private online university in Albany, New York.

Notice

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.