Hands-on Data Warehouse Architect w/ expert Microsoft SQL Server 2008 and SSAS 2008 exp needed for NYC Client



Global Financial Firm is seeking a Hands-on Data Warehouse Architect
w/ expert Microsoft SQL Server 2008 and SSAS 2008 experience.

The successful candidate must have at least 8 years of extensive
experience in working with Large Scale Data Warehouses utilizing SSAS
(MDX). The candidate must be technically adept with excellent
analytical and problem solving skills, highly motivated, quick learner
with strong interpersonal, written, and verbal communication skills.


****The client is also in a fortunate position to guarantee bonuses
for 2012!


Full relocation and H1B Transfers (3 yrs remaining)/Green Card
processing will be made available to those who qualify. This is a
Fulltime opportunity located in New York City.


Responsibilities:
The candidate will be involved in all phases of SDLC and will be
expected to work on design and architecture of our data warehouse
environment, participate in code and technology reviews, and work
closely with other members of the team and the business. The candidate
will be exposed to the variety of data domains and have enormous
opportunities to learn and contribute ideas.


Goals include:
• Enhance the data warehouse infrastructure to support current
systems,
• The set up of synchronization with SAS analytical environment and
data quality tools
• Build ETL layer
• Develop strategy for DR and failover; create tidal jobs to support
needed tasks;
• Support integration with various marketing systems and reporting.

All of the above work will be done using (2008) MS SQL Server, SSIS,
SSRS, SSAS, variety of scripts/languages (C++, VB, C#) and Tidal
Scheduler.


Qualifications:
• Minimum 5-10 years of experience developing stored procedures,
performing optimization and query tuning, and designing databases.
• Solid understanding of Data Warehousing methodologies, various
stages of ETL and data modeling.
• Experience with Web services and SOAP.
• UI Design experience/and or knowledge of JavaScript is a plus
• Strong analytical and creative problem solving skills
• Bachelor of Science/MS/PhD Degree in Computer Science, Engineering,
Finance or Related Field (or equivalent expertise)




If you are interested & qualified, please contact Michael Czirjak at:
212.244.4220 or email your resume to: mczirjak@xxxxxxxxxxxxxxxxxx *
All inquiries will be kept confidential
.



Relevant Pages

  • Re: How to auto-refresh cubes
    ... depends on the definition of the data warehouse. ... SSAS analytical database ... SSIS is usually used for moving, transforming and cleaning data between OLTP ... the cubes and the schedule it... ...
    (microsoft.public.sqlserver.datawarehouse)
  • Senior Data warehouse / OLAP Developer - MDX queries, T-SQL, SSAS, SSIS
    ... The Data Warehouse is a Terabyte in size and is composed of Support ... Site data, surveys, and various other customer data built on SQL ... Consolidate the dimensions & measure groups from two SSAS databases ... Warehouses and OLAP, from analysis to implementation and optimization. ...
    (microsoft.public.sqlserver.setup)
  • Re: Create data warehouse to use on different OLAPs
    ... MS SSAS would it work? ... It doesn't make sense using SSAS to build a Data Warehouse. ... You have to rely on a relational database to build a DWH. ... multidimensional database and should be used to build cubes based on ...
    (microsoft.public.sqlserver.olap)
  • Create data warehouse to use on different OLAPs
    ... Can you use SSAS to create your Data Warehouse and then use other OLAP ... programs to do your cubes and reports? ...
    (microsoft.public.sqlserver.olap)
  • Re: SQL DBA per Server
    ... Data Warehouse Architect ... Production DB hat. ... Microsoft SQL Server MVP ... automation. ...
    (microsoft.public.sqlserver.server)