Data Warehouse Analyst is needed to perform data integration (ETL - Extract-Transform-Load) activities. This resource will work on the Clearinghouse to CDW Data Integration project and the CAIS V2 to V3 and Generic Assignment Module project for CDW.
This position is responsible for design, construction and implementation of ETL processes for the Data Warehouse solution. They will work closely with the Lead Data Warehouse Analyst and use their knowledge of Data Warehousing and Business Intelligence from gathering requirements through implementing solutions for retrieving, loading, combining and summarizing data from multiples systems into the Data Warehouse. This is a technical development role, heavily involved in technical design, development, unit and system testing activities relating to Data Warehouse data load utilities and processes.
MUST HAVE:
· Minimum two years experience in large data warehouse projects from design through production support
· Minimum five years of SQL Development
· Minimum two years of SQL Development in Data Warehouse ETL development experience
· Minimum two years experience with SQL Server 2000 or 2005 RDBMS
· Minimum two years experience with SQL Server DTS or SSIS ETL tools
· Ability to clearly and concisely document all ETL and SQL processes and Job and Scheduling information
· Ability to read, interpret and develop Data Flow Diagrams
· Knowledge of Relational, Star Schema and Dimensional database modeling techniques
· Knowledge of Denormalized and Reporting table database modeling techniques
· Strong ETL Design and Development skills
· Strong SQL query, SQL DML (Data Manipulation Language) and relational database design skills
· Computer literacy in Microsoft Word, Excel and Outlook
· Experience working in the Property & Casualty insurance industry