Business Intelligence Engineer

Job Description

Business Intelligence Engineer

The Office of Institutional Research and Effectiveness (IRE) at Stevens is inviting applications for the position of Business Intelligence Engineer to join a team of talented colleagues.

Under the supervision of the Associate Director, the Business Intelligence Engineer will design, develop, and support Business Intelligence solutions to turn data into actionable insights supporting university decision making, analytics, and research.  An ideal candidate should be extremely data-savvy, and should have solid skills in data modeling, data transforming procedure, and overall business intelligence solutions.

Responsibilities


* Assemble large, complex data sets that meet functional/non-functional business requirements.

Work with subject matter experts to design and develop data models, security structures and reports across subject areas and technical domains.

Identify, design, delegate and implement internal process improvements: automate manual processes, optimize data delivery, re-design infrastructure for greater scalability, etc.


* Create and manage complex SQL queries, stored procedures, and other database objects.

Transform data in the warehouse using dbt.


* Perform data analysis, design, and development of new and ongoing business intelligence (BI) tools (such as Power BI, Tableau) involving complex data structures.


* Build machine-learning algorithms, models, reports, etc., to meet business outcomes and KPIs.



* Plan and conduct data analysis efforts, facilitate design sessions, and collaborate with technical staff, and critical business sponsors to identify and recommend solutions.

Initiate or update designs for models supporting data warehouse functionality.

Coordinate reviews of data models and data definitions.


* Establish and maintain best practices for the design, development and support of BI solutions including self-service analytics, documentation, metadata creation, use and maintenance, and data naming standards.



* Monitor and take appropriate action to maintain the integrity of the reporting solutions, including security and data quality issues.

Respond and resolve operational problems as necessary.

Document, troubleshoot, and resolve day to day data issues.


* Maintain a considerable knowledge base of various types of institutional data stored in Workday (Stevens’ student information system), and IRE data repositories, such as student admissions, enrollment, degree data, course data, and faculty data.


* Assist with data collection and dashboard design for all aspects of external data reporting (IPEDS, state reports, college guidebooks, consortium exchange, etc.), and internal reports for academic and administrative units, such as the weekly enrollment census report, the annual benchmarking report, and other institutional analyses.


* Process, clean, and validate the integrity of data to be used for analysis.


* Analyze larg...