Data Warehouse Analyst

Description

Job Description The Data Warehouse Analyst is responsible for implementing and supporting the Yale University Data Warehouse and Business Intelligence system.The systems initial goal is to support the reporting needs of a planned upgrade of the CRM system, in which there will be need to expand the existing Data warehouse and source reports from it. Responsibilities of the position include installing, configuring and maintaining required software components, creating and managing data organization models and extract/transform/load (ETL) processes, implementing and supporting the user interface components used to interact with the warehouse, working with key users to gather ETL rules and specification and work with our Data Architect on creating new dimensional data models.SKILLS NEEDED In depth experience in MS SQL Server 2012 and writing Stored Procedures using TSQL Expertise in ETL Programming using Microsoft SQL Server Integration Services(SSIS) Experience in writing TSQLT unit test scripts will be a plus Expertise in Relational Databases and Dimensional Data Modeling. Experience in creating Type1, Type2 and Type6 Dimensions Experience with TOAD Data Modeler will be a plus Experience in Report Development using Microsoft SQL Server Reporting Services (SSRS) Experience with Blackbaud CRM and Blackbaud DW is a plus Ability to develop from a Technical Specification and good documentation skills