Data Warehouse Program

Description:

BASIC FUNCTION:

Strategically manage, design and model a develop the School of the Art Institute of Chicago’s (SAIC) Data Warehouse. Works with the Executive Director of Student Administrative Systems, the CIO and SAIC’s Data Governance Committee in support of efforts to strengthen SAIC as a data driven institution.

DUTIES AND RESPONSIBILITIES:

Design, model, manage the SAIC Student data warehouse which includes data from the Student Information System, Learning Management System, Admissions CRM and other systems.

Designs, creates and maintains SSIS packages to populate dimensional data models within SAIC’s SQL Server-based data warehouse,

Maintain and create packages in SSIS to replicate database tables to capture changes.

Designs, creates and maintains SSIS packages to implement a star schema model designed in SQL Server.

Responsible for troubleshooting and maintaining all ETL loads.

Oversees SQL Server database and servers housing SSIS, data staging and data warehouse environments in coordination with the DBA.

Responsible for development, troubleshooting and oversight of integrations from Peoplesoft to other systems (Salesforce, EAB, Handshake, etc.). May have to write custom SQL to build loads. Scripting proficiency in Python, Perl, Bash, and Powershell preferred. Using REST API to get and post data.

Provides strategic input to discussions related to data governance and data decisions. Translates business requirements into technology requirements.

Meets directly with data consumers and subject matter experts to gather requirements and model fact and dimension tables based on needs. Responsible for maintaining customer relationships and setting and managing expectations.

Hire, train, supervise and provide technical mentorship to the Integration Specialists and Business Analysts/Administrator. Review applicant materials and conduct interviews; communicate job expectations and policies; ensure ability to perform effectively, and as needed provide professional development and/or corrective action plan. Serve as liaison to senior management for employee complaints and initiatives.