Data Warehouse Architect
Department: Development
Location: Pittsburgh, PA
Type: Full Time
Job Description:
The Data Warehouse Architect is responsible for the analysis and development of logical and physical data models for a full functioning data warehouse and ad-hoc reporting solution for client users of our commercial applications. This work will involve technical design as well as coding (construction).
Education Requirements:
- BS/BA in computer information technology, computer science, management systems, or related discipline
Experience:
- Five or more years of experience in SQL Server 2000/2005 database design, management, optimization, analysis services, SSIS, data mining and business intelligence solutions
- 3 or more years relevant work experience in Data Warehouse Design and Development
- 3 or more years in data modeling and OLAP design in a RDBMS environment
- 3 or more years performing MS SQL Server 2000/2005 database administration
Skills Required:
- Expert at creating and maintaining Data Warehouse / Data Marts
- Expert at data modeling and OLAP design
- Expert at all aspects of SQL development (SSIS, stored procedures, triggers, functions, etc)
- Expert at performance monitoring, tuning, and optimization
- Proficient at capacity and hardware planning to meet space/performance needs
- Proficient at creating and maintaining database deployment scripts
- Proficient at SQL Server Reporting Services (SSRS) installation design and implementation
- Knowledge of SSRS data models
- Knowledge of SSRS report wring
- Strong analytical skills and the ability to work with end users to transform requests into robust solutions
- Excellent oral and written communication skills
Release date: 10/23/2007