In person interview after telephone Title: Data Warehouse Analyst (405) Contract Duration: 6 months + Location: New Haven, Connecticut
*Minimum Requirements:* *In depth* experience in MS SQL Server 2012 and writing Stored Procedures using T-SQL Expertise in ETL Programming using Microsoft SQL Server Integration Services (SSIS) Experience in writing TSQLT unit test scripts 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 *Description:* The Data Warehouse Analyst is responsible for implementing and supporting the Internal Data Warehouse and Business Intelligence system. The system’s 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:* 1. Installing, configuring and maintaining required software components; 2. Creating and managing data organization models and extract/transform/load (ETL) processes; 3. Implementing and supporting the user interface components used to interact with the warehouse; 4. Working with key users to gather ETL rules and specifications and working with our Data Architect on creating new dimensional data models. Thanks & Regards, Vinay Kumar IT Recruiter Osair Technologies LLC | Desk: 703-349-2825 [email protected] <[email protected]> -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
