Data Warehouse Specialist
Company Name:
Astyra Corporation
Required to provide after hours support, 24 x 7 on a rotating basis.
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.
Responsibilities:
Interviews customer and gathers requirements.
Provide Data profiling, data cleansing, data validation, data standardization, data transformation.
Provide systems analysis, data analysis and proposes appropriate solutions.
Develop scripts and/or applications to integrate components needed for a complete solution.
Provide 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.
Qualifications:
Bachelors Degree in
computer
Science or related technical field.
In-depth Data Warehouse design and implementation experience. 5
years required
Experience with Relational Database Applications. 3 years required
Data Analysis experience. 3 years required
Business Intelligence Software Development and Administration experience. 3 years required
Experience with DBMS: DB2 /UDB and SQL Server 2005/2008. 3 years required
Experience with Cognos 10, Business Objects 4.1, Information Server, QualityStage 8.5, and Data
manager
10. 3 years requiredEstimated Salary: $20 to $28 per hour based on qualifications.
Astyra Corporation
Required to provide after hours support, 24 x 7 on a rotating basis.
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.
Responsibilities:
Interviews customer and gathers requirements.
Provide Data profiling, data cleansing, data validation, data standardization, data transformation.
Provide systems analysis, data analysis and proposes appropriate solutions.
Develop scripts and/or applications to integrate components needed for a complete solution.
Provide 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.
Qualifications:
Bachelors Degree in
computer
Science or related technical field.
In-depth Data Warehouse design and implementation experience. 5
years required
Experience with Relational Database Applications. 3 years required
Data Analysis experience. 3 years required
Business Intelligence Software Development and Administration experience. 3 years required
Experience with DBMS: DB2 /UDB and SQL Server 2005/2008. 3 years required
Experience with Cognos 10, Business Objects 4.1, Information Server, QualityStage 8.5, and Data
manager
10. 3 years requiredEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
