Wednesday, September 15, 2010

Sr. Data Warehouse Architect Large Financial Company/ NJ 200K+ Total Comp




Call or text 203-29-QUANT 203.297.8268 if you have any questions and are qualified for this role or others posted. Please speak clearly if leaving a voicemail, and let me know the role you are applying for and if you have sent a resume or not. You may call or text at any time. All discussions and messages are fully confidential... If QUALIFIED &AUTHORIZED FOR USA WORK, email resume QuantRec

Goto for updates on jobs, bookmark it!

You can fax in resume to 206-202-7703 as well.

PLEASE BE SURE TO INCLUDE your salary requirements (2009 base/bonus), location preferences, and for my notes where you have been interviewing or been submitted to in the past 6 months (as there are multiple opportunities if you are a solid techie). Must currently be in USA and be Green CARD/US CITIZEN/h1b with enough years left on visa (at least 3 years).

Also include the best times to reach you over the near term.

Candidates MEETING MOST OF the SPEC below will be contacted PROMPTLY.
Solution Architect - (Data Warehouse Architect)

Position is for senior data warehouse architect who can not only take full ownership of the project, starting with requirements definition, but person needs to be hands on in all three major areas of 1) Data Modeling 2) ETL Architecture and Develoment 3) BI Development/ Multi-dimensional modeling.

Main Function
Establish ownership and be accountable for the PrimeDB project pipeline from initial definition of requirements through sizing and estimation as key inputs to planning and project management functions
· Build and maintain strong partnerships with Service Delivery Management and Product Management teams to drive functional strategy and project definition

· Lead analysis of all systems builds and define the appropriate solution to meet documented business requirements

· Lead strategic transformation of the data architecture through implementation of a proper Enterprise Datawarehouse & Reference Data Service

Main Duties
Work with project leads to insure solutions are implemented with fidelity to design and functional standards.
· Insure functional enhancements are gracefully implemented without resulting in adverse impact to existing architecture or system stability

· Optimize the ETL function for data sourcing & provisioning

· Implement a framework to enforce data and service quality on the Prime Brokerage ODS and Datawarehouse.

Person Requirements
Basic Qualification

10 yrs plus progressive work experience with Prime Brokerage/Prime Services. Strong business domain knowledge is an absolute must.
Preferred Qualifications

· Strong hand-on knowledge programming & performance tuning in Sybase. Knowledge of additional RDBMS (MS SQL Server, Oracle) is a big plus.

· Solid experience in building front-to-back Datawarehouse & BI solutions, with specific emphasis on Dimensional modeling & ETL architecture.

· Knowledge of Informatica as the ETL tool is a significant plus

· The role does not carry staff management responsibility but the ability to manage by influence is the key to this role

· Needs to be highly analytical & be able to think through system touch points and possible cross impacts.

· Ability to work under pressure & with minimum micro-level supervision

· Working knowledge of Java is a plus but not mandatory

No comments:

Post a Comment