JOB OVERVIEW

  INDUSTRY:  Telecommunications

  LOCATION:  Frederick, MD

  SALARY:  $75,000 - $80,000

  POSITION TYPE:  Full-Time, Employee

  EMAIL:  resumes@jenncohrm.com

  JOB CODE:  JOB0210

Data Warehouse Architect

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 commercial applications. This work will involve technical design as well as coding (construction).

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

Education Requirements:

• BS/BA in computer information technology, computer science, management systems, or related discipline