Job Snapshot
Location:
Manhattan, NY 10010
Employee Type:
Contractor
Industry:
Banking - Financial Services
Job Type:
Information Technology
Experience:
5 to 12 years
Contact Information
Phone:
201-384-7400 ext 114
Description
Our client, a major brokerage firm located in downtown Manhattan is looking for a Datawarehousing Specialist
DESCRIPTION:
The candidate will report to Project Manager and participate in the design and implementation of the data warehouse. Additional responsibilities include: - Participate and assist in data model design process - Participate in entire SDLC process - Understand the business requirement and functional spec and translate to technical solutions
REQUIRED SKILLS:
* At least 5 years of experience responsible for enterprise data warehouse. Experience working in a reporting group for a large financial firm.
* 5 years experience in OLAP architecture design, multi dimensional data modeling, data mart design, data security, ETL processes and process modeling.
* Completed at least 1 data warehouse development with SQL 2005 including ETL (SSIS) and OLAP design (SSAS)
* At lease 2 projects of dimension modeling experience
* Strong in relational database design, fluent in both MDX and T-SQL development
* Expertise in T-SQL stored procedure programming with MS-SQL Server
MAJOR PLUS IF THE CANDIDATE HAS EXPERIENCE ON THE FOLLOWING SKILLS:
* Oracle Hyperion EssBase
* Financial / MIS reporting experience
* SSRS / Business Object Crystal XI
* MDM (Master Data Management) experience. Ex. Hyperion DRM, Microsoft Stratature +EDM.
* .NET development experience
NOTE: For immediate review, please send your resume in word format to jessie@ technosphere.com and Joe.Buenavidez@ technosphere.com
[Click Here to Email Your Resumé]
Important Note: Due to the number of resumes that we received, kindly give us enough time to review the profiles and if we believe that you are fit for the position we will contact you.
Requirements
* Total IT: 5-10 yrs
* Data Warehousing: 5-7 yrs
* SQL Server 2000/2005: 5+ yrs
* OLAP(OLAP architecture design, multi dimensional data modeling, data mart design, data security, ETL processes and process modeling: 3-5yrs
* ETL- 3-5 yrs
* T-SQL stored procedure programming with MS-SQL Server: 3-5+ yrs
* Strong in relational database design, fluent in both MDX and T-SQL development