Friday, April 15, 2011

Business Intelligence Architect - (US-CT-Stamford)


Business Intelligence Architect - (US-CT-Stamford)

Compensation: 
$120K - $130K / Year
Minimum Education: 
Bachelors
Job Type: 
Full Time
Jobcode: 
TWJA5

Business Intelligence Architect to work with an existing OLAP (SSAS 2005) system with multiple measure groups representing various functions of the company. Systems are used to report front-office risk, P&L and credit exposures to Management. 

Responsibilities: 
· Maximize system performance by using knowledge of SSAS/SSRS internals including MDX and OLAP configuration 
· Generate reports using information stored in SSAS cubes 
· Build complex MDX and C#.Net components to fulfill complicated reporting requirements 
· Extend existing OLAP solution for financial risk data to include Trade Financing using SSAS 2005 and above 
· Generate and customize risk and P&L reports/pivots for Management 
· Improve reporting capability by using pivot tables on top of custom MDX queries 
· Work with business users to gather and implement requirements 
· Tune SQL and date storage options to increase performance of the database 
· Special projects and additional responsibilities/administrative functions as assigned 

Requirements: 
· 5+ years experience developing SSAS cubes including MDX and partitioning 
· 7+ years of extensive experience developing robust applications 
· 5+ years experience of data modeling with demonstrated expertise in data warehousing applications 
· Experience using MS-SQL is preferred 
· 3+ years experience working with an SSRS 2005 and above 
· 7+ years experience of C#.Net application development experience 
· Excellent written and oral communication skills 
· Understanding of risk/exposure calculations is preferred 
· Good understanding of risk and financial terminology 
· Experienced working with business users, understanding cryptically expressed requirements and in establishing a good working relationship with end users 

Email resume in Word to TheBigGameHunter@cisny.com. Please include the job code for the position with your resume. 

NO RELOCATION. NO VISA TRANSFERS. NO OVERSEAS RESUMES. NO 3RD PARTIES. 

To receive a complimentary subscription to my job search ezine, No B.S. Job Search Advice, go to www.JeffAltman.com to subscribe. Receive tweets from Twitter with job search tips – TheBigGameHuntr AND become a fan on Facebook http://goo.gl/Argw