Data Architect Job Posting

Job Title:	Data Architect
Job ID:	Job No4
Company:	Smartworks LLC
Position Type:	Contract
Pay Rate:	$80/hr on W2
Date Posted:	Aug-07-09

Required G.C and Citizens

Title: Data Architect - Advanced
Location: NewYork, NY.
Duration: 6+months
Rate: $80/hr W2. (Face to Face required after telephonic).

Job Description:

Gather requirements, design and
build complex data marts (and associated extract transform and load
processes) and complex analytical cubes using Microsoft Sql server
technologies.
Experience with complex Mdx scripting as well as experience with setting up
security around the cube using native Sql server facilities.
Experience with Microsoft Sharepoint/Performance Point/Proclarity Analysis Server
Experience building Dashboards using Proclarity.
Experience creatinging integrated views of two cubes for drill thru/across and down

Required Skills:

Requires technical and business knowledge in multiple disciplines/processes. Typically possesses 5 to 7 years of relevant work experience.
Two to three years of modeling.
• Exposure to database administration skills and practices.
• Mid-level Structured Query Language skills.
• Skills in business process engineering, identifying alternative processes, identifying
compound steps/activities in existing processes.
• Delivery of at least three data warehouse/marts from specification through end-user
acceptance testing.
• Exposure to multiple (two or more) business intelligence tools.
• Exposure to multiple (two or more) data integration tools.
• System analyst experience (analyzing source systems is highly desired).

Critical Skills:
Two to three years of modeling and BI experience.
Strong dimensional modeling experience
SQL Server Analysis Services Design & Performance Tuning
SQL Server Reporting Services Design & Performance Tuning
Performance Point Design & Performance Tuning
ProClarity Design & Performance Tuning
Sharepoint Design & Performance Tuning
• Delivery of at least three data warehouse/marts from specification through end-user
acceptance testing

Location:	US-NY-New York City
Telecommute:	No (Onsite Position)
Contact Name:	Michael
Contact Phone:	908-450-5358
Contact Email:	michael@smtworks.com