A major brokerage firm located in downtown Manhattan is looking for a Datawarehousing Architect/Data Modeler. 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.

Qualifications:
- At least 7 years of experience responsible for enterprise data warehouse. Experience working in a reporting group for a large financial firm.
- 5-7 years experience in OLAP architecture design, multi dimensional data modeling, data mart design, data security, ETL processes and process modeling.
- 5- 7 years experience with developing structured systems specifications, including logical and physical data modeling/design
- Expert SQL Server 2000 and 2005 skills required.Extensive experience with all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing, documentation, and training other team members.
- Expertise in T-SQL stored procedure programming with MS-SQL Server
- Experience in MS Analysis Services (SSAS)

Plus:
Experience in SQL Integration Services(SSIS)

NOTE: For immediate review, please send your resume in word format to jessie@technosphere.com

Experience Level:
5+ Years

Requirements:
Total IT- 6-10yrs
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:6-7yrs
ETL- 7 yrs
T-SQL stored procedure programming with MS-SQL Server: 5+ yrs
Experience in MS Analysis Services

Location: New York NY
Duration: 12+ months
Pay Rate: Open

Contact Information:
Technosphere, Inc.
155 North Washington Avenue 3rd Floor
Bergenfield, NJ 07621

Contact: Technical Recruiter
Phone: (201) 384-7400
Fax: 201-385-8243

This entry was posted on Sunday, March 15th, 2009 at 12:00 pm and is filed under Uncategorized. Tags: data mart, data modeling, Data Warehouse, Datawarehousing Architect, OLAP, SQL, structured systems. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.