Job Seekers, Please send resumes to resumes@hireitpeople.com
Short Description:
The Data Warehouse Specialist will be primarily responsible for designing and implementing data warehouse and relational database applications also to include business intelligence development and administration.
Complete Description:
Local candidates preferred, but not required.
In addition, this person will be required to provide after hours support, 24 x 7 on a rotating basis.
Qualifications:
Bachelors Degree in Computer Science or related technical field
In-depth Data Warehouse design and implementation (5+ years)
Business Intelligence Software Development and Administration:
Cognos 10, Business Objects 4.1, Information Server, QualityStage 8.5, Data Manager 10
Responsibilities:
-Interviews customer and gathers requirements
-Provides Data profiling, data cleansing, data validation, data standardization, data transformation
-Provides systems analysis, data analysis and proposes appropriate solutions
-Develop scripts and/or applications to integrate components needed for a complete solution
-Provides knowledge transfer and technical support to other programming team members
-Prepare, analyze, and design system requirements throughout the data warehouse implementation
-Identify data sources and determine common data definitions across user groups
-Perform design and implementation of data warehouse schema and cubes
-Review data loaded into the data warehouse for accuracy
-Perform database design, database architecture, and metadata creation
-Provide technical consulting to users of the data warehouse and advises users on conflicts and inappropriate data usage
-Monitor usage of warehouse to identify potential capacity overloads
-Develop advanced reporting
-Other duties as assigned
Skills:
Skill |
Required / Desired |
Amount |
of Experience |
Data Warehouse Design |
Required |
5 |
Years |
Data Warehouse Implementation |
Required |
5 |
Years |
Relational Database Applications |
Required |
3 |
Years |
BI Software (i.e. Qualitystage and Cognos) |
Required |
3 |
Years |
Data Analysis |
Required |
3 |
Years |
DBMS: DB2 /UDB and SQL Server 2005/2008 |
Required |
3 |
Years |